PROFESSIONAL SUMMARY:

• 9+ years of extensive ETL experience with a strong background of data warehouse (DWH), data mart and data integration.
• 3+ years of leading and managing DWH technical teams.
• Worked in an agile setting running all the ceremonies of an agile team.
• Build an effective agile team to deliver consistently and effectively.
• Worked across multiple agile and Kanban teams to get the project completed as per needs within the given time period.
• Created PPT’s, Visio data flow diagrams, design documents etc. for higher management to scope out the strategy of the project.
• Implemented ETL practices with high performance and scalable ETL designs.
• Designed, developed and implemented ETL processes against high - volume and complex data sources.
• Extensive experience working with Oracle, SQL, PL/SQL procedures.
• Extensive expertise of data modeling using star & snowflake schemas modelling tables as per domain and business needs and requirements.
• Involved in leading the team thru full software development lifecycle (SDLC) of the data warehouse ETL process end to end.
• Worked as a liaison between business and the technical team on defining requirements and breaking it down into technical user stories and tasks for ETL & QA teams.
• Worked with tools like FileZilla, putty, Go Anywhere to do FTP, SFTP, encryption & decryption operations.
• Worked with the business and the business analyst to build requirements for the ETL & the reporting team along with designing the technical documents like STT’s, BRD’s and user story documents.
• Worked with tools like version one & Jira to account for work being done in the Op-ex & Cap-ex lanes.
• Worked with the product owners and scrum masters to design the scrum board for Op-ex & Cap-ex lanes.
• Worked with product owners to create stories and break them down to tasks for the ETL & the reporting team.
• Highly motivated, result oriented professional with a short learning curve and excellent Communication skills.
• Very good and engaging with team and maintaining good relations with the internal team as well as the business users. Good analytical and leadership skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQL*PLUS, UNIX SHELL SCRIPT

ETL Tools: Informatica Power Center 10.2,10. 1/9x Informatica IDQ

Case Tools: ERWIN and Microsoft Visio.

Databases: Phoenix, Vertica, Oracle 11g/10g/9.x/8.x, IBM (DB2/UDB), SQL Server, Netezza, Salesforce Cloud, MS Access.

Reporting Tools: IBM Cognos 8, Tableau, Crystal Reports

Dev Tools: Toad, Sql Loader, Sql PLUS, Agility, Work Bench, Microsoft Sql Server Management Studio, DB Visualizer, Explorer ++

PL: SQL Developer, Active Batch, Jira, Bit Bucket, Version one, Star Team, Control-M, Star Point, Go Anywhere Hip Chat, Jabber, Windows Messenger, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr.ETL Developer

Responsibilities:

• Build and collect requirements from the business and the technical SME’s along with the BA.
• Create STT’s, user stories and acceptance criteria for the defined requirements so they can be broken into tasks.
• Develop, Unit test and QA the ETL mappings. Work with the business user on UAT in different environments.
• Work with the QA team in helping with the data load, data testing and validation.
• Scheduling ETL jobs using tools like active batch & windows scheduler.
• Build user acceptance scenario along with the users.
• Work with the admin on the ETL code migration.
• Designing tables for different dimensions and facts.
• Code review and QA testing other developers ETL work.
• Deployment documentation.

Confidential, Fort Wayne, IN

Sr.ETL Developer

Responsibilities:

• Work with the business to get requirements. Getting mapping documents updated and refined as per standards.
• Design the data flow, tables and database objects.
• Create documentation for the project, STT documents, QA documents, Migration documents, data flow diagrams, ETL Scripts to create database objects.
• Develop, Unit test and QA the ETL mappings. Work with the business user on UAT in different environments.
• Scheduling ETL jobs using tools like Control-M, Informatica scheduler, active batch & windows scheduler.
• Build user acceptance scenario along with the users.
• Work with the admin on the ETL code migration.
• Hand off and KT sessions with other ETL developer.
• Trouble shoot issues.
• Run agile ceremonies like Scrums, backlog grooming, sprint planning and retrospection of sprints to improve the teams overall performance.

Confidential, Naperville, IL

ETL Developer

Responsibilities:

