PROFESSIONAL SUMMARY:

• Around 7 years of IT experience in Data analysis, Business Intelligence, Data Visualization, Data Modelling, SQL, ETL and Reporting positions working with different organizations.
• Extensive experience in Data warehouse, ETL (Extract, Transformation & Loading), Business Intelligence Reporting, tools.
• Extensively worked on MicroStrategy 8.x/9.x/10.x, Oracle, PL - SQL, Teradata, and SQL Server.
• Experience in Data Warehouse environment using Microsoft DTS, SSIS and SSRS.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experienced in Installation, Configuration, and Administration of Informatica Data Quality.
• Strong experience in Agile Scrum concepts like Scrum team, Product backlog, Sprint planning, Sprint Retrospective, User stories, Daily standup, Burn down charts etc.
• Experience developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
• Expertise in Business Intelligence Process for Data Integration and Migration services.
• Expertise in facilitation of interviews, conference, workshops in Joint Requirement Planning (JRP), Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
• Experienced in full life cycle including project scoping, requirements gathering, systems analysis, design, development, testing, implementation and maintenance.
• Expert in documenting Business requirements document (BRD), Functional requirements document (FRD), Use Case Specifications, Functional Specifications (FSD), and User Stories.
• Expertise in Tableau BI reporting tools &Tableau Dashboard & Server Administration.
• Experienced in Data Analysis and Validation with complex queries and analytics functions to validate summary data from underlying detail data.
• Expertise in Data Extraction, Cleansing, Transformation, Integration, Data Analysis, Logical/Physical Relational/Dimensional Modeling & Designing.
• Well versed with Installation, Configuration and Administration of Informatica Power Center on Client/Server environment.
• Experience in SQL Server Programming, Analysis Services and Reporting services.
• Excellent in performing feasibility studies and Impact Analysis, Cost/Benefit analysis, Gap Analysis and Risk analysis.
• Active team player and self-motivated with passion for technology and data.

WORK EXPERIENCE:

Confidential, Atlanta - GA

ETL/BI consultant

Responsibilities:

• Analysis of SDLC Scope and High-Level Business Requirements document.
• Discussed requirement for each asset types from business analyst.
• Support agile teams of software engineers, business analysts, database administrators, network engineers, and support teams in developing, maintaining, executing and analyzing results of automated performance testing procedures and related software.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Involved in requirement gathering, analysis, design, development, change management.
• Worked on Power Center mappings to Cleanse, transform, and standardized data and then loaded into the MDM Hub for further processing.
• Worked on ETL process and Reporting using SQL Server SSIS, SSRS and knowledge in SSAS.
• Moreover, using Informatica Power Center, designed and developed two workflow variable driven solutions to process Flat file sources.
• Analyze and optimize the performance of the long running jobs- both Teradata and Informatica.
• Involved in loading of source data using SSIS packages and creation of reports in Power Pivot and Cognos based on customer requirements.
• Liaison between stakeholders and BI technical team to understand the business needs and translate it into functional requirement.
• Worked on different SSIS Tasks like Execute SQL, Execute Process, Execute Package, Script Task.
• Used all the features of Informatica including Designer, Workflow manager and Repository Manager, Workflow monito
• Involved in functional, ETL, reporting, regression and system integration testing.
• Made Reports and gave insights by building rich, high-visibility reports/dashboards.
• Worked on Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope.
• Provided end-to-end analysis that includes data gathering, requirements/KPI specifications, processing, statistical analysis, ongoing deliverables and presentations.
• Created MicroStrategy reports by creating Schema objects like Attributes, facts, hierarchies, transformations and public objects like Custom groups, consolidations, Metrics, prompts and filters.
• Created ETL jobs for extracting data from multiple sources and load in staging, fact, and reporting tables and transformed data as per business logic.
• Created Informatica Mappings, workflows, Teradata scripts and other Unix shell scripts.
• Customize and configure ETL jobs to Schedule the SSIS Package Using SQL Server Agent.
• Responsible for building reports in Power BI from the Scratch.
• Working with downstream team (EI) to write the Teradata API queries using temporal functionality.
• Used SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Leveraged MicroStrategy OLAP services to develop reports, which use the functionality of the intelligent cubes and Derived Metrics.

