SUMMARY

• Around 11+ years of IT experience in analysis, design, development, implementation and troubleshooting in Business Intelligence - Data warehousing.
• As a Technical Business Analyst, participated in discussions with business stakeholders to understand the business requirements and translating them effectively into technical requirements.
• As a scrum master, leading a scrum team of 10+ members from different time zones
• As a QA Lead, writing functional/regression test scripts to test both UI functionality and data validation in databases.
• As a Data Analyst, collection and organization of data,finding correlations between that analyzed data to spot problems and initiate preventative measures or problem solve creatively.
• As a ETL- Informatica Lead, have extensive experience in Extraction, Transformation, Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.1/8.6/7.1x (Repository Manager, Designer, Workflow manager and Workflow Monitor).
• Worked on various databases - Oracle 8i/9i/10g/11g, DB2 V9, Netezza, SQL Server, Sybase, Greenplum
• Experienced in data extraction and integration from heterogeneous sources using Informatica Power center from various data sources like DB2, Netezza, Oracle and Flat Files into the data warehouse.
• Experienced in writing Oracle Stored Procedures, Functions and Cursors.
• Expertise with different types of data load strategies such as Historical Load, Truncate and Load, Dimensional Load.
• Experience in working on Near Real Time Data processing.
• Experienced in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
• Experienced in UNIX Shell Scripting.
• Experience in Data Masking and Data Quality.
• Involved in Performance tuning of Informatica mappings, Oracle SQLs and Netezza SQLs.
• Strong knowledge in OLAP Systems, Kimball/Inmon methodology, Dimensional modeling using Star schema and Snowflake schema.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Agile Tools: JIRA

ETL Tools: Informatica Power center 9.1/8.6/7.1.3

Databases: Oracle 8i/9i/10g/11g, DB2 V9, Netezza, Sybase, Greenplum, SQL Server

Database Utilities: Toad for Oracle 11.6, Toad for Data Analysts 3 ( Netezza/Oracle), Toad for DB2, SQL Plus, Aginity Netezza Workbench, Toad for SQL Server, pgAdmin for Greenplum

Languages: C, Core JAVA, Unix Shell Scripting, Oracle PL/SQL, DB2 Procedural language

Version Control Tools: VSS

Scheduling Tools: Autosys

Operating Systems: Windows 9X/2000/XP/2K8/Vista/7/ NT, MS-DOS, Unix (AIX/Solaris), Mac( Intel/PPC)

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Analyze/Interpret data requirements and perform current/target/gap/impact analyses.
• Requirement gathering for various downstream data needs across several applications and bring all the participating teams into consensus.
• Design the data mapping from system of records to the downstream consumption layers.
• Collaborates with other technology and development staff to provide solution alternatives that ensure key deliverables are achieved.
• Prepare documents such as expected benefits, gap analysis, use cases, models, current and proposed process, workflows, data flows, implementation plans and end user guides in accordance with standards and methodologies.
• Documents the technical requirements, design, and testing information to ensure quality output that meets states and implied business needs.
• Participates in functional and technical troubleshooting and problem solving in collaboration with technical and implied business needs.
• Follow Technical Processes, Designs, and solutions are recommended.
• Identifies and works on resolving dependencies and interdependencies between different application and products.
• Timely delivery of the analysis, reports and presentations to support business reviews.
• Plans Testing tasks and creates test plan and test cases following the methodology defined and using prescribed testing tools.
• Performs Data Analysis using SQL and monitoring to ensure Data Quality.

Confidential

Technical Business Analyst/QA Lead

Responsibilities:

• Research/Analysis and Interpret Data Requirements for online transactional applications which needs to be digitally measured.
• Participate in discussions with business stakeholders to iron out various interests of the business to measure transactions digitally and convert them to requirements.
• Discussion with Application Development Team on existing transaction to gauge upcoming changes that would impact Confidential and also, build required Data Feed.
• Identify Data Anomalies and communicating them to Data stewards
• Analyzing Web Analytics data from Splunk/Tealeaf sessions/Internet Network and comparing customer transaction execution across various channels.
• Documents & Draft all technical specification documentation
• Participate in sessions with Ensighten Team to implement tagging so that every step of the transaction can be identified uniquely and measured digitally.
• Understand system dependencies and recommend solutions/alternatives that ensure key deliverables are achieved by working with all the stakeholders.
• Participated in functional and technical troubleshooting and problem solving in collaboration with technical and business teams.
• Validated accuracy of measures by comparing web utilization data against source transactional data.
• Daily data analysis and monitoring on the dashboard in order to ensure data quality.
• Performed QA on the dashboard upon release, report & track the issues and ensured the issues are resolved.

Confidential

Technical Business Analyst/Scrum Master/QA Lead/ETL Lead

Responsibilities:

• Participate in discussions with business stakeholders to iron out ambiguous ideas to business requirements.
• Lead deep dive discussions with developers and business stakeholders to translate business requirements to technical specifications.
• Documents & Draft all technical specification documentation
• Set and Manage business stakeholder's expectations based on historical sprint velocity measured.
• Manage a global scrum team of 10+ members from India, Delaware, New York, Hong Kong, Singapore.
• Maintain a backlog and lead discussions to determine sprint scope
• Measure velocity, burn up/down for management reporting that was used by the Chief Risk Officer of Global Wealth Management.
• Define 'Definition of Doneness' to set expectations to all members
• Lead Retrospective meetings to ensure continuous improvement model of agile process.
• Translate technical specifications to executable test cases
• Documentbusiness use cases per each requirement and to determine what test cases need to be covered.
• Document all functional test cases including UI functionality and data validation

Confidential

Technical Business Analyst/ETL- Informatica Tech lead

Responsibilities:

• Participate insessions with end users to document business requirements and convert them to technical specification and Lead an offshore team of size 8.
• Identify, prioritize, resolve, document, and communicate technical and operational issues with end users and technology partners.
• Interaction with business on day to day basis providing required support, prioritize appropriately, and ensure timely resolutions.
• Maintain high level of client satisfaction through successful and timely resolution of technical and operational problems.
• Data Modeling for Service Request Model (GSS).
• ETL design for Near Real Time and Daily Processing of data.
• Design of scheduling the ETL code through Autosys and building a dependency on Source system.
• Development and Testing of ETL code to build GSS Data Mart tables.
• Testing the entire FAST data in higher environments and push the code to Production.
• Data Masking to make PROD data available in lower environments.
• Responsible for training other development teams, QA teams and Support teams involved in the project and provided solutions for various performance bottle necks in Informatica Mappings.

Environnent: Informatica 9.1, Netezza, Unix, Autosys ( iXp), Toad, Aginity