SUMMARY:

• Possesses over 17 years of experience in Information Technology in all phases of Software Development Life Cycle (SDLC) with Business Users Interaction including System Analysis, Design, Business Requirements Gathering, Development, Testing and Implementation in the Finance, Insurance, Telecom, Automobile, Banking, Health care, Life sciences, Manufacturing, Networking and e - commerce sectors.
• 7 + years of experience as ETL Business Analyst as Extract, Transform, Load, Develop, Test, Validate ETL Processes including Data Profile, Data Cleanse, Data Quality, Data Collection, Data Mapping activities, Gap and Impact Analysis.
• Expertise in requirements gathering, analyzing, documenting business requirements, understanding functional specification documents, developing Business Requirement Documents and Functional Requirement Specifications.
• Efficient using various Requirement gathering techniques like user interviews, workshops, email surveys, Joint Application Development (JAD) sessions with Clients, Vendors, Customers, Functional team, Technical team, Project Managers, Product Owners, Program managers, Developers, Business Users, Business Analysts, QA Analysts with relevant Subject Matter Experts referring to existing system documentation and procedures.
• Experienced in using different UML diagrams including Use Case Diagrams, Sequence Diagrams, Activity Diagrams and Collaboration Diagrams.
• Extensive exposure in writing functional specifications including interfaces and working with Technical, BA & QA teams.
• Strong knowledge of Business Analysis methodologies and High level understanding of SDLC using Waterfall and Agile including design implementation, module integration, testing and maintenance which includes experience in Service Oriented Architecture (SOA) and Enterprise Application Integration (EAI).
• Extensive ETL Business Analyst experience using Informatica, Business Objects Data Services and Data warehouse concepts.
• Having very strong skills with Microsoft Office suite and applications.
• Proven ability in managing multiple priorities in a high paced environment.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In and Sprint Review.
• Involved in design of the ETL BI solution using ETL, Source, Target and related Transformations based on the Requirements.
• Involved in creation of various Data Mapping Documents for different Tables and Files related to Source and Target Tables.
• Worked closely with the Business users, application development team in determining the exact business rules and functionalities required for the delivery of the work articles.
• Good knowledge in Big Data, Hadoop Architecture and various components such as HDFS, Job Tracker, Task Tracker, Data Node, Name Node and Map-Reduce concepts.
• Working experience on transforming data from/to various sources SAP R/3, SAP BW, JDE, BAAN, Oracle, MS SQL Server, Teradata using Data Services, and interacting with Business Analysts in identifying the needs, requirements of the system.
• Expertise in implementing Data Quality Transforms like Match Consolidation, Associate, Data and Address Cleansing.
• Excellent Project execution experience, good leadership, verbal, written, problem solving, attention to detail and strong communication skills.

TECHNICAL SKILLS:

Databases: DB2, Oracle 7.3/8/8i/9i/10g/11g, SQL Server 2005/2008, Teradata, MS-Access.

ETL: Business Objects Data Services 3.2/4.0,4.1,4.2, Informatica

Reporting: Xcelsius, Tableau, Business Objects XIR2, WebI, Universe Designer, HPQC

Languages: COBOL, CICS, JCL, C, C++, Java, SQL, PL/SQL and TSL

Web Technologies: J2EE, HTML, Java Script, ODBC,VB Script, ASP, IIS, Apache, Websphere, Weblogic

Browsers & Applications: IE, NS, Firefox, Toad, Business Objects, Crystal Reports, Data stage & Informatica

Operating Systems: Window 7//98/XP/NT/2000, UNIX, Mainframe Z/OS, MSDOS

Multimedia & Web: HTML/DHTML, MS Office, Adobe Photoshop, PageMaker

GUI & Testing Tools: Mercury/HP testing tools Win/Load Runner, Test Director/Quality Center/ALM, QTP, VB, IBM Rational Suite, MS Project/Word/Excel/Power Point, Clarify and Visio. Hadoop Technologies HDFS, MapReduce, HIVE, Pig, Sqoop, Hue, Spark, Oozie, HBase

Other Skills: Full lifecycle development, Interpersonal Skills, Handle Multiple Projects simultaneously, Project Management, Onsite-Offshore Model, Documentation & Team Player.

PROFESSIONAL EXPERIENCE:

Confidential,GA

