SUMMARY:

• System and Data Analyst with over 7 years’ experience in Business Process Modelling, Business Requirements gathering and Business Process flow, Functional Design, Development and testing of batches and data migration projects
• Well experienced in business requirement gathering, Risk Analysis, Gap Analysis, Feasibility Studies
• Cross - functional domain expertise including Banking, Healthcare, Retail, Telecom
• Have a thorough knowledge of Software Development Life Cycle (SDLC) and its various methodologies such as Agile-Kanban, Waterfall
• Excellent team Player, quick learner and self-starter with effective communication, motivation and organizational skills combined with attention to details and business process improvements
• Led and worked with teams to examine and solve business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for their customers, strong leadership and mentoring skills, and highly proficient organizational and computer skills
• Proven ability to manage big to small consulting project activities that address and resolve key performance issues within the areas of finance, technology, resource planning, and organization
• Effective at interviewing all stakeholders; analyzing business requirements; translating those requirements into concise functional, non-functional requirements
• Performed Gap analysis of the as-is and to-be process flow of applications by identifying existing workflows, managing Change Requests to meet the end state requirements
• Created source to target by mapping requirements which is efficient during change management
• Creation of test cases and perform unit test, SIT and UAT. Creation of test report with test data characteristics; Preparing test data, creating test strategy and test plan and test reports
• Extensive knowledge of Business Process Modelling and working experience in converting business requirements into UML diagrams; also, managing and tracking those requirements
• International work experience with global offshore-onshore development models
• Proficient in using SQL and excel for data extraction, data analysis, reporting and testing
• Assisted in Data Mapping across systems and building templates for Customized Dashboards
• Expertise in Modelling Tools (MS Visio), Database (Teradata, Oracle), Testing Tools (Quality Centre), Management (MS Project, Share point)
• Strategic and analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that have eluded resolution by others
• Multi-tasking capabilities with ability to prioritize and manage projects under aggressive timelines
• Extensive knowledge of Date warehousing concepts, hands-on experience on Teradata, and concepts of Star Schema, Snowflake Schema
• Worked on ETL Tools like Ab Initio.

TECHNICAL SKILLS:

Database : Teradata, Oracle

Languages : SQL

ETL Tools: Ab-initio

Reporting Tools: Cognos, Tableau

DB Tools: SQL Assistant, Toad

Operating Systems : UNIX

Others : MS Office

Methodologies: Waterfall, Agile - Kanban

WORK EXPERIENCE:

Confidential

System Analyst

Responsibilities :

• Performed requirements gathering and analysis, ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Understanding the existing legacy Catamaran and Optum applications.
• Interacted with the Subject Matter Experts (SME’s), Operational/Technical Managers and Stakeholders to get a better understanding of business rules/processes and gather core Business Requirements.
• Managed issues and defects throughout the project lifecycle and escalated issues to the management.
• Conducted Elaboration sessions with Business SME to prepare the Document of Understanding and streamline business process.
• Conducted Requirement Analysis and Impact Analysis on business process and reports
• Created Business requirement documents.
• Analyzed and Modelled high level Business or System processes using MS VISIO
• Playback session with users to understand the end to end process flow.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification or Design Specifications.
• Worked on the design changes for the GUI screens and server changes with the development team.
• Developed interactive data visualizations and prototypes.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Developing and maintaining high level overview of the project and design flows using Visio diagram. Also created Process Flow Charts, Data Flow Diagrams.
• Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues and change requests
• Prepared PowerPoint slides to effectively communicate requirement understanding, project status with the business users and stake holders in the meetings
• Created document to capture both business and technical requirements in a concise manner for development team work. Created screen mock-ups for the look of the screen design.
• Documented solutions and created system design documents; Log defects and analyze the causes.
• Experience working with SQL for data validation, data analysis, testing and reporting.
• Worked on the functional testing for the web-based application and verified as per user standards.
• Created detailed test plans and test scripts to perform the testing.
• Created CRs for the dev team to work on the defects in the application.
• Identified and validated business rules and data elements. Performed Data mapping and logical data modeling.

Data Analyst/Business Analyst

Environment:Teradata, Tableau, Unix

Responsibilities :

