We provide IT Staff Augmentation Services!

Etl & Bi Lead/data Modeler Resume

Owings Mills, MD

SUMMARY:

  • A dynamic IT professional with 7 years of experience in software Design, Development, Data Quality and Data Integration projects, Implementation and Testing of Database and Data Warehouse applications.
  • Good understanding of Data Modeling concepts like Star schema Modeling, Snowflake schema Modeling, Fact and dimension tables.
  • Solid understanding of Data Warehouse concepts, ETL design and well versed with Data Profiling, Data Migration and Data Conversions.
  • Worked with Architects, functional Analyst to Design source system logical and physical model.
  • Experience in Data Analysis, Design, Development, Implementation and testing using Data conversions, ETL and SQL server, Oracle and other relational, non - relational databases.
  • Good knowledge of development and migration of RPD.
  • Involved in mapping designing using Informatica, Ab-Initio and SSIS.
  • Familiarity with various BI tools like SSRS, Tableau, Cognos, MicroStrategy, OBIEE11g, Crystal reports etc.
  • Experience in Agile (SCRUM), Kanban and waterfall methodologies which involves Data integration projects using different ETL tools, Teradata, and Oracle database.
  • Knowledge on implementing Hierarchies, Relationships Types, Packages and Profiles for hierarchy management in MDM Hub implementation
  • Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica Power Center and SQL Server suite of product.
  • Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • A result oriented person with a strong analytical mindset and a never-ending zeal to learn and excel with Excellent Time Management. I am also very flexible & versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
  • Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills and excellent Team leadership capability.

TECHNICAL SKILLS:

Data Modelling Tools: Erwin 8.5/9.1/9.64.1, MS Visio

ETL Tools: INFORMATICA Power Center 9.6/10.1, Informatica Cloud, SSIS, Ab-Initio, SSAS 2008/2012

Reporting Tools: SSRS, Tableau, MicroStrategy, Cognos, OBIEE 11g, Crystal Reports, R

Database Systems: Oracle 11g/12c, DB2 8.x/9.x, Teradata 13/14, SQL Server 2012/2014, MongoDB, PostgreSQL, Hyperion

Languages: SQL, PL/SQL, Java, UNIX shell scripting, T-SQL, Python, Mainframe, C, C++

Other Tools: TOAD, INFORMATICA DT Studio, INFORMATICA IDQ, INFORMATICA MDM, INFORMATICA TDM, WinSCP, Autosys, JIRA, ServiceNow, SVN, Putty, MS Office 2016

Operating Systems: Windows Server, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

ETL & BI Lead/Data Modeler

Responsibilities -

  • Interfacing with multiple stakeholders for gathering requirements.
  • Requirements elicitation and translation to technical specifications.
  • Developing and maintaining an Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage the Enterprise Data Warehouse.
  • Involved in Data Architecture, Data profiling, Data Analysis, Data mapping and data Architecture artifacts design.
  • Perform reverse engineering of the current application using ERWIN and building Logical and Physical data models for Enterprise Data Warehouse (EDW).
  • Extract FACETS and NASCO data and load into Oracle database.
  • Designing ETL (Informatica/SSIS) components.
  • Developed HQL’s to load the data from Pre-Stage to Staging hive schema (using CSV SeDe).
  • Developed HQL’s to move data from Staging to application layer (aggregation, transformations etc).
  • Started working on JSON files received from Kafaka to convert data into structured format i.e into hive tables.
  • Involved in the data mart fact and dimension tables design using Star and Snowflake schema.
  • Used Power Center transformations like Source, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filter, Lookup, Sequence Generator, Router, Update Strategy, Target (Table and Flat & xml File).
  • Used Mapplets for use in mappings thereby saving valuable design time and effort
  • Used INFORMATICA Workflow Manager to create sessions, worklets and workflows.
  • Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.
  • Data Cleansing using the Informatica Data Quality (IDQ).
  • Develop and Deploy ETL jobs to move data from source systems to Teradata systems.
  • Involved in Performance tuning of the programs and ETL processes
  • Wrote stored PL/SQL Procedures for reports and involved in Developing and Generating Reports.
  • Involved in Performance Tuning of SQL queries and Created indexes on tables and optimizing Stored Procedure queries.
  • Production support on ETL business and extremely handling Priority Incidents (P1 to P5)
  • Interacted with Business Analysts to understand the requirements and developed Data Model for the ETL Data warehouse.
  • Use UNIX shell scripting for the flat file to move onto the server and importing to the source and merging the data as well.
  • Good experience with connecting to various databases from UNIX shell script to extract and load data.
  • Responsible for Unit testing and Integration testing of mappings and workflows.
  • Responsible for ETL Application Production support 24*7 for all P1/P2/P3 issues.
  • Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
  • Scheduled Informatica jobs on CA7 scheduler on Mainframe and running batch daily.
  • Worked on Mainframe for file handling and file processing.
  • Keep track of daily incidents and service requests and develop monthly report of the team member related to spent hours and number of incident and service request resolved by each individual.
  • Generate daily invoices on SSRS 2012/2014.
  • Generate Daily/weekly/Monthly and Adhoc reports/Dashboards on Tableau and MicroStrategy.
  • Coordinating and tracking all projects for seamless releases using Project Management System JIRA, Source Code Management System SVN and Document Management System SharePoint.

