SUMMARY

• Around 9 years of Business Systems Analysis experience in Information Technology and extensively worked in all phases of Software Development Life Cycle.
• Strong working experience with SDLC methodologies like Waterfall and Agile/Scrum.
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements using Joint Application Development (JAD) and Brainstorming sessions, Identify Functional, Non - Functional, and Business Rules, and then subsequently model them.
• Proven experience with end-to-end business process mapping, business and technical requirements analysis, business planning, modeling, verification and methodology and product development.
• Strong experience in Business andData Analysis, 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.
• 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
• 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
• Proficient in executing Test Plans, providing Test Data, documenting Test Cases and in performing User Acceptance Testing (UAT).

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Analyst / Data Analyst

Responsibilities:

• Involved in gathering requirements and preparing design and technical documents.
• Performed requirement gathering using both formal and informal sessions through interviews, questionnaire, video conferencing, JAD sessions and conference calls.
• Performed requirement analysis by gathering both functional and nonfunctional requirements based on interactions with the Users.
• Assessed and documented the flaws in the existing AS-IS system and made clear recommendations of Business Process Automation and incorporated them in the future TO-BE system design to perform Gap Analysis.
• Involved in creating and managing detailed design documents that outline the specifications, workflow, and actual graphic layout of proposed application solutions
• Perform detailed analysis of inbound and outbound interface data feeds
• Prepared User Acceptance Test Cases and ensured that all Business and Functional Requirements are adequately covered by the UAT Cases.
• Performed Business Requirements, Functional Specifications, and UAT walkthroughs with the team members and incorporated modifications and obtained Sign-off.
• Produced clear user manuals & training guides for User Acceptance Testing (UAT) and deployment with step-by-step instructions
• Responsible for creating Data Mapping documents and Data Dictionaries.
• Analyzed source and target systems and created data mapping documents.
• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Responsible for Extracting, Transforming and Loading data from various data bases MS SQL Server, MS Access, Oracle, DB2, XML files and Flat files.
• 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.
• 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.
• Actively participated in creating requirements Traceability matrices
• 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.

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.