SUMMARY

• Over Seven years of Experience in Business Analysis, Data Analysis in Agile environment in Healthcare, Finance and Ecommerce domains.
• Experience in Data analysis and Testing in different customer environments and platforms.
• 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,RDA(Rational Data Architect) ER Studio.
• Experience working at various stages of SDLC including: Requirements gathering, planning, design, development, and support coupled with Expertise in liaising with business customers, developers, offshore resources and other technology partners.
• Expertise in Information Engineering and Object Oriented principles and techniques.
• Knowledge of Project Management principles and techniques. Extensive use of Microsoft SharePoint for project management and project file archiving.
• Experience in user requirements gathering, use case design and analysis, Use Case Specification Documents (Use case scenarios, business processes, work flow diagrams, process flows and technical documentation, using Unified Modeling Language (UML) and MS Office Suite along with experience in planning, documenting and conducting User Acceptance Testing (UAT) for software application.
• Advanced experience in technical architecture of ETL tools, data staging techniques, source data integration and source - to-target mapping.
• Experienced in designing reports using SQL Server Reporting Services (SSRS), Cognos, BO, Crystal Reports and Excel Pivot table based on OLAP cubes.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Netezza, MS Access and Flat Files.
• Good Knowledge on OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Excellent experience in ALM and Jira for defect reporting and tracking.
• Extensive experience in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Data Mapping, and Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams.
• Experience in testing and writing SQL and PL/SQL statements.
• Strong experience in Excel and MS Access.
• Excellent work experience in creation of Project Plans, BRDs, FRDs, Use Cases, Activity Diagram, Requirement Traceability Matrix.
• Expertise in Erwin, TOAD and WinSQL tools.
• Skilled in Feasibility Studies, Scope Documents, Requests for Proposal and preparing end-user support documentation and materials. Experienced in performing GAP analysis.
• Well versed in creating User Interface (UI) focused website portals. Hands On experience in creating screen mock ups/ prototypes/wireframes and in Content Management System (CMS)
• Strong written and oral skills, interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

TECHNICAL SKILLS

Testing Tools: Quality Center/ALM, BMC Remedy, JIRA, SOAP UI,QNXT 4.7, Rational Clear Quest

Operating Systems: Windows XP/NT/2000, AIX UNIX, LINUX

Databases: Netezza 7.1, Oracle 11g, MS SQL Server 2008/2012, MS Access, DB2, Teradata V2R5/V2R6

Database tools: Aginity, SQL developer, Toad, SQL server management studio, squirrel

Web development: HTML, XML, VBScript, Java Script, REST

MS Suite: MS Office 2007 (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

Reporting Tools: Cognos, Business Objects 3.x, Crystal Reports

ETL Tools: Informatica 9/8.x, Data Stage 10.0/8.1/7.5 , SSIS

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Sr Business/DATA Analyst

Responsibilities:

• As a DA, the responsibilities penetrate across all business areas/units to design and implement solutions.
• Involved with the estimation of new projects.
• Creating technical specification/Mapping documents for ETL on the basis of business requirement provided.
• Data analysis and profiling using complex SQL queries.
• Acted as a liaison between the Stake holders and developers to create automated solutions.
• Involved in all phases of the Iterative approach of the SDLC from Inception to Transition
• Created and maintained project plans for multiple projects (Product development and Client projects) in MS Project.
• Managed the development of Continuous delivery product “Automateon” and Web analytics software “Tapestry KPI”. Coordinated and managed requirements for the change requests/enhancements by existing clients of the first version of these products.
• Involved in designing business use case scenarios, use case diagrams, and workflow charts for documenting the requirements.
• Created business process diagrams, work flow diagrams and Mock ups/wireframes for the web based applications.
• Performed GAP Analysis of business rules, business and system process flows, user administration and requirements to document the current as-is processes and the future to-be processes.
• Performed project management activities including delegating responsibilities, budgeting, designing time schedules and work breakdown structures, preparing weekly status reports for management, communicating and presenting the reports, and resolving issues and conflicts.Conducted daily scrum calls and coordinated status review meetings with tech leads and offshore team members.Involved in User Acceptance Testing (UAT)Created, managed and tracked tasks in JIRA.

Environment: Java, J2EE technology, .NET, ASP.NET, SQL Server, UNIX / Oracle Platform, MS Project, MS Outlook, JIRA, RDBMS, Talend, Jenkins, Docker, Apache Mesos, Gliffy, JIRA, Blazemeter, Jmeter, Selenium

Confidential, Eden priare, MN

Sr. Business Data Analyst/ Project Manager

Responsibilities:

• Tested extensively the Back end system by writing numerous SQL queries as per the ETL design specifications.
• Tested the new features involved in the SONY project as part of PRODUCT testing by segregating as Product Requirement Descriptions (PRDs).
• Moved to multiple project internally in the same capability as DA and created mapping documents, gap analysis and presentation.
• Validated several Informatica mappings as part of migration project testing and metadata validation.
• Simultaneously gathered functional requirements for Preventive services dash board and ACO dashboard of the reporting platform at HHC and also for an intra HHC web portal.
• Conducted JAD sessions with business stakeholders to reach a decision on changing strategies regarding the way business will be conducted on the new platform.
• Worked under the supervision of the Team Lead & Sr.Project Manager to gather requirements & functional specifications from Solution Architects, Business Users, Business Owners and Subject Matter Expertise (SMEs).
• Assisted the Sr. PM in Project management activities including delegating responsibilities, budgeting, designing time schedules and work breakdown structures, preparing weekly status reports for management, communicating and presenting the reports, and resolving issues and conflicts.
• Created Data Mapping documents using Fast track.
• Prepared Use Cases, Activity Diagrams using Rational Rose according toUMLmethodology thus defining the Data Process Models and uploading documents in Share point.
• Performed GAP Analysis of business rules, business and system process flows, user administration and requirements to document the current as-is processes and the future to-be processes.
• Documented Data Sources, Data Types, Dependencies, and Flows and assisted in the Development, Maintenance, Enforcement, and Monitoring of Data Governance Processes.
• Created Translational / Transformation Rules for Quadramed Data Mapping.
• Participated in planning and execution for functional, system, integration, and performance requirements for the BI platform.
• Created Business Requirements Document (BRD) creation for ICD 10 CM & PCS change implementation.
• Implemented ICD-9 & ICD-10 Mapping and Crosswalk Analysis.
• Participating in assigned work group meetings and supports the development and maintenance of ICD 10 CM & PCS required documentation.
• Performed and executed Integrity Testing, Requirement Testing, Balance Testing, Situational Testing, Code Set Testing, Line of Business Testing, Vendor / Trading Partner Testing according to HIPAA compliance.
• Facilitated UAT (User Acceptance Testing) with the stakeholders and the business users by writing test cases and test scripts, and the errors discovered were fixed and then verified via Regression testing.
• Assisted QA team to understand data and do root cause analysis of the defects.
• Working knowledge of the Data stage designer anddirector to schedule jobs, test, debug its components and monitor results and also for performance testing.

Confidential, Newark, NJ

Business/DATA Analyst

Responsibilities:

• Implementing logical and physical data modeling with STAR schema using Erwin in Data Mart.
• Coordinated with the development team based on the mapping document to review and sign off the ETL design document.
• Reviewed UAT Test Plans and Test Cases before being signed off by SMEs.
• Uploaded requirements into Quality Center and responsible for assigning the tasks in the Quality Center.
• Created test data based on various data scenarios and identified the sensitive fields for masking the data for test data bed.
• Used Agile to provide rapid feedback to the developers/testers significantly helping them uncover important risks.
• Created Test Plan and developed a test suite for Clear Vision V3.4.3 application.
• Created Manual Test scenario’s for various modules of Clear Vision V3.4.3 Application.
• Extensively involved in Business Analysis and Requirements Gathering
• Experienced in working with DB2,Teradata
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology.
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Responsible for creating all types of reports including Cross-tab reports using Crystal Reports.
• Used data conversion to Protect the data and prevent data loss
• Involved in installing and maintaining MS SQL Server 2000.
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access.
• Provided technical support and coaching to team members about functionality of MS Access.
• Migrated old Business Objects reports & crystal reports to BO XI.
• Generated reports using DESKI and WEBI.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Wrote data conversion and data migration scripts for ETL process
• Created ETL documents detailing the ETL (database navigation and data transformation) logic used by developers as coding specifications.
• Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
• Accelerate the rate of adoption of the system, improve the quality of the data being input and generated, and promote accountability amongst the staff and users.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.
• Import text files from legacy environment and outside communication agencies, using directory folder-to-directory folder file transfer protocols, using Data Transformation Services.
• As part of Data Profiling, developed Jobs to notify Data Stewards about data inconsistency for Attribute Analysis, and help provide quality data to business users.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Access databases and associated graphical user interfaces.
• Used SQL for Querying the DB2 database.

Environment: Informatica 8.5.1,Windows XP, Oracle10G, TOAD, SQL Developer, UNIX, SSIS, Data stage 7.5, Unix Shell Scripting, SOAP, Oracle, SQL Server 2008, SQL Server Integration Services (SSIS), RDBMS, Hyperion Performance Suite 8.5, Business Objects XIR2, Teradata V2R6, Java.

Confidential, Basking Ridge, New Jersey

Business System Analyst/Data Analyst

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required
• Analyzed data sources, prepared data conversion approach to load the data.
• Worked on profiling the data for understanding the data and mapping document.
• Designed the table structures and indexed them to pull out the data fast.
• Checked the naming standards, data integrity and referential integrity.
• Worked in importing and cleansing of data from various sources like Oracle, flat files onto SQL Server with high volume data
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Responsible for testing Business Reports developed by Business Objects XIR2.
• Created VBA Macros to convert the Excel Input files in to correct format and loaded them to SQL Server.
• Very Strong in writing complex SQL Functions.
• Developed and publish periodic reports from data stored in an SQL database
• Write SQL queries to validate that actual test results match with expected results
• Extensively worked on Backend using SQL Queries to validate the data in the database.
• Analyzed the Stored procedures and SQL Queries to improve the performance of queries and speed up the process.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS packages Dataflow and Bulk Insert
• Performed UAT testing.
• Scheduling and monitoring the ETL packages for Periodic load in SQL Server job Agent
• Executed the SSIS packages in command line, through Macros with DTEXEC.
• Wrote Stored Procedures for executing the SSIS packages remotely.
• Created/Tested the mapping rules according to the requirements in the ETL Packages.
• Implemented SDLC, QA methodologies and concepts in the Project
• Expertise in data quality, data organization, metadata and data profiling
• Tested the ETL packages comparing the input source files and Target Table data in SQL Server.
• Validated the ETL transformed data for data completeness, Data correctness and for according to mapping rules.
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
• Developed Test Summary Reports and participated in GO / NO-GO meetings.
• Completed knowledge transfer to employees enabling them to understand the complete data conversion process.

Environment: SSIS, SQL SERVER 2005, SQL, Business Objects6.1, PL/SQL, UNIX Shell Scripting, TOAD.

Confidential, Bentonville, AR

Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Aligned requirement documentation with use of UML for object oriented software development (OOD).
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
• Created job schedules to automate the ETL process.
• Developing Business Objects reports based on report Design documents (RRD) Effort estimation and providing it to the client.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and enterprise data warehouse.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Developed estimates, project plans (Microsoft project), training material and reports.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.

Environment: Java, J2EE technology, .NET, ASP.NET, SQL Server, UNIX / Oracle Platform, MS Visio, MS Outlook, MS project, MS Dynamics, RUP, Rational Rose 2002, Rational Clear Quest, Rational Clear Case, Rational requisite pro