Confidential, NYC - NY

ETL consultant

Responsibilities:

• Provide analysis and development support for ETL and data integration initiatives.
• Worked with business users/analytics team, data architect to identify the business requirements and designed ETL flow, data architecture and created various complex Pentaho Transformation and Jobs using PDI Spoon.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support using Pentaho Data Integration.
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Identify, document and communicate BI and ETL best practices and industry accepted development methodologies and techniques.
• Worked Extensively on ETL process using SSIS package.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Worked on performance tuning both at Cognos and database level to bring optimal performance.
• Worked very closely with Project Manager to understand the requirement of reporting solutions to be built.
• Creating BTEQ scripts to load data from Teradata stage table to working table and from working table to final tables.
• Configured Pentaho BI Server for report deployment by creating database connections in Pentaho enterprise console for central usage by the reports deployed in the repository.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Worked on Informatica PowerCenter tools- Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor.
• Used bunch of transformations in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel, KPI and CSV file.
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time.
• Developed complex custom reports using Pentaho Report Designer which includes developing Business Views, Cascading pick-lists, Drill-through, Hyperlinks, sub-reports etc., functionality into these reports.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL /MDX parameters
• Worked on Performance manager to create various metrics, Analytics and used Dashboard Manager to build corporate dashboards.
• Working closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Knowledge sharing about the Pentaho BI tool across all team members.

Confidential, Purchase - NY

ETL Analyst

Responsibilities:

• Responsible for requirement definition, analysis, scope and time estimation for Cognos reports
• Responsible for solving users technical/functional issues.
• Involved in installation and evaluation of report net (Framework Manager, Query Studio, Report Studio and Cognos Connection).
• Defined metadata modeling created packages by using framework manager and published those packages into Cognos connection.
• Stored Procedures, User Defined Functions, Views, T SQL Scripting for complex business logic.
• Successfully implemented BI/Data Warehousing using Informatica applications/MSAS Cubes to meet needs of users.
• Worked on new DB2 Stored Procedures, Table Functions and Views to meet ETL Loading/Cube requirements.
• Implemented Qlick View Dashboard for Data Visualization for the Operational Risk Data.
• Build and Deploy customized reports in Tableau using the underlying data from the Operational Risk Data Warehouse whenever requested by Operations Risk User Group.
• Provide support to Existing System to accommodate any change request raised by Operations Risk User Group.
• Worked on multiple modules for performance improvement of existing process and successfully implemented them and deployed to Production.
• Update Business Requirement documents and prepare technical design for Framework Model and each Milestone Work Down Curve.

Confidential, NYC - NY

ETL Engineer

Responsibilities:

• Worked with Business users and Business analysts to understand and analyze ETL and reporting requirements. Conducted metric analytics to come up with technical specifications documents.
• Used Informatica Power center components like Mapping Designer to design mappings, Workflow manager to create sessions and workflows to execute the mappings and workflow monitor to view the run properties, session logs and to do recovery process.
• Worked with homogenous sources and heterogeneous sources and targets like relational tables, delimited and fixed width flat files and CSV format files while creating mappings.
• Developed mappings using Expression, Source Qualifier, Filter, Router, Lookup and Joiner.
• Created and used Views, Stored Procedures, Queries and tables while developing ETL mappings and reports.
• Used transformation like Merge Join, Pivot, lookup, Fuzzy lookup and slowly changing Dimension.
• Used Package Configuration to Migrate SSIS package from one environment to other.
• Used event handling to send E-mail on event like on error.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Used Query Analyzer to optimize SQL Queries.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Coded Procedures & User defined Functions in TSQL.
• Established and documented a complete Disaster Recovery Plan for the Database servers.