Technical Lead Resume
Indianapolis, IN
SUMMARY
- 8+ years of Enriching Software Development Experience in Analysis, Design, Development and Production/Maintenance of Data Warehousing Applications.
- Thorough knowledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Server Manager, Workflow Manager, Workflow Monitor).
- Designed multi - dimensional models (Star, Snowflake schema). Experience in Data Modeling, Business Process Analysis and Reengineering.
- Involved in Development of Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
- Experience in Data Extraction from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2) loads.
- Good knowledge on Reusability of mappings and transformations and Error handling using dependencies.
- Worked on Teradata utilities like BTEQ, Fast load, Mload and Fast export
- Extensive knowledge of RDBMS and SQL/PLSQL, TSQL Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
- Worked with different data sources like Oracle, Teradata, Sybase, SQL Server, SFDC and flat file sources.
- Receiving incidents and requests from end-users, analyzing those and responding to end-users with the solutions.
- Exposure to health care, Finance and banking sectors with regards to data warehouse development.
- Involved in all the stages of the Software Development Life Cycle.
- Experienced in trouble shooting using various log files.
- Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
- Expertise in Data Warehousing Concepts like Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling.
- Experienced in Programming languages like COBOL, JCL, IMS DB.
- Providing high level and low-level estimates and projecting resource needs. Interaction with offsite team and BU team
- Work closely with developers/PMs in plan and prioritize the work and representing team at the leadership meetings
- Exceptional abilities in project design and management with the organizational and supervisory skills to assure success. Delegates and monitors work to meet and beat deadlines
- Successful in meeting new technical challenges and finding solutions to meet the need of customers.
- Implement agile management ideals by facilitating exercises such as sprint planning and team leading standups.
- Manage project timelines and communicate with management staff and clients to ensure project progress satisfactorily.
- Enact delivery upon completion of projects and ensure that delivery adheres to agile practices maintained by the company.
- Knowledge on informatica IDQ, BDM, IICS, Cloud and AWS.
- Implement AWS ETL tool to replace informatica ETL for DW.
- My interpersonal and soft skills are Leadership * Team Player * Strong Communicator * Technical Skills * Domain Knowledge * Time Management * Analytical Problem Solver
TECHNICAL SKILLS
Data warehousing Tools: Informatica Power Center 8x/9x/10x, Informatica, Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor, Informatica Metadata Manager, Teradata, Informatica Power exchange
BI Data Modeling: MS Visio, Star Schema Modeling, Snow-Flake Schema Modeling, FACTS, Dimensions
Database: Oracle11x/10g, Snowflake, Teradata, Sybase12.0, VSAM, DB2 UDB 8.0/7.0, SQL Server 2008/2012, MS Access 2003, SQL Query Analyzer, SQLQuery Analyzer, SQL Enterprise Manager, Management Studio .
Languages: Pl/SQL, SQL, TSQL, C, UNIX Shell Scripting, SAS.
Operating systems: Windows XP/NT/2000, MS-DOS, OS/390, Unix
Others: TOAD, Visio, SQL*PLUS, SQLLOADER, XML, HTML, TFS, Project Plan, VSTS, GIT and AWS
PROFESSIONAL EXPERIENCE
Confidential, Indianapolis IN
Technical lead
Responsibilities:
- Responsible for Business Analysis and Requirements Collection. Worked on project plan to define the efforts and estimations on each task.
- Designed and customized data models for Data warehouse supporting data from multiple sources on real time
- Involved in building the ETL Informatica Power Center architecture and Source to Target mapping to load data into Data warehouse.
- Developed Informatica Power Center mapping parameters and variables to support SQL override.
- Created mapplets to use them in different mappings.
- Used Debugger to test the mappings and fixed the bugs.
- Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
- Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
- Migrated the code into QA (Testing) and supported QA team and UAT (User).
- Created detailed Unit Test Document with all possible Test cases/Scripts.
- Conducted code reviews developed by my teammates before moving the code into QA.
- Running SAS programs on Adhoc requests.
- Prepared migration document to move the mappings from development to testing and then to production repositories.
- Involved in production support.
- Prepared test Scenarios and Test cases in TFS/VSTS and involved in unit testing of mappings, system testing and user acceptance testing.
- Following the Agile process and certified SAFe Agile 4.5
- Calling webservices/SOAP using HTTP Transformation.
- Recently worked on migrated the UNIX, Oracle and informatica servers from Century link to AWS.
Environment: Informatica Power center 9.1.0&10.02, Flat Files, XML Files PL/SQL, Snowflake, Oracle 10x, Linux, Toad, SQL Server, DB2, Notepad ++, Power exchange, MS Dos, VSTS, TSQL,GIT,SAS, AWS migration.
Confidential, Charlotte, NC
Sr. ETL Informatica Developer
Responsibilities:
- Strong knowledge of design and development in oracle and DB2 environment.
- Significant experience interfacing with business users.
- Gathering, analyzing requirements and preparing the data elements spreadsheet.
- Created data mapping document for the ETL process.
- Tested the ETL objects to optimize load performance.
- Designed mappings between flat files, DB2 sources to data warehouse, which is in oracle.
- Developed slowly changing dimensions type 2 and type 1.
- Created parameter files and shell scripts in UNIX.
- SQL and PL/SQL coding.
- Worked with shared services for code migration from development to QA and production.
- Automated daily, weekly and monthly workflows to run different jobs.
- Excellent production support and issue resolution.
- Excellent teamwork and understanding with the users.
- The project helped in achieving high level reports used by the senior management and their teams.
- System documentation.
Environment: Informatica PowerCenter 9.0.1, IBM DB2 9.1.7, Oracle 11g, TOAD for Oracle 10.6, Erwin 7.3.8 SP2, TOAD for DB2 5.0, Putty 0.62, WinSCP 5.1.2, Beyond compare 3.3.5SQL Server 2008 R2, IBM AIX UNIX 7.1.
Confidential, MN
Sr. ETL Informatica Developer
Responsibilities:
- Involved in gathering and analysing requirements, prepared Technical Design document and Source - Target Mapping docs and presented to BU team to finalise and get sing off on the TDD/STM
- Worked on project plan to define the efforts and estimations on each task.
- Designed and Developed the Batch and Incremental ETL Informatica Power Center process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
- Administered and maintained Clarity (Risks/Issues, Functional and Nonfunctional documentation, Change Controls, Technical Specs).
- Scheduled and lead the status meeting calls with Deliver /Test Mangers to define the road map and to discuss on project status.
- Setup and configure Power Center domain, grid and services.
- Identify root cause and implement resolution for production Processing issues.
- Perform object deployments on versioned repositories from QA to Production.
- Setup and administer Power Center security.
- Used Debugger to test the mappings and fixed the bugs.
- Prepared migration document to move the mappings from development to testing and then to production repositories.
Environment: Informatica Power center 9.0, Flat Files, XML Files PL/SQL, Oracle 10x, Linux, Toad, SQL Server, DB2, Notepad ++, Power exchange, MS Dos .
Confidential
ETL Analyst/Developer
Responsibilities:
- RIM (Request Information Management) analysis and development.
- Understanding the Business requirements and creating TSD documents.
- Prepared a Requirement traceability Matrix and Estimated the Project.
- Involved in complete SDLC process, through all phases of project life cycle - analysis, design, development, testing, implementation and post-production activities.
- Developed Detailed Design documents based on business requirements.
- Worked closely with business analysts to gather functional specifications and turn them into technical specifications.
- Designed and developed full load & incremental load mapping.
- Created mapplets which provides reusability in mappings.
- Involved in debugging the failed mappings identify the root cause and developing error-handling methods.
- Prepared the ETL Informatica Power Center Design documents as per client requirements.
- Extensive use of Informatica Power Center tools -- Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
- Used transformations like Lookup, Joiner, Update Strategy, Aggregators, Filters, Expression, Router, Source Qualifier, Union and Sequence Generator.
- Involved in UNIX scripts to FTP the files.
- Involved in development of BTEQ scripts to load data to Teradata tables.
- Creating Bteq Scripts to load the Target tables and intermediary tables
- Involved in writing SQL’s as part of Bteq Scripts and for validating the source code.
- Documented the Unit Test Cases & Integration Testing Steps and captured the results. Prepared release notes for migrating the objects from DEV to INT to UAT environments.
- Migration of code to QA, Pre-prod and Production Environment.
- Preparation of ETL mapping documents.
Environment: Informatica Power center 9.6.1, Flat Files, XML Files, UNIX, WLM Scheduling Tool, Teradata.
Confidential
ETL Analyst/Developer
Responsibilities:
- RIM (Request Information Management) analysis and development.
- Involved in complete SDLC process, through all phases of project life cycle - analysis, design, development, testing, implementation and post-production activities.
- Worked on ETL processes using Informatica 9.0.
- Provided project leadership to the team.
- Involved in quality assurance, status reporting, tracking time and cost in loading data warehouse needed for the project.
- Exclusively involved in ETL Informatica Power Center design, development, loads and deployment.
- Involved in technical discussions and facilitated in meeting deadlines.
- Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
- Involved in UNIX scripts to FTP the files.
- Involved in development of BTEQ scripts to load data to Teradata tables.
- Creating Bteq Scripts to load the Target tables and intermediary tables
- Involved in writing SQL’s as part of Bteq Scripts and for validating the source code.
- Design of Technical Documents and preparation of Unit Test Cases.
- Migration of code to QA, Pre-prod and Production Environment.
- Preparation of ETL mapping documents
- Working as a team Member for this project.
- Batch monitoring through Workload Manager (WLM) Tool.
- Handling Batch Failures and Daily Batch status reporting.
- Root cause analysis and fix for failures.
- Critical batch process monitoring and Problem Solving.
- Break Fixes and Permanent resolutions for repetitive production failures.
- Ad-hoc task and analysis and implementation.
- On Demand job processing.
- Assistance with user requested RIM’s on data.
- Assistance with Maintenance release works.
- Metrics Reporting - Weekly and Monthly metrics reports
- Provided the directions to team to implement unit test plans for Extraction/Transformation.
- Involved in data cleansing and loading of data into staging areas.
- Involved in Configuration management decisions.
- Effectively communicating the project status to all the stakeholders.
- Leading the team in the overall initiation, planning, and execution.
- Handled monitoring and closing of the project.
Environment: Informatica Power center 9.6.1, Flat Files, XML Files, UNIX, WLM Scheduling Tool, Teradata
Confidential
ETL Analyst/Developer
Responsibilities:
- Developed ETL Informatica Power Center mappings, transformations using Data Junction Tool.
- Developed mappings via various conversions using DJ.
- Involved into source code review, the mappings created by my team members.
- Prepared deployment document and assisted to deployment team while migration.
- Involved in creating test scripts.
- Involved in the whole Process of FTP Connections, Conversions and Transferring the Encounter Files to DW load Process.
- Extensive use of Informatica Power Center tools -- Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
- Used transformations like Lookup, Joiner, Update Strategy, Aggregators, Filters, Expression, Router, Source Qualifier, Union and Sequence Generator.
- Involved in UNIX scripts to FTP the files.
- Involved in development of BTEQ scripts to load data to Teradata tables.
- Design of Technical Documents and preparation of Unit Test Cases.
- Migration of code to QA, Pre-prod and Production Environment.
- Preparation of ETL mapping documents.
Environment: Informatica Power Center 8.6.1, IBM Data Junction, UNIX, Windows Batch Scripts and WLM, Teradata