SUMMARY

• Over 10+ years’ experience Years of experience in development and design of BI methodology for supporting data transformations and processing in a corporate wide BI Solution using Informatica, Teradata, DataStage, Oracle, GreenPlum
• Worked extensively inData Warehouse and Data Integration projects.
• Extensive design and development knowledge of transforming unstructured, semi - structured data to XMLs using Informatica DT (Data Transformation) Studio.
• Thorough understanding of software development life cycle and agile methodology.
• Strong analytical and logical reasoning ability, problem solving attitude, sound communication skills and customer centric approach.
• Experience in working on Informatica transformations such as Expression, Aggregator, Filter, connected and unconnected Lookup, Router, Sorter, Union, Joiner, Rank, Sequence generator and Normalizer transformations and re-usable Transformations and Mapplets.
• Knowledge on different transformations like Parser, Serializer, Mapper and Streamer to covert the XML documents to a different XML structure or Schema.
• Good experience of leading a team and managing quality for the project.
• Excellent knowledge on Insurance domain.
• Strong understanding on Enterprise communication area.
• Excellent experience on working wif .JSON files / XML files.
• Having good hands on experience Xml (Parser & Generator), UDT, Web service (consumer, Source & target) & JMS(Java Messaging Service)
• Experience in Full Life Cycle of Data Warehousing projects.
• Extensive knowledge of working in Agile Methodology& closely coordinated wif Release Management team in order to control a software build through different stages and environments; including unit testing and deploying software releases.
• Successful in meeting new technical challenges and finding solutions to meet the needs of the client
• Strategic thinking, solutions and road maps while driving architectural recommendations.
• Strong Leadership qualities in mentoring and guiding team wif best practices.
• Experience leading Onsite and Offshore team.
• Experience in defining Process Models, Detail Design Specifications, Logical and Physical Data Models.
• Subject matter expert in Data Extraction, Transformation, and Loading (ETL) data from different sources using ETL - Informatica Power Center, Informatica Cloud, Informatica Data quality,DATA STAGE, MSQL,Oracle SQL and PL/SQL.
• Agile wif good knowledge of relational datawarehouses like Teradata and exposure to NoSQL database.
• Working Knowledge of converting HIVE SQL data to Snow flake Database
• Experience wif data analysis, data architecture, data cleansing and data quality.
• Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.
• Knowledge on Informatica B2B Data Transformation Studio to parse the XML files.
• Knowledge on Unstructured Data Transformation to integrate B2B service wif Informatica Power Center.
• Experience in Informatica Administration Software Installation/Configuration
• Excellent in Performance Tuning of ETL and Database.
• Experience in Scripting (Perl, Bourne Shell) and scheduling jobs using Control M, OPC and Autosys.
• Experience wif Business Objects and OBIEE reports.
• Expertise in developing and reviewing the JIRA, TFS, test cases and reporting bugs.
• Experience in manual testing, which includes Web testing, functional testing, Usability testing, GUI testing, and Regression Testing.
• Conducted data analysis using SQL Scripts to answer the questions/ queries by the Subject Matter Experts.
• Extensive experience in organizing and facilitating interviews and workshop, wif subject matter experts SME, users, and business stakeholders,
• Experience using MS Visio, MS Project and MS office tools like MS-Word, PowerPoint, Excel, and Access.
• Documentation of Test Plans, Test Cases, Test Scripts, Test Procedures based on the Design
• Good understanding of scripting in Python and pyspark.
• Re-platform testing and Upgrade smoke testing from Informatica 9.1 to Informatica 9.6.

TECHNICAL SKILLS

Methodologies: Waterfall, Agile,UML

Scheduling/migrations: Autosys, Control M, Mainframe Operation planning and control(OPC)

Service and Incident management: Xmatters, Service now, Webstar

Project Management: MS Project, JIRA, Service now, TFS

Business Applications: MS Office Suite - MS Word, Excel, PowerPoint, MS Outlook

Business Intelligence: Informatica Power Center,DataStage

Migrations and versioning tools: Harvest, Bitbucket, Jenkins

Databases: SQL Server, MS Access, Teradata, Oracle GreenPlum

Operating Systems: Windows, UNIX

Other Tools: Altova XML SPY, Informatica Data Transformation Studio, Notepad ++, SQL Developer, Toad, Hermes, JMS

PROFESSIONAL EXPERIENCE

Confidential, Madison WI

Technology Lead

Responsibilities:

• Providing design and solutions to requirement stated by Business Analysts and Users.
• Implementing Solutions using Informatica Power Center and DT Studio.
• Development of Informatica real time jobs connecting JMS messages queues.
• Developing Informatica web services.
• Developing Parsers and mappers using DT studio.
• Thorough understanding of XSDs
• Transforming complicated XMLs to simplified XMLs (using a simplified XSD)
• Involved in knowledge transition, mentoring team and knowledge management.
• Creation of tools and reusable components wherever possible.
• Contribution in business value additions.
• Good Experience wif tools that facilitate agile development such as Jira, Team Foundation Server.
• Conducted the gap analysis and analyze various gaps and develop actions to fill those gaps.
• Reviewed, analyzed, and evaluated business systems and user needs. Documents requirements, defines scope and objectives and formulates systems to parallel overall business strategies.
• Assist wif Sprint testing and user acceptance testing when needed
• Support project initiatives, including identifying and analyzing preliminary business needs, time and resource estimates, defining the project scope and objectives and working wif business users
• Responsible to Design Data model, Informatica Mappings for data integration, Development, Administration, implementation of the system
• Performing source system data analysis in order to manage source to target data mapping.
• Work wif automation development team to understand the source and target data models.
• Work wif various business stakeholders to identify their data/information needs.
• Creating design documents and mapping documents as per requirements
• Develop, adhere to, and be a proponent for data warehouse development standards, including ETL standards and best practices.
• Develop a technical work plan and coordinating wif development team and projects.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Actively worked on resolution of issues in production failures and issues raised by the clients
• Conducting quality reviews of design documents, code and test plans.
• Ensuring on-time delivery and submit the monthly SLA tracker for the critical jobs to clients
• Monitoring the long running jobs and performing tuning activities to minimize the run time.
• Accountable for Unit Testing, Integration testing, Defect analysis and fixing

Environment: Team Foundation Server(TFS), Jira, Service now, MS word, MS Excel,MS Power Point, New Relic,Agile., Oracle, InformaticaPowerCenter, Informatica DT Studio, Informatica Developer, UNIX

Confidential

Technology Lead

Responsibilities:

• Review deliverables for a service request or break fix request.
• Maintaining Quality code for the project.
• Creation of tools and re-usable components wherever possible.
• Contributing in business value additions.
• Conducting DataStage trainings on account level and unit level.
• Deploying the code, Performance optimization in existing jobs.
• Designed, involved in Development, implementation of the system
• Scheduling and estimation of work.
• Identify issues and dependencies, escalate them appropriately and bring them to closure.
• Joining review meetings wif the team members to assess the completion status on a daily basis.
• Escalation handling
• Review of development of ETL Programs and Reports as required.
• Review of Unit Testing, System Testing and defects tracking. and fixing non-standard table structures and ETL processes
• Automated daily space monitoring and compression scripts in UNIX.
• Testing and Coordination efforts for activities like Informatica Migration.

Environment: DataStage, UNIX, DB2, Mainframe, Ultra edit, Toad

Confidential

Technology Lead

Responsibilities:

• Analyzing and reviewing specifications received from Clients.
• Designing the ETL jobs(High Level design and detailed level design)
• Development of ETL jobs, Unit testing, integration testing and regression testing.
• Deploying the code, Performance optimization in existing jobs.
• Minor enhancement to existing code.
• Involved in knowledge transition, mentoring team and knowledge management.
• Guiding and helping team for any technical issue.
• Working on estimations.
• Involved in group/peer reviews.
• Involved in technical automation activities.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse
• Maintain cross-business responsibilities by providing end-user support to multiple organizations wifin the company. Responsible for source system data analysis, variable gap analysis, data extraction design and coding, and data modeling.
• Co-ordinated wif the Business Analysts, Data Architects, DM's and users to understand business rules
• Supporting and participating in business meetings, requirement gathering meetings and issue analysis meetings as requested
• Conduct quality reviews of design documents, code and test plans.
• Accountable for Unit Testing, Integration testing, Defect analysis and fixing
• Testing coordination wif functional users and business application teams for any issue
• Monitoring the long running jobs for optimizing the performance.
• Fixing of the ongoing issues in Production and providing RCA of the presently known problems
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.

Environment: DataStage, UNIX, DB2, Mainframe, Ultra edit, Toad

Confidential

Technology Analyst

Responsibilities:

• Responsible for design and development of the Datastage jobs.
• Co-ordination wif other team members for the queries/issues which they faced while development & testing of the Datastage jobs.
• Involved in developing some proof of concepts (POC) for design improvements.
• Co-ordinated wif the Business Analysts, Data Architects, DM's and users to understand business rules
• Supporting and participating in business meetings, requirement gathering meetings and issue analysis meetings as requested
• Conduct quality reviews of design documents, code and test plans

Environment: DataStage 8.X, Unix, Oracle

Confidential

Technology Analyst

Responsibilities:

• Providing solutions to change request raised by SMEs.
• Application production support.
• Development of ETL jobs.
• Development of Teradata code and utilities (Macros, BTEQ, FastLoad, Mload).
• Providing minor enhancement (addition/removal of columns etc. to target tables) to the system based on requests raised by SMEs.
• Analyzing issues related to any inconsistency or discontinuity of data.
• Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using Fast Load, Multiload and BTEQ utilities of Teradata.
• Monitoring the long running jobs for optimizing the performance.
• Fixing of the ongoing issues in Production and providing RCA of the presently known problems
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Actively worked on resolution of issues in production failures and issues raised by the clients

Environment: DataStage, MainFrame, Teradata, MainFrame OPC scheduler, Webstar, JCL, COBOL