We provide IT Staff Augmentation Services!

Sr. Etl Development Lead/teradata Developer, Business System Analyst, Data Analyst Resume

Philadelphia, PA

SUMMARY:

  • 11 years of IT experience focusing on Data warehousing, ETL/ELT process and Business Intelligence.
  • Expertise in ETL Tools - IBM InfoSphere DataStage and Quality Stage, Informatica Power center and SSIS and knowledge in reporting tool SSRS.
  • Expertise in data integration, data migration, and extracting data from various data sources like Mainframe, Oracle, Teradata, DB2, SQL Server, AS400, Text files, XML files, and Excel files.
  • Started carrier as Mainframe/AS400 developer with Infosys Inc, one of the largest IT firms.
  • Experienced SQL, PLSQL, TSQL, and Unix Shell scripting programmer
  • Strong understanding of Data ware housing Concepts, Data Modeling (Fact and Dimension tables, Star and Snowflake Schema).
  • Currently working as Sr ETL Development Lead as well as Business system Analyst in various projects in Confidential .
  • Good business knowledge in Healthcare, and Retail Domain.
  • Good working knowledge in all stages of Software Development Life Cycle (SDLC) including Requirement gathering, Analysis, Design, Development, Testing, UAT, Production deployment and Production Support.
  • Experience in various Teradata Tools like, Bteq, FastExport, FastLoad, Mload, TPump, TPT
  • Experience in analyzing different kinds of Data using complex sql and creating business rules, gathering business requirements, documenting them, and converting them into robust system designs.
  • Strong Data analytical, Data profiling, Gap Analysis skills
  • Expertise in creating source to target Mapping Document and Functional Requirement document (FRD) based on business requirements.
  • In depth knowledge in designing and enhancing ETL frameworks and ETL solutions.
  • Expertise in Performance tuning of DataStage Jobs by choosing best partitions, stages, Transformations, indexes and SQL queries.
  • Extensively worked on analyzing and fine-tuning long running queries for performance improvement
  • Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using TSQL and Oracle PL/SQL
  • Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer. Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
  • Experience in estimation, project planning and leading teams.
  • Managing and coordinating onshore and offshore teams.
  • Worked on various Development, Maintenance, Enhancement, Bug Fixes, and Production Support projects.
  • Strong analytical, problem-solving and organizational skills.
  • Excellent interpersonal and communication skills, and experience in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL/BI: IBM InfoSphere DataStage and Quality Stage (8.5, 11.3), Informatica, Power Center 9.5/9.1, PowerExchange for DB2, SSIS, SSRS, Crystal Reports

Databases: Oracle, SQL Server, DB2, Teradata, DB2/400, Mainframe, AS400

Functional Skills: Business requirement gathering and analysis, Create Functional requirement, Data analysis, Data mapping, Design solution, Technical design

Languages: SQL, PL/SQL, TSQL, Teradata bteq, Unix Shell Script(Bash), Mload, Fast Export RPG, RPGILE, CL, CLLE, COBOL 400, COBOL, EZT, JCL, Basics of C

Tools: Teradata SQL Assistant, Toad, Putty, WinSCP, HP ALM, TFS, Anthill Pro Share Point, MS Office, SQL Server 2014 Management Studio, IBM MQ Hawkeye, ROBOT Scheduler, JS Scheduler, File Aid, Aldon, Implementer, Aplus, Abstract, IWS job scheduler, Control M

WORK EXPERIENCE:

Confidential, Philadelphia, PA

Sr. ETL Development Lead/Teradata Developer, Business system analyst, Data Analyst

Responsibilities:

  • Interact with Business users, Project stake holders and External vendors and understand and analyse the Business requirements, perform assessment and propose design solutions.
  • Data profiling, Data Analysis, Gap Analysis and create Transformation Rules, and create Source to Target Data mappings (STM) and Functional Requirement document (FRD).
  • Design the data model based on source data that we bring in, and work with Data modeler and DBAs for implementing the Data model.
  • Work with Developers and Testers, for Mapping and FRD walk through, Design ETL jobs, Test scenario preparations.
  • Perform UAT testing and provide UAT signoff for production deployment.
  • Gather business requirements by interacting with Business users and work with the business team in identifying the business rules and documenting them.
  • Design solution, create data model and conduct design discussions with client technical leads.
  • Lead development efforts and review/update technical designs, Data Mapping rules and coding standards.
  • Development of DataStage Jobs, Sequences, Shell Scripts, Bteq scripts, Routines and Scheduling jobs.
  • Design different interfaces for EDW to receive/send data from/to various systems and vendors.
  • Performance tuning of DataStage Jobs by choosing best partitions, stages, table indexes and SQL queries.
  • Development and performance tuning of bteq/procedures for moving data through different EDW layers.
  • Created Teradata Mload, Fast load, Fast Export, TPT scripts.
  • Created reusable jobs/Bteq scripts, which can be used for different customer/vendor extracts.
  • Created tool to filter records from Extracts based on configurable filter condition.
  • Unit testing of components and documenting results.
  • Migrate code by creating branch and using TFS and Anthill to different environments and coordinate production support team and other teams for production deployment.
  • Prepare release notes and Conduct release meetings with Production Support Team.
  • Work with business users in new Enhancements/Defect Fixing.
  • Assembly Testing of Modules and support system testing (SIT).
  • Conducted SME reviews to ensure job design, coding standards and best practices.
  • Coordination between different teams (includes Onshore and Offshore teams).
  • Get status from offshore on daily basis and report the progress to Manager/Client.
  • Daily offshore calls to get status answer their queries and prioritize/assign the works.
  • Support business users in UAT and create reports for business users.
  • Production Support and job monitoring.
  • Take full responsibility of a project from Analysis till deployment.