• Work with the business to get requirements.
• Design the data flow, tables and database objects.
• Create the source and target connections for Informatica so data can be read, data can be loaded into the database.
• Create documentation for the project, STT documents, QA documents, Migration documents, data flow diagrams, ETL Scripts to create database objects.
• Develop, unit test and QA the ETL mappings. Work with the business user on UAT in different environments.
• Build user acceptance scenario along with the users.
• Work with the admin on the ETL code migration.
• Hand off and KT sessions with other ETL developer.
• Trouble shoot issues and get them resolved.
• Created batch scripts since Informatica was installed on a windows server.
• Also did some FTP processes to read data and write data to remote servers.

Confidential, Vernon Hills, IL

Data Integration Tech Lead

Responsibilities:

• Created & developed the design and architecture for incoming projects
• Designed database objects as per the need of the project and developed methods of using it efficiently.
• Put together L0, L1 and final development estimates for projects.
• Participated in understanding of data specifications and data objects to integrate data with other systems.
• Prepared and documented ETL processes and design specifications for audit purpose.
• Provided technical guidance during all stages of SDLC.
• Participated in understanding and analysis of business requirements.
• Formulated and maintained new ETL processes and specifications.
• Prepared and executed standards for data warehouse projects.
• Developed and implemented integration test plans for Informatica sessions.
• Designed and developed ETL processes for data warehouses and data marts.
• Lead both the Cap-ex and Op-ex sides of development
• Created Visio and PPT’s for business users and developers to explain process and data flow.
• Conducted code reviews and migration reviews.
• Helped the team in troubleshooting and resolving production and performance issues.
• Delegated work according to Sprint needs and picked up development work if needed.
• Build scripts for file cleanings & file moving within same servers or different FTP & SFTP servers.

Confidential, Vernon Hills, IL

Sr. ETL Developer

Responsibilities:

• Involved in business analysis meetings with the end user to understand the existing system and future requirements.
• Prioritize projects based on the customer deadline and budget allocated for the projects.
• Act as an intermediate between the business analyst group and the ETL development team to understand the requirements and translate them into technical specifications.
• Involved in the design and development of data warehouse and reports to track the key business entities. Informatica is the ETL tool used to load the data into the data warehouse and Congo’s for creating the reports.
• Identified the facts and dimensions based on the line of business and designed the relevant dimension and fact tables.
• Worked on Power Center client tools like source analyzer, target designer, mapping designer, mapplet designer and transformations developer.
• Used most of the transformations such as the source qualifier, expression, aggregator, connected & unconnected lookups, filter, router, sequence generator, sorter, joiner, and update strategy.
• Used Workflow manager for workflow and session management, database connection management and Scheduling of jobs to be run in the batch process.
• Developed UNIX shell scripts, PL/SQL stored procedures for creating/dropping of table and indexes of performance for pre and post session management.
• Loaded target data on daily, weekly and monthly basis using incremental aggregation
• Imported data from various sources transformed and loaded into data warehouse Targets using Informatica.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Optimizing query performance and performance tuning the code to reduce the load on the server.
• Created partitions to concurrently load the data into sources
• Identify the performance issues with the help of performance & resilience team based on the thread (Source, Target, and Transformation) information.
• Used Debugger in troubleshooting mappings, logics and errors in data loads.
• Unit testing & QA testing mappings, defining acceptance criteria as per ETL development.
• Documentation to describe program development, logic, coding, testing, changes and corrections.
• Was involved in Migration of code from the Development layer to the Production layer.
• Worked with the offshore team to complete migrations and work on production issues.
• Responsible for delegating the tasks to Jr developers, helping & mentoring them.

Confidential, Vernon Hills, IL

ETL Developer

Responsibilities:

• Designed mappings using the transformations joiner, aggregator, expression, lookup, Router, Filter, and Update Strategy transformations and mapplet’s to load data into the target.
• Extensively used Informatica 9.1 in loading data from flat files, sources, and Oracle.
• Optimized and fine-tuned SQL queries, stored procedures, data load processes to avoid overhead on the database and application servers.
• Worked on Power Center client tools like source analyzer, target designer, mapping designer, mapplet designer and transformations developer.
• Created complex mappings including slowly changing dimensions and data loads for OLTP systems.

Confidential

Sr.Customer Support/ QA auditor

Responsibilities:

• Started off doing customer support initially answering calls for US business customers
• Was later promoted to an auditor role which I listened into calls from other teammates and gave feedback on quality and improvement options.

Confidential

Phone banking officer

Responsibilities:

• Answered queries on the phone for all enquiries about all loans and loans against shares.
• Audited calls and later was promoted as soft skills coach.
• Listened to calls and gave feed back to new Phone officers.