SUMMARY:

• Over 12 years of IT experience in the Design, Analysis, Development, Modeling, Implementation and testing of various applications, Decision Support Systems & Data Warehousing applications and Over 7 years of solid experience in Extraction, Transformation and Loading (ETL) mechanism using Talend, Datastage and Informatica and more than 5 years of experience in data modeling and AWS Redshift, TERADATA. Expert in full life cycle development for building a data warehouse and datamart including 3 years of onshore experience worked with customer in USA and Australia, have worked extensively in AGILE methodology.
• Good experience on ETL tool like - Talend, Datastage, Informatica
• Worked extensively with AWS Redshift, TERADATA- good experience on creating Datamart, FACTS and DIMENSIONS for reporting use.
• Have good experience on creating Semantic layer design.
• Good experience on preparing High level design document like SRS, HLD, IDDD, SIDIA.
• Have good experience in preparing Scope document impact (IA)
• Good experience on tool Erwin 7.3 for DATA MODELLING and DESIGN (LDM/PDM),
• Strong knowledge in Dimensional modeling like Star Schema and Snowflake Schema.
• Very good experience on Mapping document preparation for ETL input for development
• Extensively worked with SVN (Subversion tool.)
• Worked on RDBMS like Sybase, Oracle.
• Worked on OS like Windows, UNIX platforms.
• I have around over 5 years of experience on T ELECOM domain, Capital and good knowledge on Banking Applications.
• Having good problem solving skills and leadership qualities, handling the team by resolving their issues and concerns which they raised during implementation, testing and deployment.
• Having direct interact with the business to perform in decision making and requirement analysis
• Worked extensively with the AGILE methodology where need to perform different kind of roles and areas for discovery, analysis, design implementation and testing
• Worked on cost and effort estimation for the new scope where we need to access actual for the business requirements.
• Good knowledge in Ataccama data quality tool for data profiling and data analysis using DQC and DQ Dashboard.
• Having good experience with Control-M, Appworx and TIDAL scheduling tool
• Good knowledge on Alteryx analytics for data preparation and analytics process

TECHNICAL SKILLS:

DWBI Tools: Talend ETL, Datastage, Informatica 9.5.1,9.1

Modeling Tool: Erwin 7.3

DQ Tool: Ataccama

Reporting Tool: BO reporting and analysis

Operating Systems: Windows XP, Windows, Windows 7, Unix, Linux

Databases: Teradata, Oracle, Sybase,BIGDATA Capabilities,Cassandra, Spark, FiloDB

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead

• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Provide data flow diagram for multiple source systems for understanding the data lineage.
• Do the impact analysis based on the requirements and existing source data
• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the customer and offshore team to implement the requirements using Talend ETL.
• Clarify the concerns raised from development team as ETL Lead.
• Perform code review, impact analysis, involving in problem solving,
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Mentor the offshore team members by providing assistance with the functional environment/Technical aspects
• Understand the Redshift architecture that includes S3, FACT, DIM data load and Unload data back to S3 from target tables
• Automate the metadata driving mechanism thorough Talend ETL
• Capture the audit log for each flows from source to target
• Implement the restartability process from where it failure by using Talend

Confidential

Technical specialist

• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Provide data flow diagram for multiple source systems for understanding the data lineage.
• Do the impact analysis based on the requirements and existing source data
• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the customer and offshore team to implement the requirements using Talend ETL.
• Clarify the concerns raised from development team as modeler.
• Perform code review, impact analysis, involving in problem solving,
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Mentor the offshore team members by providing assistance with the functional environment/Technical aspects

Confidential

Offshore Project Lead

• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the Onsite co-coordinator and offshore team to implement the requirements
• Perform code review, impact analysis, involving in problem solving,
• Come up with ETL requirements based on existing ETL CODE developed based on Bankware Rate Driver ETL
• Come up with analysis documents based on comparison between existing ETL and TOBE ETL
• Creation of ETL Detailed Design documents, Mapping Specification, Data Flow Diagram documents
• Created Teradata BTEQ scripts
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Mentor the offshore team members by providing assistance with the functional environment/Technical aspects
• Also performed PDO based optimizations on the ETL Code
• Effectively utilized various TPT connection operator connections for resolving the performance bottleneck issues
• Performed detail analysis for existing SPS Fleet and come up with design for TO BE approach.

Confidential

Technical Lead

• Perform ETL design activities, creating high level design for ETL implementation
• Having daily interaction with the Onsite co-coordinator and offshore team to implement the requirements
• Perform code review, impact analysis, involving in problem solving,
• Come up with analysis documents based on comparison between existing ETL
• Creation of ETL Detailed Design documents, Mapping Specification, Data Flow Diagram documents
• Created Teradata BTEQ scripts
• Optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular to particular ETL logic
• Analyze the source data, do impact analysis, see how the data would fit into the data model designed and how it would help in feeding the reports
• Mentor the team members by providing assistance with the functional environment/Technical aspects

Confidential

Business Analyst

• Developing facts and dimensions based on the business requirements
• Identifying source data to map them into target
• D esigning activities like creating PDM and semantic layer design
• Creating Mapping document which input for development activities for the developer
• C larify the concerns raised from development team as modeler. the data would fit into the data model designed and how it would help in feeding the reports

Confidential

Solution Designer

• P erforming Semantic layer design
• Developing facts and dimensions
• Identifying source data to map them into target
• D esigning activities like creating LDM and PDM
• Creating Mapping document which input for development activities for the developer
• C larify the concerns raised from development /production/testing team as modeler

Confidential

ETL Developer

• Developing the DataStage Parallel jobs to populate source data to staging tables.
• Source File Validation and Extraction.
• Exception and Rejection Handling
• Developing the jobs extensively on different stages like Mload and Transformer stages.
• Handling the rejected data.
• Creating and executing the unit test cases.
• Involved in QA/Test and Production Support.

Confidential

Developer

• Source File Validation and Extraction.
• Exception and Rejection Handling.
• Design and various transformations are implemented through designer.
• Incremental Loading.

Confidential

Developer

• Design and development of ETL process using Datastage to load data from file system into the target Oracle database.
• Design and various transformations are implemented through designer.
• Designing and optimizing the Mapping to load the data in slowly changing dimension.