SUMMARY

• A result oriented Business Analyst with more than 9 years of extensive experience in the field of Information Systems, Business Analysis, Business Modeling, Document Processing, and Business Intelligence with a sound knowledge of different phases of software development life cycle (SDLC) including analysis, design, development, testing, Implementation and maintenance.
• Expertise inBusinessAnalysis, Scope Validation, Product backlog, Prioritization, project timelines and project milestones.
• Diversified domain experience in Telecommunications, Financial, Retail, Banking and Insurance.
• Extensive experience in Conceptualization to Implementation with experience in Requirements Gathering, Documentation, Workflow Preparation, Process re - engineering, Process Mapping, Scheduling, Capacity Planning, Statistical and Data Testing.
• Performed feasibility and impact analysis by identifying and gathering requirements for functional and non-functional teams.
• Experience working on Big Data Projects, Enterprise Information Architecture, Enterprise Data Modeling (EDM), ETL Processes, OLTP, OLAP, Data warehousing, Dimensional Modeling, and Business Intelligence (BI).
• Strong skills Confidential SQL, Data Analysis, Data Mapping, Data Profiling. Exposure to ETL process through Informatica and SSIS.
• Experience working with reporting tools like SSRS, OBIEE, Business Objects and Crystal Reports.
• Extensively worked on star schema and snowflake schemas and modified existing schemas to meet the business requirements.
• Extensively worked with source systems like MS SQL Server, Greenplum, HDFS, Oracle, Flat and XML files.
• Experience in writing SQL statements, views, materialized views, stored procedures.
• Expertise in formulating test approaches with Load, Integration, Regression and User acceptance Testing (UAT).
• Highly analytical in developing the methods and measures to meet requirements and solve any issues.
• Extensive experience with writing Story cards/ User Stories for the functional development and conducting sessions, methodologies like Waterfall and Agile.
• Facilitated Change Management across entire process from project conceptualization to testing through project delivery, Software Development & Implementation Management in diverse business & technical environments, with demonstrated Leadership Abilities.
• Excellent communication skills and ability to work effectively with technical teams in order to translate business requirements into an effective solution and serve as an effective communication channel.
• Self-starter with great leadership skills and demonstrated high aptitude in implementation of large scale projects
• Effective Time Management Skills and consistent ability to meet deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, Power Exchange, SSIS, Talend

Databases: Oracle 11g/10g/9i/8i, SQL Server 2012/2008, Netezza 7.0.2, Teradata, DB2

Database Tools/Utility: SQL Developer, Toad, Nexus, Enterprise Manager, SQL Plus, SQL Assistant, PG III Admin

Languages: SQL, PL/ SQL, T-SQL, Shell Scripting

Reporting: OBIEE 11.1.1.7, Business Objects

Scheduling Tools: Tidal, Informatica Scheduler, AutoSys, ESP scheduler, Tivoli.

Operating Systems: Windows, Unix, Linux

Other Tools: HP Quality Center, MS Office, MS Access, MS-Visio, Enterprise Architect, ERwin, Power Center Mapping Architect for Visio

PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential, Kansas City, KS

Responsibilities:

• Conducted analysis, design and solution delivery for the data load design.
• Worked closely with the data architect and the users to design the interfaces and data loads to ODS.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Developed views and stored procedures to needed for the source data.
• Understanding the Business Processes and prepared mapping documents based on standard templates.
• Understanding the Scope and preparing the Project Plan, Work Breakdown Structure, and Critical Path Analysis.
• Eliciting the requirements from the business owners for conceptual understanding of the business functions, analyzing and presenting artifacts like Business Requirements, Functional Requirements, Non Functional Requirements and Data Requirements.
• Understanding of Functional Requirements Documentation and Ensure Implementation of Final Requirements.
• Support and facilitate the SME’s and Data Architect in analysis and designing Logical and Physical Architecture in design phase.
• Facilitating the technical team in determining and Validating potential data sources, Business rules, DDL scripts, building Validation plan, and communicating the reports in different environments.
• Responsible for developing application requirements and maintaining Traceability Matrix.
• Followed SCRUM methodology in implementation of SDLC process supporting Product Owner for researching for User Stories.
• Assisted SCRUM team in documentation, wireframes, GUI Screens, Mockups and test cases.
• Participating in Testing, Production and Go-Live activities.

