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 ERWIN and ER Studio.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for Physical Data model from Data Modeling changes.
• Knowledgeable of technical application architecture including SAS, UNIX and Oracle.
• 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.
• 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: SAS, 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 Business Intelligence (SAS).
• Business Reporting Requirements Analysis - Interacts with clients, participates in requirement gathering and system analysis
• Tested SAS applications on various Business reports
• 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
• Involved in analysis of Datasets generated using SAS through the front end.
• 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.
• Responsible for the development and maintenance of SAS Information Maps for Analytics and Business forecasting Team
• 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.
• Imported Data from relational database into SAS files per detailed specifications
• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Ran SAS scripts in UNIX test environment and acceptance environment for number of evaluation periods.
• 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: SAS, ETL Informatica, Microsoft Office Suite, Microsoft Visio, Oracle, XML Files, Flat files, Java SQL Server, Teradata, Sharepoint, UNIX, Business Objects.

Confidential, NC

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.
• Performed compare of the database tables using SAS scripts.
• 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
• Knowledgeable of technical application architecture including SAS, UNIX and Oracle.
• 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.
• Developed and executed Client level services reports that were generated using SAS.
• 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
• Performed compare of the database tables using SAS scripts.
• 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, SAS, Teradata, Sharepoint and UNIX.

Confidential, Wilmington, DE

Data Analyst

Role & 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.
• Responsible for the development and research of applications data using SAS
• 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.
• Performed database validation by executing SQL queries and testing of data correctness in SAS environment
• 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.

Environment: ETL, SQL Server BI Development Studio, Teradata V12, SSIS, SAS, 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.
• Developed test scripts and executed them for the Client level services reports that were generated using SAS.
• 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.
• Tested different kinds of SAS reports using global and local Filters
• 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