SUMMARY

• Seeking an ETL Developer or architect position, drawing on my analytical skills, knowledge and practical experience in requirements, software architecture, databases, data warehousing and business intelligence.
• Achievement oriented, personable and experienced IT professional in software engineering and databases as architect, developer and lead.
• More than 8 years of IT experience and 5 years in Data Analysis and Design, Development & Support of Informatica Powercenter and MS SQL Servers 12/14/16 in Production and Development Environments.
• Strong Data Warehousing ETL experience of using Informatica 10.2/9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Extensive work with stored procedures, indexes, views, functions, and triggers on creation and optimization to improve response time and to enforce business requirements through T-SQL.
• Hands on creating end to end ETL strategies that will include data profiling as well as extracting transforming, conforming and loading.
• Collaborates with business functional leaders by analyzing and evaluating business requirements; diagnose the design, propose/design alternatives and recommendations
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, DB2, MS Access and PostGres.
• Extracts structured and unstructured data from source systems, transforming it to fit business performance management needs, and loading it into a data mart
• A Used Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• A well-organized, creative, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.
• Developed and executed a migration strategy to move Data Warehouse from an Oracle platform to AWS Redshift.
• Built data pipelines from multiple data sources by performing necessary ETL tasks.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Extensive experience in developing, maintaining and managing Tableau driven dashboards & analytics and working knowledge of Tableau administration/architecture.
• Experience in end-to-end implementation of Business Intelligence (BI) reports & dashboards, building qvds and qvws applying business rules and data validations.
• Proficient in developing Reports, Dashboards and KPI Scorecards and DAX solutions on PowerBI
• Extensively used Microsoft Power BI toolset (Power Query, Power View, Power Map, Power Pivot, Power map, PowerBI service, Power BI Q&A, Data Management Gateway, Data Catalog)
• Worked as a Software Full Stack Developer for 2+ years in Java, HTML, JavaScript, C# etc.
• Demonstrated experience in Financial & HealthCare Legacy systems

TECHNICAL SKILLS

Business Intelligence: Informatica, OLAP, OLTP, ETL

ETL Tools: Informatica 10.2/9.5/8.6/7.1 , Informatica Power Center

Programming Language: Hive, Ambari, SQL, PL/SQL, Java, Python, COBOL, R

Data Visualization tools: Power BI, Tableau

Database: Microsoft SQL Server, PL/SQL, Oracle 11g, Teradata

Data Modelling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, SCD type I, II, III, Erwin r7.2/3/4

UML diagrams: Use case diagrams, IBM Rational Rose, IBM Rational Software Architect, Smart draw, MS Visio

Other Technologies: Core Java, Rest, SOAP API, JSON, XML

Cloud Applications: AWS (EC2, RDS, Redshift)

Processes: Business Intelligence, predictive modelling, Data Analysis, Share Point, OneNote

Other: Data Warehouse, Data Modelling, Agile, Wireframe & Prototype, Agile, Scrum, JIRA, Quality Centre, Microsoft Azure

Domain: IT Services, Health, Banking and Financial Service

Other Applications Knowledge: Java Full Stack, IBM Mainframes

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer | BI Developer Contractor

Responsibilities:

• Gathering business requirements, working closely with business users, project leaders and developers. Analyzing the business requirements and designed conceptual and logical data models.
• Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
• Developing conceptual and logical information models within the context of the Enterprise and Line of Business Information Architecture
• Created ETL Mapping and Workflows using Informatica PowerCenter
• Worked closely with Information Technology staff through the phases of coding and implementation of external data source files providing clarifications as necessary
• Analyzed data to determine trends, exceptions, and proactive alerts and created reports and dashboards on PowerBI
• Worked on MS Excel, Pivot Tables, Charts, Graphs, Dashboards, PowerPivot, PowerView, PowerMap
• Integrated Rest API service through Informatica workflows
• Participating in Sprint grooming sessions and helping scrum masters and technical architects in story grooming and further assigning it as a task
• Collaborated with the Data Scientists to clean the data that has been collected, like finding null values and replacing with average, and finding supervised and unsupervised data.
• Implement data structures on a variety of database platforms, including Oracle, Teradata
• Experience in Data Governance activities like identifying the Key Data Elements, Defining Business Rules, Technical Lineage, Functional Lineage, Flow Validation, ETL Certification, Business Glossary, Data Dictionary and Reconciliation process.

Environment: Informatica 9.6.1 and 10.2.0(Mapping Designer, Workflow Manager, Repository Manager, Workflow Monitor), Teradata, Oracle 12c, AWS Redshift, RDS, Power BI, Cisco Web connect, Java, Rest API, Putty, GIT

Confidential, Chicago, IL