Sr. Business Analyst

• Created functional specification document for Cisco SPVTG project.
• Interacted with Business and Technical Teams to break down the business requirements to technical specifications.
• Involved in writing Data Mapping Documents for the system using Excel and prepared reports using MS Access and involved in data analysis, ETL process for the retrieval of the data.
• Worked on Waterfall and Agile methodology based projects.
• Involved in Integrated Business planning with business users and stakeholders to learn their business processes.
• Elaborate the collected information as functional specifications for development.
• Assisted Business and Technical teams on requirements, design and clarifications.
• Interact with SAP Operations Team, worked on Supply & Demand planning, analyzed Business and Functional documentation to identify the technical impacts, document them in a low level Impact Assessment document.
• Managing multiple large datasets through ETL processes while maintaining data integrity and data quality.
• Document processes for extracting data from different sources, transforming and loading it into Confidential .
• Provided feasibility assessments to establish realistic timelines, level of effort, cost analysis, and resource allocation for operational enhancements and capital projects.
• Conducted meetings to review the Low-level design and Use case diagrams with Project team.
• Involved in Bi-weekly meetings related to creation and set up of Multicam Studio to monitor the dev & test activities for the various types of performance activities related to set top boxes for the COX, Confidential S25 and TWC customers.
• Extensively interacted with developers, business & management teams, reviewed business requirements, ETL (Extract, Transform and Load) design documents, technical specifications related to Source and Target mappings.
• Used SAP Information Steward for Data Profiling to measure Data Quality scores, Accuracy, Completeness, conformity, consistency, Integrity, uniqueness.
• Maintained very good working relationships with Cisco associates and Cisco Customers in all areas.
• Responsible for ETL jobs movement in QA and Dev Environments before moving them to Production.
• Used Data Services to load data from SAP ECC, flat files, HDFS Files into SQL Server DB, SAP HANA DB and Designed different workflows to extract, transform and load.
• Coordination with Project Managers; Program managers, Business leads; on-site and off-shore model support to create, execution and the development of system, attend trainings related to application support tools and project communications, issue resolution, risk analysis and project milestones.
• Monitor ETL jobs movement Dev to QA before moving them to Production.

Environment: SAP Business Objects Data Services, SAP OPS, SAP ECC, BI platform, SQL Server 2008, MS Project SharePoint, MS Office Suite, XWin Server, Tableau, CDETS, TIMS, Clarify, Hadoop, Windows, Oracle, .Net, Java, HTML, XML, HP - QTP, ALM, QC.

Confidential,MA

ETL Business Analyst

• Responsible ETL Business Analyst for Master Data Management, Involved in MDM solution for three domains. Interaction with MDM integration plan and hub architecture for customers, products, and vendor.
• Interaction with developers for technical specifications for various financial reports. Evaluated test scripts and Test Cases and Performed Unit, Integration, UAT testing, validations & conversion.
• Interact with SAP Operations Team; worked on Supply & Demand planning, work closely with business partners and internal teams by providing technical expertise prepared user documentation for all important business processes.
• Prepare detailed functional specifications for development activities including reports, interfaces, conversions, enhancements and forms
• Responsible for Back Office’s Data Stewardship Platform and Worked with Business users, coordinate with technical teams in documenting business rules documents, strategies with Data team, technical and functional teams.
• Involved in creating and validating Business Rules, Score carding, Data profiling using Information Stewards; performed data reconciliation using Universe and Information design tool, built rules for Data cleansing, and Address Cleansing packages .
• Prepared ETL mapping documents for data validation, look up and enrichment to push the data using AIO.
• Effective communication with Stake holders, Management, Operations, functional, BI, BA, Development & QA teams to ensure transparency, share insights, define scope, requirements on timely manner between teams to manage expectations.
• Understand entire process for assigned accounts and how the parts combine to make the whole.
• Turn processes into detailed functional requirements, involved in data mapping, file inventories, data flow and work flows.
• Successfully implemented sign-off and validation documents at various levels of data transition in between several groups of business. Involved in Data Cleaning process Data Enrichment and Data Standardization documents.
• Used Data Services to load data from SAP ECC, flat files, HDFS Files into SQL Server DB, SAP HANA DB and Designed different workflows to extract, transform and load.
• Coordination with Project Managers; Program managers, Business leads; on-site and off-shore model support to create, execution and the development of system, attend trainings related to application support tools and project communications, issue resolution, risk analysis and project milestones.
• Acted as Liaison between teams, Monitoring ETL jobs in QA to Production (Integration testing cycles and mock cycles).

