SUMMARY:

• More than 7 years of Experience in Data Analysis, Data Modeling, Data Warehouse professional with applied Information Technology.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWINand ER Studio.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for Physical Data model from Data Modeling changes.
• Specializing in the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms.
• Experience in Data Warehouse, Data Mart Design and Data Warehouse Bus Architecture.
• Deep knowledge of RDBMS structures including schema creation, modification.
• Extensive knowledge of Structured Query Language including SQL and vi editor commands.
• Experience in Extract, Transform, and Load (ETL) / Data Staging, Design and Testing.
• Excellent knowledge of waterfall and Agile methodologies of Software Development Life Cycle (SDLC).
• Extensive experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Experience in Relational and Dimensional (Star Schema) Data Modeling.
• Experience in Understanding Business Requirements, analytical and communication skills with a strong technical background.
• Excellent communication skills, including writing failure and maintainence emails to large groups of people.
• Excellent Math skills required for data reconciliation and profiling.
• Having good experience in Excel, macros VBA and Visio
• Experienced in working for data governance and interacting with data stewards to understand data issues that prevent good quality of data.
• Efficient in VBA for MS Excel for planning/status reporting and creating test data.
• Highly dependable Data Analyst successful at profiling and interpreting data. Supportive and enthusiastic team player dedicated to streamlining processes and efficiently reconciling data issues.

TECHNICAL SKILLS:

Reporting & Analysis: BO (SAP Business Objects), SSRS,OBIEE, Microsoft Excel

ETL Testing Tools: Informatica, SSIS

Bug Tracking Tools: Quality Center, Jira

Versioning Tools: CVS, Microsoft SharePoint

RDBMS: Oracle, SQL, MS SQL, Teradata

Languages: VBA, XML

Operating Systems: Windows and Unix

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Data Analyst

Responsibilities:

• Developed Business Intelligence Reports & Dashboards using Oracle Business Intelligence, Business Object, Qlikview.
• Business Reporting Requirements Analysis - Interacts with clients, participates in requirement gathering and system analysis
• Developed ETL data mappings using Informatica for extract, transform and loading data from OLAP system to OLTP system.
• Created reports and graphs using Business objects to meet the business requirements of the project. Worked closely with BA to determine feasibility and determine LOEs
• Created and complete testing of repository, reports, dashboards and analytics to ensure they meet documented business requirements
• Proactively communicated issues to team to assist in managing defects. Implemented LDAP authentication in Oracle Business Intelligence 11g.
• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin with Architect teams.
• Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Designed ETL architecture to Process large no of files and created High-level design, low-level design documents.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
• Testing and debugging of all ETL objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Informatica On-Cloud Implementation & building mappings.
• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Customized and monitored incremental and full loading of Production using DAC.
• Configure DAC execution plans for scheduling to run ETL processes.
• Design and develop Informatica mappings, sessions and workflows

Environment: ETL Informatica, Microsoft Office Suite, Microsoft Visio, Oracle, XML Files, Flat files, Java SQL Server, Teradata, Sharepoint, UNIX, Business Objects.

Confidential

Data Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collaborate with data modelers, ETL developers in the creating the Data mapping document.
• Worked as a business analyst to build enterprise reporting system to support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Used SWIFT messaging system to test the flow of messages from and into the new system and was involved in ETL process
• Suggested the data formats on the front-end screen to ensure its compatibility with SWIFT format
• Extensively used Teradata Advanced Techniques in writing the scripts
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Assisted design logical models (relationship, cardinality, attributes, candidate keys) as per business requirements using ERwin Data Modeller.
• Generated flat files using the Teradata Export for the Segmentation process
• Designed and implemented SQL queries for QA testing;
• Coordinated with the QA Offshore team for testing activities across multiple systems and managed test execution.
• Participated in QA Team meetings and bug tracking meetings
• Extensive use of Teradata Utilities (BTEQ, MLOAD, FASTLOAD, FASTEXPORT)
• Provided testing results and weekly status reports to the QA Manager
• Collaborated with Basel II team on credit risk analysis and issue resolution and data quality validation and verification
• Tested Performance & Accuracy related queries under SQL Server and Teradata.
• Created relationships in Requirement Traceability Matrix linking Business Requirements / Mapping document to test case design document.

Environment: ETL, Microsoft Office Suite, Microsoft Visio, Oracle, XML Files, Flat files, Java SQL Server, Teradata, Sharepoint, UNIX, Business Objects.

Confidential, Wilmington, DE

Data Analyst

Responsibilities:

• Involved with creating the ETL specifications documents and contributing to the Detailed design of the DW.
• Used Power point to present the design issues / challenges documents to solution architect and DBA.
• Took part in requirements gathering through interactions with business analyst/users team Analyze requirements and source systems, perform Source data identification, Analysis and Data Profiling
• Created detail mapping trackers prepared by business analyst
• Involved with review of estimation of DW development and testing effort.
• Track tasks progress through daily/weekly status calls. Took part in bug triage meetings to make sure defect aging was controlled.
• Involved with the request creation for the development and test environment set up.
• Reviewed if required SSIS projects and Teradata fastload and multiload scripts, to extract, transform, generate files and transfer the files to Vendor and collected the metadata and validated it with the mapping document.
• Provide necessary assistance to offshore team for development and testing activities.
• Reviewed test plans, test scenarios, test cases as part of Unit testing and Integration Testing
• Provide support System integration testing(SIT),User acceptance testing(UAT)
• Address performance related issues through performance tuning and query optimization
• Responsible for release management of code through development, system integration testing, User’s acceptance test, Implementation Readiness, Production implementation.
• Quality Management- Ensure adherence to CMMI and Six Sigma. Update related documents.
• Project Management - CMMI Implementation, Developing Project Plans,manage work activities, meet deadlines, resources.
• The challenge was using SSIS ETL tool to load tables in Teradata using fastload scripts in the absence of UNIX environment.

Environment: ETL, SQL Server BI Development Studio, Teradata V12,SSIS, MS SQL Server, Flat files

Confidential, MN

Database Tester

Responsibilities:

• Verifying the Business requirement document and Technical design document against requirements.
• Prepared Test Scenarios based on understanding of business process flow.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Trained on building Conceptual, Logical and Physical data model.
• Worked on the model based volumetric analysis and data based volumetric analysis to provide accurate space requirements to the production support team.
• Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System.
• Worked with the test team to provide insights into the data scenarios and test case
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Verify and analyze data mapping issues and work with data analysts to find effective fixes
• Involve in review the Use cases of functionality with project team.
• Involve in peer review of Test scenarios written by testing team.
• Prepared Daily Status and Weekly status report
• Attending reviews, status meetings and customer interaction.

Environment: Java, J2EE, HP Quality Center, SharePoint