SUMMARY:

• Around seven years of extensive experience in ETL (Extract Transform Load), Data Integration and Data Warehousing using Informatica Power Center, Teradata and Oracle PL/SQL.
• Experience in designing star schema (identification of facts, measures and dimensions), for Data Warehouse, ODS architecture by using tools like ERWIN data modeler.
• Experience of using Revitas Contract Manager for the authoring, management, and storage of contract on the automated system.
• Experience on QA test scripts for Tableu analytics platform upgrade.
• Experience in utilizing Cognos BI tools for developing end to end BI solutions that includes reports, dashboards, security and infrastructure.
• Experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 9.x& 8.x
• Expertise in the use of tools such as Caliber RM, Rational Rose, Requisite Pro, Starteam, Test Director.
• Experience in gathering requirements from CMS via calls, Build and Maintain metrics, KPI's via Tableau Visualizations and Dashboards in Tableau Desktop Professional (TDP) and publish them onto Tableau Server for CMS users to access via web.
• Experience in Project Management, design and implementation of Master Data Management (MDM) application for Aon Risk Services (ARS) with business benefit.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using MS Visio and IBM's Rational Rose.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Expert in conducting and facilitating various requirement facilitation sessions like Joint Application Development (JADS), Rapid Application development (RAD), to ensure that all viewpoints, ideas and problems are incorporated.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD).
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD).
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Informatica.
• Expert in writing queries using the SQL/Oracle Server to perform data analysis, data validation, data governance, data mining, and data cleansing, extensive knowledge in ETL process, Data Mapping, Data Modeling, Star/Snowflake Schemas, OLTP/OLAP, designing E - R Models and reference data management.
• Experience in performing Gap Analysis, Feasibility Study and Change Management.
• Knowledge with Rational Requisite Pro and DOORS for Requirement management and created traceability metrics among requirements.
• Very good experience in Error Handling, Execution Recovery and Performance Enhancement of Talend DI Jobs.
• Experience in IT, Corporate Security, Store Services, and HR to align executive leadership in the design of the security matrix and data security levels.
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle.
• Proficient Business Intelligence (BI) Tools, Data Warehouse Applications, OLAP Analysis, and reporting Tools like Cognos, Business Objects, SSRS and Micro strategy.
• Deep understanding of enterprise data warehouses.

TECHNICAL SKILLS:

Automation Tools:: MS Visio, Rational Requisite Pro, DOORS, SharePoint

Bug Tracking Tools:: Tracer, XX Test GUI.

Utility Tools:: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools:: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools:: Informatics, Erwin, Magneto

Tracking /Testing Tools:: Quick TestPro (QTP), TestDirector, HP LoadRunner

Project Management Tools:: MS Project, Revenue Project,Airlines Commission Project

WORK EXPERIENCE:

Confidential, Charlotte, NC

Data Warehousing Analyst

Responsibilties

• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and loaded using ETL Informatica Power Center.
• Worked in Production support team for maintaining the data mappings, sessions and workflows to load the data in Data warehouse.
• Involved in designing and developing ETL (SSIS) processes & implementing Logging strategies when loading data into data warehouses and data marts.
• Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Collaborated with DBA team to perform Data Modeling: designed new relational database table/views.
• Extensively performed backend testing on databases and ensured that the data is moved from source to target database by writing complex SQL queries.
• Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Coordinated with lines of business, market risk, technology and reporting teams to understand ledger reconciliation processes, validate data flow from source systems to reporting repository, and drive data clean-up exercises.
• Worked actively on the Revitas Insight Data Mart for operational, analytical, or strategic reporting capabilities, saving time, money, and resources that might be spent restoring and mapping data.
• Worked on a comprehensive security Matrix that documented the security design and controlled the user requests in the production environment.
• Extracted (Access, SQL Server) and analyzes datasets to determine key operational metrics for senior management to make sound data driven decisions.
• Worked on automated business group data validation process for a large multitenant datawarehouse project with Cognos reporting portal for report delivery.
• Worked on Data Modeling using Dimensional Data Modeling and Fact & Dimensional, Physical & Logical data modeling
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Worked with business analysts by providing specific and crucial information through data mining using Teradata, SQL, BTEQ, UNIX and SAS.
• Design & Implementation and Roll-out for a process management tool Siebel-Documentum(full-lifecycle).
• Created artifacts including use case diagrams through Rational DOORS.
• Validated each and every Business Logic incorporated in aggregated views in Target state Data Warehouse (Teradata) as well as in the automated Cognos reports.
• Generating the reports for Teradata and Oracle Database to analyze the customer behavior and plan strategies to improve the response rates of marketing Campaigns.
• Documented the use cases on database using Rational DOORS Next Generation tool.
• Involved in creation of a web based applications using HTML, AJAX and JavaScript on the client side, and JSP’s and Oracle databases on the server side.
• Incorporated Agile methodology and SCRUM techniques to manage requirements.
• Worked on User Stories throughout the Agile Lifecycle using tools such as JIRA.