Technology: ERWIN, INFORMATICA Power Center 9.6/10.1, Informatica Cloud, Teradata 14.x, SQL Developer, SSIS, SSRS 2012, Tableau, MicroStrategy, WinSCP, Mainframe, Oracle 11g/12c, MSSQL 12, SSIS, Informatica DT Studio, Unix Scripting, JIRA, ServiceNow, SVN

Confidential, New Jersey

Senior ETL Developer/Business Intelligence Analyst

Responsibilities -

  • Requirements elicitation and translation to technical specifications.
  • Extract FACETS and NASCO data and load into Oracle database.
  • Developed ETL mappings to load data from Hyperion to Oracle database.
  • Involved in complete life cycle of ETL process for data movement from Source System to Staging and finally to data base.
  • Extensively used INFORMATICA/SSIS to design multiple mappings with embedded business logic.
  • Developed Slowly Changing Dimension for Type 2 SCD mappings.
  • Developed 820/834/835/837 EDI Transaction mappings using X12 source files.
  • Implemented Shell Scripts to use FTP, SQL Loader utilities.
  • Used INFORMATICA Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expressions and Aggregator transformations.
  • Import the IDQ Mapplets and using them in the Informatica mappings.
  • Create data quality plans to validate the address using Melissa data (IDQ Content).
  • Create Mapping and Mapplets and rules in IDQ to address clean and transform data.
  • Work on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Used Informatica MDM tool to manage Master data of EDW.
  • Created relationships for the Base objects which reflects from look up tables in MDM.
  • Transformations like Aggregate, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Multicast, Sort, Union All transformations in SSIS package Data Flow Designer to effectively utilize SSIS services.
  • Involved in performance tuning of the ETL mappings using various components like Parameter files, Variables and Dynamic Cache.
  • Documenting the INFORMATICA/SSIS ETL design specifications and mappings and maintaining the version control.
  • Also, Develop Packages and load data through Oracle PL/SQL.
  • Working experience in data cleansing, data matching, data conversion, exception handling, Identifying and eliminating duplicates in datasets through IDQ 9.x.
  • Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products.
  • Create low level design artifacts independently and high level design artifacts with guidance and supports prototyping through creation of POCs.
  • Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
  • Written complex SQL’s using joins, sub queries and correlated sub queries in Oracle to generate business reports accordingly.
  • Worked on Autosys to schedule and Monitor Informatica jobs
  • Perform performance optimizations on BI Frameworks.
  • Create reports according to business requirements.
  • Generate Daily/weekly/Monthly and Adhoc reports/Dashboards on SSRS and Cognos.

Technology: INFORMATICA Power Center 9.6, SSIS, Informatica IDQ 9.x, SSRS 2008/2012, Informatica MDM, Cognos, Informatica DT Studio, Oracle Teradata 14.x, Hyperion, SQL Developer, INFORMATICA TDM, Oracle PL/SQL, SQL 2008R2, Autosys

Confidential

ETL Developer

Responsibilities -

  • Participate in business and system requirements sessions.
  • Requirements elicitation and translation to technical specifications.
  • Understand the requirements (both functional and non-functional) by going through the specifications and inputs from Business Analysts.
  • Develop data model using ERWIN with guidance of peers.
  • Developed INFORMATICA mappings with use of mapping Variables, and Parameters files.
  • Used INFORMATICA Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expressions and Aggregator transformations.
  • Developed Slowly Changing Dimension for Type 2 SCD
  • Used INFORMATICA Mapplets for use in mappings thereby saving valuable design time and effort
  • Used INFORMATICA Workflow Manager to create sessions, worklets and workflows.
  • Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Performed Configuration Management to Migrate INFORMATICA mappings/sessions workflows from Development to Test to production environment.
  • Work on development and maintenance of RPD.
  • Developed daily/weekly/Monthly/Yearly and adhoc reports on OBIEE 11g as per Business requirement.
  • Also, have good MUD experience.
  • Developed reports according to business requirements.
  • Perform root-cause analysis of any issues that arise post-implementation and work on solutions related to issue fixing.
  • Worked on Autosys to schedule and monitor Informatica jobs.
  • Good experience with connecting to various databases from UNIX shell script to extract and load data.
  • Use UNIX shell scripting for the flat file to move onto the server and importing to the source and merging the data as well.

Technology: INFORMATICA Power Center 8.6/9.1, ERWIN, OBIEE 11g, Oracle RPD, Oracle DB2, Toad, SQL server 2008R2, Autosys, UNIX

Hire Now