SUMMARY:

• 7 years of Business System Analyst experience in various Financial, Insurance and Transactional Domains.
• In depth understanding of SDLC methodologies like Waterfall, Agile (SCRUM) and RUP (rational unified process).
• Experience on gathering business requirements from business/user, creating Process Flows and Data Flow Diagram ( Confidential ).
• Experience in coordinating with business and IT across all phases of software development life cycle (SDLC). Hands - on experience on full life cycle of the project.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data. Also, extensive in creating Source to Target Data Mapping documents using excel spreadsheet to capture all the business requirements, working closely with SMEs and Data Architect to answer outstanding Business related questions.
• Experience in Data Profiling, Data Manipulating and Data Parsing using complex SQL queries against various Database Environments, Data Quality (DQ) validation, and Exceptional data handling.
• Experience in different relational databases environments such as Oracle, SQL Server, DB2, Teradata, IBM Netezza, and MS Access.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, Slow Changing Dimension (SCD) Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.

TECHNICAL SKILLS:

Data Modeling: Dimensional Data Modeling, FACT and Dimensions Tables, ERD, Logical/Physical Data Modeling using Erwin r7.2, Workbench, Toad Data Modeler 5.1

RDBMS: Teradata, SQL Server 2008/2010, Oracle 11g, DB2, MS Access 2010

BI: Business Objects

ETL: Abinitio, Informatica Power Center 8.X/7.x/6.2

Tools: TOAD, AQT, ClearQuest, ALM, Appirio CMC, SharePoint, Quality Center, JIRA, Teradata SQL Assistant

Reporting Tools: SSRS 2005/2008, Tableau 9.1 & 9.2, Business Objects

Operating System: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Database/Reporting Analyst

Responsibilities:

• Digital Wallet Dashboard
• Work directly with Business Partners (Product Management Team) in gathering Ad-hoc Reporting requirements for Digital Payments.
• Work closely with Data Integration team/Data Architect to move the data from BMG to BI Reporting Data Mart.
• Responsible for developing analytical approaches that meet requirements. This involves translating requests into SQL queries, analyzing data and transforming results into actionable information.
• Responsible for designing and developing SQL queries to conduct research requests around account/customer behavior or performance.
• Responsible for creating Monthly Digital Wallet Dashboard using Tableau and present it to the higher management team.
• Rebates Redeemer Profile
• Acquire the dataset from BMG as per requirement to create redeemer profiles showing redeemer segments at a product level. Create product level rewards dashboard in Tableau to display redemption type, top redemptions, rewards earned & burned, channel & profile.
• Online Card Replacement
• Define Status code and Event logic to capture the event (clicks) on mobile, tablet, and computer while replacing card online. All counts are at click event level, literally tracking an action that took place on desktop, mobile or tablet.

Environment: SQL Server Mgmt. Studio 2008 R2, Teradata SQL Assistance 15.0 & 15.1, Teradata OleLoad 15.1, JIRA, Tableau Desktop 9.0 & 9.2, Visio 2013

Confidential, San Francisco, CA

Business System Consultant

Responsibilities:

• Conducted workshop and user interview to capture the ad hoc reporting requirement from the business, review with the business and present it to the IT team for getting required signoffs. Performed gaps analysis in an existing EDW for the data elements presenting in the loan originating system to close out the gaps that are required for reporting requirement.
• Assisted data modeling team to perform the data modeling task to capture all the data elements.
• Worked with Business Stakeholders to define the data history requirements to source to data from the loan originating system, conducted meeting with development team to define the MSC rules to be implemented during the ETL process.

Environment: Teradata v14, Netezza, Teradata SQL Assistant, Toad, Microsoft Office Suites, HP Quality Center

Confidential, San Francisco, CA

Sr. Data Analyst

Responsibilities:

• Analyzed the source and target system data to find root cause of the data discrepancies between two systems.
• Involved in writing a complex queries to pull the data from source system incorporating complex business logic used for data transformation, code translation etc. from source to target system.
• Conducted a manual as well as automatic reconciliation of the data between the source system and the target system using different techniques.
• Involved in remediating the exception data that are dropped during the ETL process.
• Assist project manager in preparing the excel dashboards and reports on reconciliation process

Environment: SQL Server Management Studio 2012, JIRA, Windows 2008, Share Point, MS Excel, MS Visio.

Confidential, Dallas, TX

Business Data Analyst

Responsibilities:

• Involved in creating a data model with the data architects for the staging layer which sources data from multiple source system LOBs.
• Conduct JAD session with the technical team and the business operation team and drive the meeting to discuss about the road blocks and brainstorming remediation plans.
• Involved with the reporting team to build universe in Business Object for ad hoc reporting purpose.

Environment: Oracle 11g, TOAD, ALM, Erwin, Business Objects XI R3.1, Share Point, MS Visio SharePoint Portal, JIRA

Confidential, Bloomington, IL

Business System Analyst

Responsibilities:

• Direct involvement with the Business Technology team to define the Migration Selection Criteria (MSC) and helped development team in coding the MSC logic for data migration.
• Involved in creating a S2T mapping document from the legacy source system to the target system with various transformation logics along with Pseudo codes and examples for tougher business transformation logics to help development team.
• Worked as a first point of contact for issue triaging which emerges as a result of QS testing on the ETL mapping, worked with various developers to analyze the root cause of the issues and remediate it.
• Involved in preparing the code translation mapping from legacy system to target system.

Environment: Agile, Oracle 10g, AQT, TOAD, JIRA, Share point, Windows XP, ALM, MS Visio Workbench, Salesforce.

Confidential, Seattle, WA

Data Analyst/Data Modeler

Responsibilities:

• Suggested and reviewed Materialized views to store aggregate values.
• Co-ordinated with development and QA teams for handling of defects with respect to data quality and business logics. Also, provided support during parallel and reverse parallel runs before moving the code into the prod environment.
• Reviewed all artifacts created with respect to Logical and Physical data models including tables, procedures, indices, synonyms, views, functions, triggers, sequence, constraints.

Environment: Quality Center 10.0, Agile, Java, PL/SQL, TOAD for Oracle 9.1, Pivot Tables, UAT.

Confidential, McLean, VA

Data Analyst

Responsibilities:

• Analyze various source system data to create a S2T mapping document to provide to the ETL development team. Monitor deterioration in data quality of incoming feeds through dashboard and by analyzing feed processing results. Conduct root cause analysis of the errors found in feed processing and report them. Review implementation techniques suggested by development teams for potential scalability, performance, maintenance or data quality problems

Environment: Oracle, SQL, UML, MS-Visio, MS Project, Informatica Power Center.