SUMMARY

• Experienced Systems Analyst with 9 years of experience in the analysis, design and development of Data warehouse and Business Intelligence applications, Testing process, requirements gathering and expectation
• Strong experience in Business andData Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Ability to document the procedures, and ability to write specifications for data models to be developed.
• Highly analytical and process - oriented data analyst with in-depth knowledge of database types; research methodologies; manipulation and visualization of data.
• Excellent SQL & PL/SQL skills with both DML,DDL commands and demonstrated ability to write complex queries for purpose of analyzing data and/or evaluating how information needs might be translated into back end database.
• Extensive hands-on experience in eliciting, defining, documenting, functional, non-functional requirements.
• Extensive experience in SQL, Oracle Back-end, PL/SQL Development
• Experience working with relational database management systems such as MS SQL Server, Oracle, Teradata, DB2.
• Solid hands on experience with Data warehousing tools, Data Analysis, Data Modelling, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Used extensively JIRA board for task tracking and task creating for sprints
• Worked on Logical and Physical data modeling and other design review sessions to determine and describe data flow from source to target databases by coordinating with Business Analysts, DBA's and Application Architects
• Expert in Data Integrity constraints, Performance Tuning,Query Optimization and Validation issues.
• Good understanding of SQL Server and Oracle Architecture in terms of ETL and query processing, structure and performance and table partitions.
• Experience in parsing and creating script data from disparate formats like XML, JSON and CSV

PROFESSIONAL EXPERIENCE

Confidential

Sr. Systems Analyst / Data Analyst

Responsibilities:

• Involved in gathering requirements and preparing design and technical documents.
• Responsible for creating Data Mapping documents and Data Dictionaries.
• Analyzed source and target systems and created data mapping documents.
• Responsible for Extracting, Transforming and Loading data from various data bases MS SQL Server, MS Access, Oracle, DB2, XML files and Flat files.
• Develop artifacts that are consumed by the data engineering team such as source to target mappings, data quality rules, and data transformation rules, Joins etc. for the various EIM projects.
• Involved in designing, developing and testing of various artifacts and support entire Migration process from different databases of transactional system into ODS, which then is loaded into data ware house.
• Closely collaborate with end users in finalizing dashboard layouts and achieving desired look-and-feel of reports.
• Involved in design of data models, table structures, and views to support reporting requirements
• Develop specifications for data integration & movement that includes performing data profiling, data analysis, identify data related issues and provide a suggested resolution, create source/target mappings and transformation, load and data cleansing rules.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Support development troubleshooting of data defects with transactional or data warehouse system.
• Extensively worked with backend activities for data validation on several reports developed by BI tools. Written several complex SQL queries.
• Extensively used SQL Queries to verify and validate the Database Updates.
• Created programming scripts to clean up, normalize, and transform data to and from JSON format
• Actively participated in creating requirements Traceability matrices
• Manage day to day activities conducted by offshore resources
• Coordinate with multiple teams (USIG, New Business, and Sales) for End to End data integration planning and execution.
• Interacting with Systems Architect, Developers to review the workflow architecture of various modules of Sales
• Designed and Developed data validation, load processes and test cases using PL/SQL, SQL.
• Responsible for performing Data Migration validation and Data Integration validation
• Perform extensive Data Validation using SQL scripts to pin point the breakage in the Data Flow
• Developing macros, lookup functions, pivot tables, etc. using excel functionality to reduce the time spent doing routing documentation work.

Environment: SQL Server, Oracle 12C, JIRA, SQL, PL/SQL,JSON, Share point, MS Excel, MS Word, MS Visio, MS Outlook, SQL Server Management Studios, SQL Server Analytical studio, Windows 7.

Confidential

Systems Analyst

Responsibilities:

• Analyze the existing application’s information by understanding the data transition between systems.
• Responsible for creating Data Mapping documents and Data Dictionaries.
• Analyzed source and target systems and created data mapping documents.
• Extensively working on various data sources DB2, Oracle, XML/Flat files, Excel spreadsheets, transformed and mapped non-standard data to standard codes for data integrity and loaded the target Oracle warehouse database.
• Developed Stored Procedures/ ETL processes on Oracle as needed to Extract, Transform and Load the data from multiple source systems to the data warehouse.
• Rewrite all the reports based on Legacy process by creating packages and PL/SQL stored procedures based on requirements from business.
• Involved in extensive DATA validation by writing several complex SQL and PLSQL scripts and Involved in back-end testing and worked with data quality issues.
• Working as lead involves interaction with the business users to break down business requirements into technical/ETL specifications and apply those rules during development.
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Pre-Migration testing and validation of all data elements been converted.
• Conducted JAD sessions with technical and business stakeholders to determine data and interoperability requirements and also to come up with the best solutions for design and implement the BI Reports using Tableau.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP.
• Developed script in SQL to perform end to end testing of the migration for each table being migrated.

Environment: Oracle 11g, Oracle 12C, SQL, PL-SQL, Erwin, Tableau, Share point, JIRA, MS Excel, MS Word, MS Visio, MS Outlook, SQL Developer, DB2, OCTOPUS, GIT, Team City, JIRA.

Confidential

Systems Analyst

Responsibilities:

• Was responsible for analyzing raw data, drawing conclusions & developing recommendations writing T-SQL scripts to manipulate data for data loads and extracts.
• Responsible for creating Data Mapping documents and Data Dictionaries.
• Analyzed source and target systems and created data mapping documents.
• Analyzed user requirements, attended change request meetings to document changes and implemented procedures to test changes.
• Designed ad hoc queries in SQL Server management studio based on request. Examined reports and presented findings in Excel.Facilitated file sharing and correspondence tracking with SharePoint.
• Executed Data quality checks in the form of SQL queries to ensure data integrity and enforce business rules.
• Analyzed Business Requirements provided by the client and already existing mainframe application and ensured that there are no missing links and no ambiguity in the requirements.
• Created Source to target Data mapping document of input /output attributes with the proper transformations which would help for the easy development of Informatica code.
• Worked with Informatica developers to debug the jobs and looked for the errors using the Informatica debugger.
• Analysis of the data stored in DB2 tables and the mainframe files required for the testing Team.
• Worked closely with the testing team in the testing of the transformed Informatica code and provides the reviewed results to the clients.Worked with the users to do the User Acceptance Testing (UAT).
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Extensively involved with Data cleansing, formatting of the data to correct the mismatch in Staging area.
• Performed Data Profiling and extensive data validation to ensure report matches with existing mainframe Files.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from XML to the staging area and from Staging to ODS using Informatica Power Center.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.Worked extensively with the ERwin Model Mart for version control.
• Worked on daily basis with the main frame team to analyze the COBOL code and the process going in Mainframe application for each deliverable.
• Assisted the database modelers in preparing the logical and physical data models and ascertained that requirements have been met and have worked on loading the tables in the Data Warehouse.
• Wrote SQLs using QMF to query the DB2 database on mainframe and Sql server using Sql server management studio to analyze the data.

Environment: SQL, ETL Tool Informatica, QMF, Sql server, DB2, Sql server Management studio, MS Excel, MS Visio, JIRA, Erwin, Informatica Power center, Windows 7, Microsoft Office.