Environment : IBM InfoSphere DataStage and Quality Stage (8.5, 11.3), SSIS, SSRS, TeraData, Teradata SQL assistant, Advanced Query Tool, DB2, Oracle, SQL Server, HP ALM, WinSCP, Putty, Unix Commands, SharePoint, SQL Server 2014 Management Studio, TFS, Anthill, IWS

Confidential, Framingham, MA

Technology Lead, Onsite Coordinator, Informatica Developer

Responsibilities:

  • Interacted with Data modelers, DBA, IT SMEs, Business SME to identify various source systems/applications to staging and various sources to data warehouse.
  • Identify each feed to data warehouse from various applications and prepare detailed interface diagram.
  • Prepare impact analyse document, Technical Design Specifications
  • Present Impact analysis documents and Technical design documents to client managers and get a sign off.
  • Identify applications for phased implementation.
  • Identify the mappings which have SKU number and identify source and target tables of each mapping.
  • Make mapping changes and review the mapping changes done by offshore.
  • Prepare integration test plan and execute integration testing.
  • Unit and Integration testing.
  • Assistance in system testing and UAT.

Environment: : Informatica 9.5, AS400, DB2, Control M, UNIX Shell Scripts, WinScp, Putty, Star team,

Confidential

Technology Lead, Offshore Lead, Informatica developer

Responsibilities:

  • Project tracking and scheduling
  • Team Coordination - Offshore Co-ordination & mentoring team members
  • Developed mappings to extract data from Oracle to SQL Server, Oracle, Mainframes using PowerCenter and Power exchange
  • Worked with Source Analyser, Transformation designer, mapping designer and Workflow Manager.
  • Created various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures and Router. Fine-tuned the mappings for optimal performance.
  • Written SQL Queries, PL/SQL, UNIX Shell Scripts.
  • Checked performance tuning/debugging at different levels like workflows, mappings, database etc.
  • Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
  • Used Source Analyser to import the source and target database schemas and the Mapping Designer to map the sources to the target.

Environment: Informatica 9.1, Informatica Power Exchange 9.1, Oracle 11g, MS SQL Server, DB2, STAR team, PL/SQL, UNIX Shell Scripts, WinScp, Putty

Confidential

Technology Analyst, Offshore Lead, AS400 programmer

Responsibilities:

  • Project tracking and scheduling
  • Team Coordination - Offshore Co-ordination, Mentoring team members
  • High Level Design, Detailed Design, Impact Analysis.
  • Coding, Code review, Test Plan preparation, Unit Testing and System Testing.

Environment: AS400, RPG, RPGLE, CL, CLLE, DB400, Aldon, OS400, Abstract, JS Job scheduler, Crystal Reports

Confidential

Technology Analyst, Offshore Lead, Mainframe programmer

Responsibilities:

  • Project tracking and scheduling
  • Team Coordination - Offshore Co-ordination, Mentoring team members
  • High Level Design, Detailed Design, Impact Analysis.
  • Coding, Code Review, Test plan preparation, Unit testing and Integration Testing.

Environment: Mainframe, DB2, File Aid, Cobol, EZT.

Confidential

Senior Software Engineer, Offshore Lead, AS400 programmer

Responsibilities:

  • Team Coordination - Offshore Co-ordination & Mentoring team members
  • High Level Design, Detailed Design, Impact Analysis.
  • Coding, Code Review, Test Plan preparation, Unit testing and Integration Testing.

Environment: AS400, RPG, RPGLE, CL, CLLE, DB2, Hawkeye, Implementer, Robot, OS400

Confidential

Software Engineer, Offshore Lead, AS400 programmer

Responsibilities:

  • Analysis
  • Design
  • Coding
  • Unit Testing
  • Integration Testing.
  • Knowledge Management Activities

Environment: AS400, RPG, RPGLE, CL, CLLE, DB2, Hawkeye, Implementer, Robot, OS400

Hire Now