Business Data Analyst

Responsibilties:

• Worked on MS SQL Server interface to a Big Data Warehouse Framework (Talend and MicroStrategy) to support MDA’s business intelligence and collaboration services (MICS).
• Involved in documentation of Data Mapping and ETL specifications for Data warehouse.
• Maintained the data object model (Rational Rose), designed new database tables and changes to existing ones (Oracle and SQL).
• Created agile framework artifacts such as: Product Backlog, Sprint Backlog, User Stories, Acceptance Criteria and UML Diagrams.
• Participated in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Provided supporting role to VP and Business Development Director in formulating reports to perform data analysis (e.g. sales, inventory, over/under stocking) using Crystal Reports.
• Established software release procedures, defect database, and change proposal forms using DOORS tool.
• Provided guidance and direction for the SharePoint migration process to find best approach for gathering metadata, analyzing data, streamlining the migration process, and testing, to move data to the hybrid.
• Identified entities and attributes and worked on conceptual, logical and physical models using ERWIN.
• Assisted the group with IDL coding/plotting, poster printing and general research support.
• Entirely responsible for backend operations like data mining, data cleansing, data wrangling and pre-processing.
• Provided architecture team, with logical data modeling, physical database design, enterprise data definition, data load, stored procedures, triggers and a complex bi-directional replication schema as well as attending design reviews.
• Involved in creating Functional Specifications Document (FSD), Data Mapping and Data Conversion/transformation documents.
• Introduced new functionality to improve old outdated processes through Standard SAP configuration.
• Worked as the Quality Center Administrator to perform day-to-day maintenance, production support, user training, enhancement, workflow modification/upgradation, user accounts maintenance, troubleshooting, generate status & progress report for management.
• Coordinated Cognos framework manager model adjustments to accommodate new and existing business requirements.
• Responsible for utilizing and becoming proficient in several work environments such as, SAS, Tableu.
• Assisted with data loads into Oracle OLTP and OLAP databases.
• Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data.
• Created the conceptual, Logical and Physical Model for the data warehouse with emphasis mutual funds and annuity using Erwin data modeling tool.
• Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Derived Column, Conditional Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using SSIS.

Data Analyst

Responsibilties:

• Worked on Informatica Data Transformation to allow the import of unstructured data such as Excel spreadsheets into the Enterprise Data Warehouse.
• Validated the most granular data items against OLAP systems and identified the source tables from which the data warehouse extracts data.
• Evaluated the work load of all Finance employees, make recommendations for efficiency improvements; train existing staff and new hires in the use of JDE applications.
• Worked on MS SQL Server interface to a Big Data Warehouse Framework (Talend and MicroStrategy) to support MDA’s business intelligence and collaboration services (MICS).
• Worked on Teradata SQL scripts using various characters, numeric and date functions.
• Performed Feasibility and GAP analysis to understand various aspects of As and To Be scenarios of the system.
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Wrote data flow documentation using Visio for Business Intelligence (BI) projects.
• Performed data modeling with DBA to create new Oracle tables for After Market team.
• Used various SQL commands like create, delete, update, left joins, right joins and full joins to update the database and retrieve data for analysis.
• Wrote SQL scripts to extract data from database.
• Utilized MS Word, Oracle SQL, PowerPoint, Excel, HP Quality Center.
• Used the UML & Visio for structuring / modeling the whole project.
• Identify Use Cases and developed Use Case Diagram using UML.
• Worked on packages to extract, transform, and load data from Excel, Access, Flat files, Oracle, SQL server into data warehouse.
• Responsible primarily for Cash Equities Trading, Single Stock Flow Derivatives and Equity Capital Markets businesses.
• Produced, integrated, and maintained technical and functional documentation including Functional Requirements Documents (FRD), System Design Documents (SDD), Work Breakdown Structure (WBS), Requirements Traceability Matrix (RTM), and application Release Notes.
• Worked with other business analysts to plot out SDLC using a waterfall/Agile hybrid
• Engaged with Business Analysts to assure business perspective to integrations and support timely UAT.
• Involved in the implementation and completion of the ADP conversion for the company's payroll and human resource information system (HRIS).