| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name (Nanda)
PHONE NUMBER AVAILABLEEMAIL AVAILABLEBrookfield, Wisconsin
PROFESSIONAL SUMMARY: Over 13 years of experience in developing and designing ETL methodology for supporting data transformations using Informatica Power Center. Experience in ETL developer, Data Analyst, ETL Testing, Implementation and Maintenance,Sr software engineer of Data Warehouse environments. Certified Scrum Master CSM .
Played developer-scrum master role for the team for 2 years. Competent in all stages of the project life cycle, business analysis, data modeling, ETL architectures, development.
Experience working on run continuous ETL jobs. Experience of using the scheduler like Autosys and Control-M. Experienced in ETL processes, Data warehousing methodologies and concepts. Experience in Analyzing the data coming from different sources. Hands on experience working on Flat Files.
Some Experience in UNIX Shell scripting. Extensively worked on reusable transformations, parameter files, edit rules and validation of business rules.
Expert in unit testing, system integration testing, implementation, maintenance, and performance tuning.
Expert in developing test plans, review test cases, review test scripts and write user documentation. Worked as translating requirements to functional design documents.
Expert in writing SQL queries and optimizing the queries in Oracle. Experience in solving technical, business and optimization related challenges. Experience in Gitlab. Worked in Agile models.EDUCATION:Bachelor of Computer Science Engineering (2003-2007) from UP Technical University, India.TECHNICAL SKILLS:LanguagesDb2, SQL, Unix Shell Script , Data warehousingBI/ETL ToolsInformatica Power Centre 8.x/9.x/10.x, GitlabAgile ToolsAgile Craft, JiraSchedulersAutosys, Control-MToolsDbeaver , Putty, Service Now , CherwellClient: NorthWestern Mutual -Downtown WI Nov 19-Till DateRole: Sr Software EngineerProject Name: BIIP SystemLocation: Downtown WisconsinDescription:BIIP ODS is an Operational Data Store designed to support a large insurance system.
Responsibilities: Understanding business needs and requirements for enhancements to systems, assessing the impact on the system architecture and modifying the system design to meet the requirements. Detail and results-oriented Data Warehouse lead and developer with proven success in designing and building Data Warehousing solutions. Expert in data analysis, conversion, and integration. Experience in all phases of data warehouse development including analysis, requirements gathering, relational and dimensional data modelling, ETL design and development, and data validation. Dedicated, ethical, and committed to excellence in all aspects of work and life. Sharing knowledge within team for different area within system and technology. Help team to review their task. Work with business owner to get new business features for growing more as a team.Client: NorthWestern Mutual via Infosys-Franklin WI Oct 18- May 19Role: Technical AnalystProject Name: DW-TechBlazersLocation: Franklin WisconsinDescription:TechBlazers is a Data Store designed to support a large insurance system.Responsibilities: Understanding business needs and requirements for enhancements to systems, assessing the impact on the system architecture and modifying the system design to meet the requirements. Deducing system requirements based on business needs and laying out a scalable architecture for the solution to ensure success of the program. Designing performance efficient data access layers and a role-based security setup for the solution. Identifying risks, business critical issues, performance issues and fixing them. Co-ordinate with various customer stake holders like end users, system owners/custodians and support groups to provide continuous service to business users and for implementing the system enhancements. Creating, along with obtaining Technical/ gateway approvals of the following documents a) Requirement Document b) Design Document c) System Architecture d) Mapping Document Used Informatica Designer for developing various jobs to extract, transforming, integrating and loading data into Data warehouse.
SFTP of the data files as designed per requirements. Worked in Agile environment. Worked on Cherwell and Azure. Define project scope and schedule while focusing on regular and timely delivery of value Develop detailed project plans when applicable Organize and lead project status and working meetings Manage risks and issues Correct deviations from plans Perform delivery planning for assigned projects Assist in team development while holding teams accountable for their commitments, removing roadblocks to their work Leverage organizational resources to improve capacity for project work Support the Product Owner in managing customer expectations for project deliverables Manage stakeholder communications Contribute to ongoing process improvement initiatives to implement best practices for Agile
Promote empowerment of the team Ensure that each team member is fully engaged in the project and making a meaningful contribution Encourage a sustainable pace with high-levels of quality for the team Use knowledge and experience in managing projects in a traditional and Agile environment to blend/apply principles and practices providing the right balance of agility and predictability Lead and manage at an enterprise level small and medium projects consisting of multiple teams Play a consultative role to help put in place the appropriate people, process, and tools to optimize the efficiency of the project team Use good judgment and skill in situations that require a hybrid traditional and Agile approach, to develop a project management approach that is suitable for planning and managing the effort to achieve the project goals within designated project constraintsEnvironment: SQL / PLSQL Scripting, shell Scripting, Agile, Informatica Power Center 9.x/10/xClient: TCS-Indianpolis IN Aug 09- Jun 16Role: ETL Informatica Developer and Data AnalystProject Name: Information Management (IM CoE) CoE - Activity SystemsLocation: Noida,IndiaDescription:IM COE is designed with the objective to provide consolidated CoE services for Activity System which is designed to support a large pharma based out of USA Sales & Marketing organizations by collecting and consolidating sales, medical, and marketing interactions with customers (Life Science and Health Care Domain). The system consists of an ODS and extraction, transformation, and loading (ETL) mappings used to transform and load the activity data. The Project named Activity system consists of two following areas:Temporary Validation Area (TVA) consolidates the files from different vendors in a standardized format, validates the same against alignment, product and customer master data and makes it available to Activity TVA for loading into Activity ODS.Activity ODS is an Operational Data Store designed to support a large pharma based out of USA Sales & Marketing organizations by consolidation of transactional sales activity data from VEEVA, PW, TVA and SAPHere Veeva System was one of the source system to the project.Common (US, Australia, UK, Germany, Italy, France, Spain, Japan, Brazil, and Mexico etc): Activity ODS (including Collaborator Activity data) Temporary Validation Area (TVA)US: Compliance Reporting
Partner Data Interface (PDI)Responsibilities: Understanding business needs and requirements for enhancements to systems, assessing the impact on the system architecture and modifying the system design to meet the requirements. Deducing system requirements based on business needs and laying out a scalable architecture for the solution to ensure success of the program. Designing performance efficient data access layers and a role based security setup for the solution. Identifying risks, business critical issues, performance issues and fixing them. Co-ordinate with various customer stake holders like end users, system owners/custodians and support groups to provide continuous service to business users and for implementing the system enhancements. Creating, along with obtaining Technical/ gateway approvals of the following documents a) Requirement Document b) Design Document c) System Architecture d) Mapping Document Used Informatica Designer for developing various jobs to extract, transforming, integrating and loading data into Data warehouse.
Extensively used various Transformations like Source Qualifier, Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
Analyzed the session logs, bad files and error tables for Troubleshooting mappings and sessions.
Performance tuning of mappings, transformations and sessions to optimize session performance.
Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
Coordinate with customers and staff and provide support to all data analysis.
Production support.Environment: SQL / PLSQL Scripting, shell Scripting, MS Visio, Informatica Power Center 9.x/10/x, Toad, Service Now,Remedy,Quailty CenterClient: TCS-Indianpolis IN May 09 Jul 09Role: ETL Informatica Developer and TesterProject Name : MDI Level-3 Site Impln COE-OffLocation: Noida,IndiaDescription:The Project is related to the testing of the running site i.e.ALCOBENDA, KINSALE, PR06 as the changes have taken place due to the Release11 occurrences
Responsibilities: Understanding business needs and requirements for enhancements systems, assessing the impact on the system architecture and modifying the system design to meet the requirements of a robust business intelligence solution. Identifying risks, business critical issues, performance issues and fixing them. Co-ordinate with various customer stake holders like end users, system owners/custodians and support groups to ensure compatibility and usability of solution. Creating, along with obtaining Technical/ gateway approvals of the following documentsa) Requirement Documentb) Design Documentc) System Architectured) Mapping Document Testing and Validation activities. Migrated ETL code from Dev to QA and then from QA to Prod for new release cycles.
Developed testing strategies and performed in-depth testing to ensure data quality. Production support.Environment: Informatica Power Center 9.1, PL/SQL, UNIX, Windows XP.Client: TCS-Indianpolis IN Mar 09-Apr 09Role: ETL Developer and TesterProject Name : Pharmaceutical Delivery Systems (PDS)Location: Noida,IndiaDescription:The solution is being built on Oracle 10g with shell scripting. Represents the parts of the devices business located at Fortune Park. In the Northwest corner of Indianapolis. PDS is NOT an organization, but is rather a tightly-integrated cross-functional collection of organizations that span the device lifecycle globally from concept through commercialization and manufacture.
Responsibilities: Modifying the system design to meet the requirements of a robust business intelligence solution. Low level system designing and coding. Played Scrum Master role for the team. Performing regular code walkthroughs to capture logical defects and to ascertain impact of changing requirements on existing code components. Testing and Validation activities. Created complex Informatica mappings with extensive use of Aggregator, Union, Filter, Router, Normalizer, Joiner and Sequence generator transformations. Performed performance tuning of source level, target level, mappings and session. Involved in modifying already existing UNIX scripts and used them to automate the scheduling process. Production support.Environment: Informatica Power Center 8.x, PL/SQL, UNIX, Windows XP.Client: : TCS-Indianpolis IN Apr 08-Feb 09Role: ETL/Informatica Developer and testerProject Name : Lab Ossce solutionLocation: Noida,IndiaDescription:The solution is being built on Oracle 10g with Shell scripting. There is a center specific data mart for each site. Site specific data needs to be extracted from repository needed to be integrated with site specific local application data and then to be loaded globally.
Responsibilities: Requirement gathering and analysis. Design and develop mappings to incorporate the existing SQL code logic into Informatica using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy.
Low level system designing and coding. Provided SQL scripts to validate source to target validations.
Involved in UAT defect fixing.
Performing regular code walkthroughs to capture logical defects and to ascertain impact of changing requirements on existing code components. Testing and Validation activities. Production support, cutover planning and deployment.
Environment: Informatica Power Center 8.x, PL/SQL, UNIX, Windows XP. |