Environment: SAP Operations, SAP Business Objects Data Services & Information Steward ETL Tools, BI platform, SQL Server 2008, MS Office, MS Access 2007, MS Project SharePoint, Tableau, HP-ALM, QTP, QC, Visio, Windows 7/NT.

Confidential,Solon,OH

Business Analyst

• Provide data driven insights and actionable recommendations to key stakeholders (operations, marketing, product management, program management) and understand and meet their analytics needs on a continual basis.
• Monitor existing metrics, analyze data, and partner with internal team members to identify process and system improvement opportunities and develop key metrics and performance indicators to evaluate performance.
• Perform exploratory data analysis to identify trends, patterns, correlations, and insights and present written business recommendations to the leadership in a clear and compelling way.
• Responsible for Customer Master Data loads using Business Objects Data Services (BODS 4.1/4.0) and Legacy System Migration Workbench (LSMW).
• Created jobs to profile data as per the business requirements, to enable a successful load of the data into different environments on the Target (SAP R3).
• Designed MDM solution for three domains. Developed MDM integration plan and hub architecture for customers, products, and vendor. Created Batch-jobs with multiple outputs for various Data Services objects Sales Quotes, Sales Order Management, Pricing Conditions, Vendor Master, Batch Master, CMIR, Inventory and Customer Consignment.
• Performed Data Profiling activity and transformed the input source data as per-loading requirements for the Migration process for the target loading process with Data Migration and Data Load teams to meet project standards.
• Involved in Design; Development and testing of New Data Services jobs, update the existing Data Services Jobs, Responsible for supporting and building interfaces from Non-SAP to SAP systems using IDOC’s.
• Worked with Business users, coordinate with technical teams in developing jobs, testing strategies with Database admin and SAP Basis admin to troubleshoot performance related issues.
• Had extensive knowledge on mapping, validation, look up and enrichment to push the data using AIO.
• Successfully implemented sign-off and validation mechanism, at various levels of data transition in between several groups of business. Involved in Data Cleaning process Data Enrichment, Cross Reference value changes and Data Standardization.
• Jobs scheduled/Monitored using Data Integrator Management console run through web interface and DS Designer Interface.
• Taking sources as a flat files/Excel spread sheets implemented necessary transformations to extract, transform and load the data into oracle/sql tables in the Rapid marts data ware house.
• Created Scripts like starting and ending script for each job, sending the job notification to users using scripts and declaring the variables in various local and Global Variables.
• Responsible for testing the ETL jobs in QA before moving them to Production (Integration testing cycles and mock cycles).
• Involved in Creation of Governance Design Guide with Data Governance team and Data team for Data Services.

Environment: SAP Business Objects Data Services, SAP Information Stewards 4.0, SAP Business Objects BI platform 7.0/4.0, SAP ECC/R3, LSMW, IDOCS, BPDM, SQL Server 2008, MS Project SharePoint, MS EXCEL 2007, MS Access 2007, Windows 7/NT.

Confidential,IA

Business Analyst

• Being a Business Analyst/ Lead in Health IT department, involved in reviewing business requirement document to identify possible gaps in the Requirements and involved in analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).
• Extensively interacted with developers, business & management teams to understand the business requirements and ETL design document specifications.
• Prepared Software Functional Specifications as per Business Requirements.
• Prepared training materials for new employees.
• Written low level design documents for development purposes.
• Worked at client location for gathering feedback from the users.
• Involved in Production Support and Enhancement Developments.
• Participated in regular project status meetings, BA & QA status meetings.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Creating Business Rules for ETL mappings and design documents for production support.
• Effectively communicate with Project Managers, Dev, BA and Test team activities and findings in oral and written formats.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts.
• Implemented testing objectives and analyzed the functionality of the application under test. Mentor new resources; lead the team in proficient way to understand QA best practices and testing methodologies to internal and external customers.
• Acted as liaison between technical; business and offshore (Pune - India) testing team.
• Conduct Automation review process meetings on quarterly basis with System Liaison, SME's and QA/QC team leads to improve the Regression Bed to ensure project closing procedures are completed.
• Develop document status reports time to time, attend status meetings, other project communications, and assisted in determining project tasks and milestones.
• Communicate product issues to development team for timely resolution of issues
• BA Lead coordination with Project Managers; Technical leads; QA Leads, AM's to create Master test plans; project communications, assisted project tasks determinations, risk analysis, test execution, production validation and milestones.