• Understanding the existing application and analyze the data for issue resolution
• Analyst and Model high level Business or System processes using MS VISIO
• Involved in Requirement Analysis and Impact Analysis on business process and reports
• Work on standard business documents for existing processes.
• Performing data analysis and system analysis on the existing process.
• Working on interactive data visualizations and prototypes.

Business System Analyst

Environment:Teradata, Ab Initio, MS Office, Tableau, Unix scripting

Responsibilities :

• Understanding the existing application and analyze the data for issue resolution
• Analyzed and Modelled high level Business or System processes using MS VISIO
• Conducted Elaboration sessions with Business SME to prepare the Document of Understanding and streamline business process
• Conducted Requirement Analysis and Impact Analysis on business process and reports
• Created Business requirement documents
• Performed data analysis and extracted data from various tables in the Data Warehouse to identify the problem with the existing data and prepared documentation on the ongoing fix and data issues.
• Produced accurate analysis of project datasets as defined by the required specification.
• Developed interactive data visualizations and prototypes.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Closely worked with the Data modeling team to create the logical and physical data model. Also worked with DBA to implement the tables in all respective environments.
• Preparation of Functional Requirement Documents and Requirement Traceability Matrix
• Playback session on end to end process flow, user interface screens developed and its functionality to Business users
• Involved in project management and conducted daily stand-up meeting with offshore team to help manage deliverable progress
• Construction of Business processes in MS Visio tool
• Analyzed the data collected and process maps to determine the root causes and identify opportunities
• Increased the quality and on-time delivery of defects
• Performed GAP Analysis, designed new business process flows, and documented various business scenarios
• Documented high-level logical data models, Functional Requirement Documents (FRD/SRS), Non-Functional Requirements and BRD supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyse and document business data requirements
• Analysis and Creation of reporting requirements documents capturing all necessary metrics data required, business rules/formula, building report schema, and other report specification
• Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues and change requests
• Worked on MS Visio to design and create Process Flow Charts, Data Flow Diagrams and Use Case Diagrams
• Prepared PowerPoint slides to effectively communicate requirement understanding, project status with the business users and stake holders in the meetings
• Helped the Business Users while performing the testing and helping them resolve the defects in the environment
• I nt eracted with the testing team while developing the functional test cases and regression test case. Created UAT test strategy, UAT test cases/script, UAT test execution
• Walkthrough of Requirements with Senior Technical Architects, Solution Architect, Build (Dev) Team
• Document solution and update design documents if necessary; Log defects and analyze the causes
• Wrote SQL Statements to extract Data from database to verify the output Data of the reports
• Communicated status of efforts to management and business partners
• Assisted Project Manager in meeting schedules, budgeting, resource allocation, deadlines and maintaining a project schedule

Business Analyst

Environment:Windows XP, UNIX, Ab Initio, Cognos, MS VISIO, Maestro Scheduling, UNIX Scripting

Responsibilities :

• Conducted requirement elaboration sessions with various business users/SME
• Created business requirements documents, functional design document, requirement traceability matrix, source to target ETL mapping document, unified functional design document
• Conducted daily touch base call/daily stand-up meeting with senior solution architect, development lead, QA lead to help manage requirement clarifications, project deliverables
• Very good hands-on experience in using Oracle 10g, Ab Initio ETL tool
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema Dimensional Data Modeling used in relational, dimensional modeling and Slowly Changing Dimensions
• Involved Designing of Physical Layer, Business Model & Mapping Layer (logical modelling) & Presentation layer in Metadata
• Walkthrough of the business requirements and functional design documents with the Onsite and offshore development team
• Walkthrough of unified ETL functional design document, source to target ETL mapping document
• Analyze the migrated data and old data to see the behavior of new application on the migrated data
• Hands-on experience in analyzing and writing Teradata scripts
• Analyzing the feasibility of implementing the requested changes
• Preparation of Source DB to Target DB mapping sheet
• Preparing deep dive phase wise implementation blueprint plan
• Analyzed and Modelled high level Business or System processes, Process Flow documents using MS VISIO tool
• Expert in creating and scheduling the jobs in Maestro scheduler
• Created UAT test strategy, UAT test cases/script, UAT test execution
• Document solution and update user manuals if necessary Defect tracking in team track
• Actively involved in the performance testing of the batches and analyze the data in order to improve the performance of the batches
• Analyze the code and data to provide the feedback to development to team and how to improve the performance of the batches