Environment: SQL Server Management Studio, Informatica Power Center, SSIS, SSAS, AS400, Tidal, Oracle, Hadoop, Greenplum.

Sr. Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Designed and developed expense model to assign and allocate expenses to business units.
• Worked closely with the financial analyst, data source system experts and the business users to design the interfaces and data loads to the warehouse.
• Responsible to identify business requirements from stakeholders using Joint Application Development sessions and interviews for complex business objectives with respect to each expense model.
• Responsible for analysis of future state requirements and process flows.
• Worked on scripts to process data and developed validation scripts.
• Worked with financial consultants to analyze and develop requirements.
• Worked closely and interact directly with the client’s business owners and IT staff to identify, rationalize and document business requirements.
• Conducted meetings with the senior management to present the cost/benefit analysis.

Environment: Oracle SQL Developer, Informatica Power Center, OBIEE, Autosys, Oracle, DB2, Linux.

Sr. ETL Developer

Confidential, Atlanta, GA

Responsibilities:

• Designed and developed ETL code to extract data from enterprise DW and other systems into Datamart.
• Involved in business analysis and technical design sessions to develop requirements document and ETL specifications.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Worked on JIRA (Helpdesk) tickets to address requests by the report writers to enhance ETL or fix data issues.
• Provided weekend on-call support.

Environment: Informatica Power Center, Netezza, Oracle, Teradata, Nexus, Business Objects, TOAD, SunOS.

Sr. Informatica Developer

Confidential, Charlotte, NC

Responsibilities:

• Worked on conversion and workforce hub load from legacy systems.
• Worked on ETL mappings using XML parser, XML generator and Web Services.
• Documented application level documents for production support team.
• Worked with the Quality Center test cases with the QA team to validate data load.

Environment: Informatica Power Center, SQL Server, SQL Server Management Studio, SSIS, ESP Scheduler.

Sr. ETL Informatica Developer

Confidential, Omaha, NE

Responsibilities:

• Involved in analysis, design and development for extracting data from the source systems like XML files, Flat Files, SQL Server and loading into IDS and Data Marts.
• Worked closely with the data architect, analysts, data source system experts and the users to design the interfaces and data loads to the Warehouse.
• Worked on creating technical specifications using functional specifications.
• Designed the batch processes to handle the ETL batch jobs across all the interfaces.
• Involved in enhancement, maintenance, documentation and support of ETL processes.
• Worked closely with the business users to develop the transformation logic to be used in Informatica.
• Involved in Performance Tuning of the Complex Informatica mappings and also fine-tuned the SQL queries in Informatica mappings.
• Applied Error Handling in Informatica mappings & sessions and also through validation scripts
• Created and used Shell scripts for running workflows and generated log files for the ETL process.
• Extensively used TIDAL scheduler tool for scheduling Informatica workflow and reports.
• Involved extensively in Unit testing, integration testing, system testing and UAT.
• Followed the best practices for the environment as set up by the Administrator which include but are not limited to Change control process, Documentation process, Code/Peer Review, Optimization standards.

Environment: Informatica 8.6/9.1, SQL Server 2005/2008, T-SQL Stored Procedures, SQL Server Integration Services, SQL Server Reporting Services, TIDAL Scheduling tool, Visual Studio 2005/2008, Power Point, Office, Excel Power pivot 2010

Sr. ETL Informatica Developer

Confidential, San Jose, CA

Responsibilities:

• Involved in gap analysis, SD, SI and testing phases of ETL processes.
• Worked on requirement gathering for B2B XML’s feed (Customer and Product).
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence.
• Imported XML target definitions from an XML, DTD, and XML schema files.
• Responsible for developing, support and maintenance for the ETL processes.
• Setting up jobs to schedule the loads Confidential required frequency using Power Center Workflow manager.
• Monitored the status of Workflows/Work lets/Sessions in Gantt chart and Task view mode using Workflow Monitor.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Created Unix Shell Scripts for automation of ETL process.
• Created documents for ETL interface specifications, technical design and Requirements Traceability Matrix (RTM).
• Worked on migration templates, Informatica Admin standards document and monitored production jobs.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad (Query Analyzer), PL/SQL, XML, XSD, DB Grids, MS Visio, UNIX, Windows XP/2000.

Sr. ETL Informatica Developer

Confidential, Memphis, TN

Responsibilities:

• Coordinating with the Functional team and gathering user/system requirements.
• Developing the mapping Spreadsheets, ETL Design Documents for each Mock execution.
• Developed complex mappings to load data from Source Systems (Oracle) and flat files.
• Used Informatica Power Exchange to connect to IBM Mainframe systems (JCL, Cobol Files), JMS (Java Messaging Services) to provide access data in various formats such as VSAM, IMS and IDMS.
• Employed different transformations like Normalizer, Stored Procedure, Update Strategy, Lookup, Router, Filter, Sequence Generator, Sorter, Expression transformations in Informatica mappings.
• Created reusable transformations, mapplets and worklets.
• Worked extensively on connected, unconnected and dynamic lookup transformations for better performance.
• Worked on loading data from Oracle to Netezza while maintaining the referential integrity of the dimensions in Oracle.
• Used Nexus to query Netezza DB to search 5-to-20 terabyte tables with sub second response times.
• Worked as an ETL Admin on a short term basis, Created Folders, new Connections for existing folders, new user addition/privileges requests.
• Was responsible for handling development/changes/defect fixes in 4 Project Modules (Project Setup, Alternate Projects, User defined, Project workforce PLC)
• Involved in Unit testing, System testing and capturing the test results.
• Wrote Pre-SQL and Post-SQL scripts in Informatica sessions for complex logics.

Environment: Informatica Power Center 8.6/7.1.4, Informatica Power Exchange 5.2.2, Oracle 10g/9i, PL/SQL Procedures, Netezza, TOAD, Nexus, UNIX, Autosys, Rational Clear case, MS Visio.

ETL Developer

Confidential, Auburn Hills, MI

Responsibilities:

• Coordinating with the Functional team and gathering user/system requirements.
• Developing the mapping Spreadsheets, ETL Design Documents for each Mock execution.
• Developed complex mappings to load data from Source Systems (Oracle) and flat files.
• Used Informatica Power Exchange to connect to IBM Mainframe systems (JCL, Cobol Files), JMS (Java Messaging Services) to provide access data in various formats such as VSAM, IMS and IDMS.
• Employed different transformations like Normalizer, Stored Procedure, Update Strategy, Lookup, Router, Filter, Sequence Generator, Sorter, Expression transformations in Informatica mappings.
• Created reusable transformations, mapplets and worklets.
• Worked extensively on connected, unconnected and dynamic lookup transformations for better performance.
• Worked on loading data from Oracle to Netezza while maintaining the referential integrity of the dimensions in Oracle.
• Used Nexus to query Netezza DB to search 5-to-20 terabyte tables with sub second response times.
• Worked as an ETL Admin on a short term basis, Created Folders, new Connections for existing folders, new user addition/privileges requests.
• Was responsible for handling development/changes/defect fixes in 4 Project Modules (Project Setup, Alternate Projects, User defined, Project workforce PLC)
• Involved in Unit testing, System testing and capturing the test results.
• Wrote Pre-SQL and Post-SQL scripts in Informatica sessions for complex logics.

Environment: Informatica Power Center 8.6/7.1.4, Informatica Power Exchange 5.2.2, Oracle 10g/9i, PL/SQL Procedures, Netezza, TOAD, Nexus, UNIX, Autosys, Rational Clear case, MS Visio.