Environment: HP-ALM, QTP, QC, Windows2000, 98, XP, 7, SQL Server 2000, Oracle, DB2, .Net, Java, JavaScript, PL/SQL Developer, HTML, XML, Main Frames, Oracle 10g/11g, Informatica Power Center, MS Products, SQL developer, TOAD, SQL and PL/SQL, Web Services, Visio, GPS, MS Project SharePoint, UNIX, CICS, JCL, SOAP and Principal health Systems.

Confidential

Business Analyst

• Being a Business Analyst, heavily involved in the review, design, creation, preparation of functional, business documents related to ASPEN applications.
• Involved in business requirement documents review; use cases to identify possible gaps in the Requirements to help BA and QA teams to create test plans; test scenarios, test cases and test execution.
• Involved in understanding thoroughly all the ASPEN applications assisting in identifying, evaluating and resolving moderately complex problems.
• Mentor new resources, leading the team in proficient way to meet the dead lines. Implemented business, testing objectives and analyzed the functionality of the application.
• Wrote, executed and implemented business rules from business requirements/ functional specifications documents
• Ability to understand, evaluate XML data and upload the data to the MS Excel sheets.
• Customer service experience and lead responsibilities for Production Control Remedies.
• Developed status reports, attend status meetings, other project communications, project risk analysis and assisted in determining project tasks and milestones.

Environment: Windows 2000, 98, XP, SQL Server 2000, Oracle 10g, Java, PL/SQL Developer, HTML, XML, Main Frames, COBOL, DB2, CICS, ISPF, TSO, FAILEAID, W3AF, Test Track Pro, VB, CALIBER, QTP, Win Runner, Compuware products(Trackrecord, QA Center, Test Partner) Group wise.

Confidential, IA

Business Analyst

• Acted as a liaison between the Business team and Delivery team by participating in requirements gathering.
• Performed Qualitative and quantitative data analysis for the existing financial data in bank's system.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Develop the Functional Spec to support the Business requirements from the Business users
• Coordinates with different teams to develop customer specific file specs and resolve problems.
• Interacting with teams to understand the system & plan for the same to match for time bound quality response.
• Interacting with the teams on day to day basis to meet the deadlines.
• Worked with application development team to make sure that they understand the Use Case.
• Prepared data files and reports using MS Excel, MS Access and Business Objects.
• Produced visuals for the application using Rational Rose and created Use Case, Sequence Diagrams and Activity Diagrams.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timeline

Environment: Informatica, DB-2, Oracle, HTML, XML, Java, J2EE, Load Runner 7.5, DB2 UDB, Mainframes, WinRunner 7.6, QTP 6.5, Mercury Quality Center 8.0, IE 6.0, Window 2000/XP.

Confidential

Quality Assurance Analyst

• Worked in a Portal replacement and Telecom Billing projects; studied the application document and prepared test Scenarios based on requirements using Mercury's QTP automation tool.
• Acted as a business analyst in the requirement gathering and design process, and served as a SME to the UAT work effort.
• Prepared & executed test cases and communicated with team to resolve issues and bugs.
• Analyze, tests, and certify application-specific software and performs ambiguity review of business requirements; functional specification documents. Conducted Functional, Integration and Regression testing.
• Wrote SQL queries to check for proper data population in application tables.
• Maintained and updated scripts for regression test suite to effectively manage the testing process.
• Involved in functional and data driven testing of the application by passing data from MS excel sheets using Winrunnner.
• Gained Very good Telecom business knowledge while working in these two, Billing and Portal replacement projects.
• Investigated and documented the errors using Test Director. Coordinated with the development team for bug resolution.
• Demonstrated an understanding of risk management by providing sign-off of UAT test results.

Environment: QTP, Win Runner 6.0, Test Director, Windows NT/2000/XP, UNIX, Java, EJB, JSP, JDBC, Weblogic, IBM Websphere; Servlets and Oracle, SQL, PL/SQL.