Business System Analyst

Environment:Windows XP, Teradata, Ab Initio, Cognos Reports

Responsibilities :

• Conducted requirement elaboration session with onsite business users
• Actively involved in requirement and gap analysis
• Creation of Business requirement document and transforming those to detailed functional requirements
• Generated insights out of voluminous and complex datasets and built story lines.
• Prepared Process Flow documents based on the interaction with the Business Subject Matter Experts (SME)
• Create design documentation for the data models, data flow control process, metadata management
• Handled database administration work like creation and updating tables.
• Preparing the data migration rules to migrate the data from one system to another.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Prepared graphical depictions of use cases (activity diagrams, system context diagrams, sequence diagrams)
• Increased the quality and on-time delivery of application deployments by championing and implementing Agile practices for onshore and offshore teams
• Performed GAP Analysis, designed new business process flows, and documented various business scenarios.
• Participated on routine SCRUM and participated in sprint planning by presenting product backlog details to the team to facilitate understanding.
• Creation & execution of unit test cases
• Prepared unit test result document
• Validation of coding standards and generating the test plans with reports
• Scheduling the jobs and triggers accordingly
• Integration and User acceptance testing support
• Preparing production checklist and validating each components
• Also performed role of Production Deployment Co-coordinator
• Providing permanent fix for the repeated issues
• Post-Production deployment support
• Interacting with clients at the time of Support to reduce defect turnaround time

Confidential, IL

Business Analyst

Environment:Windows XP, Oracle, Ab Initio, Unix

Responsibilities :

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs for Loyalty eligible indicator fix issue.
• Solving and helping the users with the data issues in the Customer aggregate project, Transaction aggregate.
• Performed data analysis and extracted data from various tables in the Enterprise Data Warehouse to identify the problem with the existing data and prepared documentation on the ongoing fix and data issues.
• Interacted with end-users and functional analysts to gather and identify the doable requirements for developing Advanced Customer Analytics Platform.
• Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM) for ACAP which helped in controlling numerous artifacts produced by the teams across the deliverables.
• Conducted Joint Requirement Planning (JRP) & Joint Application Development (JAD) sessions with Business User Groups, Project, Product manager and team to accelerate the design of information technology solutions, planning and development of ACAP.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Analyzed dimensional and fact tables in data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures
• Produced accurate analysis of project datasets as defined by the required specification.
• Developed interactive data visualizations and prototypes..
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Worked with the report development manager and other team members on report requirements based on exiting reports/dashboards.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Use MS Excel, Word, Access, and Power Point to process data, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Business Analyst / Data Analyst

Environment:Pentium III/IV, Windows XP, Oracle, Ab Initio, Unix

Responsibilities :

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Conducted requirement elaboration sessions with various business users/SME.
• Created business requirements documents, functional design document, requirement traceability matrix, source to target ETL mapping document, unified functional design document.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Used UML and Visio for creating Activity diagrams, Sequence Diagrams.
• Identified the objects and relationships between the objects to develop a logical model.
• Designed reports/graphs/presentations using Ab Initio for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Oracle that can be used for development of various reports/ dashboards.
• Analyzed dimensional and fact tables in data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Techno-Functional Developer

Environment:Window 2000 and Windows XP, Oracle, TOAD, Ab Initio, Unix

Responsibilities:

• Understand and Capture the functional requirement and create the requirement document
• Performed application/system deep dive analysis
• Preparation of design and specification documents for the construction activities
• Analyzing the job flow and trace and fix the defects accordingly
• Creation & execution of unit test cases
• Participated in ETL development process using Ab Initio GDE 1.13.
• Developed generic graphs to take process all reference files.
• Involved in various documentations like Technical Design Document, Mapping Documents and review those documents.
• Involved in creating unit test plans, unit test cases, unit test scripts and unit test reports to verify accuracy of programs and the interdependent relationship of programs and systems.
• Prepared unit test result document
• Validation of coding standards and generating the test plans with reports
• Scheduling the jobs and triggers accordingly
• Integration and User acceptance testing support
• Preparing production checklist and validating each components
• Also performed role of Production Deployment Co-coordinator
• Providing permanent fix for the repeated issues
• Post-Production deployment support
• Weekly status reporting and project management
• Interacting with clients at the time of Support to reduce defect turnaround time