Sr. ETL Developer | BI Developer

Responsibilities:

• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
• Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
• Experience in creating and maintaining Analysis services objects such as cubes, dimensions, and measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Extracted data from internal data warehouse system to SSRS.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Monitored Production jobs and worked on critical Production failures. Maintained a Known Error Database (KED) to help the rookies work on repeating PROD issues/failures.

Environment: SSIS, SSAS, SSRS, Microsoft SQL Server, IBM Info Sphere Information Governance Catalog, IBM-Metadex, IGC IMAM, MS Visio, MS Outlook, MS SharePoint, Delivery Hub.

Confidential, Warrenville, Illinois

ETL Developer/ BI Developer

Responsibilities:

• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extract.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server with high volume data.
• Identified Source/Target bottlenecks in the ETL code on the Performance Tuning front to improve the performance of the workflows.
• Experience in using Debugger in Informatica Power Center and troubleshooting the Production incidents.
• Suggest architectural, design and coding changes to improve the performance of the Tableau dashboards.
• Derived actionable insights from data and present to business stakeholders in a compelling manner

Environment: Oracle 11g, MS SQL Server 2014, Erwin, Informatica Power Center 9.6.1, MS Office, HTML, XML, JavaScript, CSS, MS Visio, Tableau, MS Outlook, MS Excel advanced, MS word, MS Access.

Confidential

Data Integration/ Migration/ ETL Developer

Responsibilities:

• Involved with Business Analysts in requirement gathering and worked on converting Business needs into Technical Requirements in the form of Data Mapping documents, business rules documents and Function Design and Functional Specification Document.
• Performed Impact Analysis on Database objects and wrote complex SQL queries using Toad for Oracle.
• Worked closely with the Data Architects on the Data Models using the tool Erwin.
• Referred Metadata tables, Data Dictionary and Data Glossary for Elicitation and Analysis purposes.
• Performed Impact Analysis on Database objects using Toad for Oracle.
• Involved in Informal Sessions with the Data modeling team to develop an Architectural Solution Created PL/SQL Functions, Stored Procedures, Packages, Cursors and Triggers.
• Created Informatica mappings/workflows from scratch to load the files to the Downstream using Transformations in Informatica Power Center.
• Experience in writing complex joins, Correlated Subqueries and using Analytical functions like Rank, Dense Rank, Row number using Toad for Oracle.

Environment: Oracle 11g, Windows XP, Microsoft Project 2000, Informatica Power Center 9.5, HTML, Tableau, Erwin, MS Excel, Cognos, Toad, Autosys scheduling tool, PowerPoint, MS Visio and MS Outlook.

Confidential

Data Analyst | Student Worker

Responsibilities:

• Developed dashboards analyzing call handing forecasting, call rate, call waiting time, and call forward, average call time using Tableau BI.
• Generated data extracts in Tableau by connecting to the view using Tableau MySQL connector.
• Configured data extraction and scheduled refreshes both incremental and complete refresh depending on the data to improve performance of Tableau reports.
• Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom.
• Involved in major integration with web applications using JavaScript API, REST API.

Environment: Tableau, Datawarehouse, Oracle 16C, Teradata, Informatica PowerCenter

Confidential

Sr. ETL Developer | BI Developer

Responsibilities:

• Worked closely with the Release Management team and maintained Requirement Traceability Matrix document using MS Excel.
• Leading Conversion/Interface team (Onsite/Offshore) of various fields like Mainframe, ETL (Informatica, BODS)
• Design Star and SnowFlake schema and write ETL code to load data to Dimension and fact tables.
• Design the validation process for conversion//migration using BODS for data accuracy and consistency.
• Extracted data from various sources such as SQL server, DB2UBD, Flat Files, Mainframe, Oracle
• Worked productively with cross-functional working groups and across organizational layers Used different transformations like Connected & Unconnected Lookup, Connected & Unconnected Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction Control Transformations to data conversion before loading to Target.
• Master in data warehousing concepts like OLAP, OLTP, Slowly Changing Dimension (SCD) types (I, II &III) methodologies, Incremental Loads and Change Data Capture (CDC).
• Identified Source/Target bottlenecks in the ETL code on the Performance Tuning front to improve the performance of the workflows.
• Worked as a Java full Stack developer for 2+ years.

Environment: Informatica Power Center 9.6.1/9.5.1/8.6.1 Informatica IDE/IDQ 8.6, Informatica Power Exchange 9.5.1/8.5.1/8.6.1 , Oracle 10g/11g,, SQL Server, DB2, PL/SQL, AIX/UNIX, Windows 10, Java, Spring, Hibernate, JSP, JDBC, APIs, CSS,HTML