PROFESSIONAL SUMMARY:

• Over 7+ years of experience in the Information Technology (IT) Industry serving as a Data /Business Analyst/ETL Developer in a Banking & Financial domain.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. Chaired and conducted JAD sessions with business and technical teams.
• Experience in Data Analysis, Data Profiling and Data Mapping. Used SQL and Data Profiler tools.
• Extensive experience in Extract, Transfer and Load process using ETL tools like Informatica, Data stage and SQL Server Integration Services for Data migration and Data Warehousing projects along with good project management skills.
• Strong experience with SQL, Normalized Database creation in relational databases like Oracle, MS - SQL Server, Access DB, DB2 UDB. Expert in writing optimized PL/SQL, SQL, triggers, and cursors in Oracle.
• Extensive experiences in Investment Banking projects, specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Sorter, Expression, Lookup, Aggregator, Update Strategy and Joiner.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica power center sessions as well as performance tuning of mappings and sessions.
• Experience in preparing project cutover plan, test plan with test cases for unit test, regression test and User Acceptance Testing (UAT).
• Excellent knowledge in Corporate Finance, Investment Banking, Credit Risk (Enterprise Risk Management), Asset Management, Wealth Management, Risk Management, Investment Products.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre-& post session operations.
• Experience in programming with SQL and PL/SQL (Stored Procedures, Functions, Cursors, and Database Triggers).
• Very good experience in Oracle database application development using Oracle 10g/9i/8i/x, SQL, PL/SQL, SQL Loader.
• Strong SQL experience in Teradata from developing the ETL with Complex tuned queries including analytical functions.
• Highly skilled in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Expert in analyzing/troubleshooting and providing technical support for Oracle/Unix applications and their interfaces.
• Vast experience of working in the area data management including data analysis, gap analysis, data mapping, data validation along with data profiling, data cleansing, data scrubbing and reference of data reports utilizing Tableau Visualizations like Dual Axis.
• Worked extensively with Dimensional Modeling and Data Migration.
• Experience in Data Transformation, Metadata, and Data dictionary, Data Loading, Modeling, Facets and Performance Tuning.
• Good exposure to Risk Management functions like Product Control, Financial Control, Market Risk, Credit Risk, and Front Office.
• Experience in DBMS/RDBMS implementation using object-oriented concept and database toolkit.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Understood and worked on Fixed Income, Equities & Trade Cycle, OTC Derivatives -- Options, Futures, Mutual Funds, Portfolio Management, Brokerage.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Business Objects.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking using Clear Quest.
• Coordinated and prioritized outstanding defects and system requests based on business requirements. Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements.
• Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.

TECHNICAL SKILLS:

Database: Teradata, DB2, Oracle, SQL Server 2012, MS Access

Data Warehouse Concept: Star Schema, Snowflake schema, OLTP, OLAP

Operating Systems: UNIX, MS Windows 2000 & NT, MS DOS

Languages: SQL, PL/SQL, T: SQL

Reporting Tools: Business Objects XI, Cognos7.x/8.x/10.x, Tableau

ETL Tools: Informatica 9.5/9.1/8.6/8.5/8.1 , Data stage

Modelling Tool: Erwin 9.5, Power designer, MS: Visio

Desktop Software: Microsoft Word, Excel, and PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. Data Analyst

Responsibilities:

• Analyze the Bank's data and business terms from a data quality and integrity perspective.
• Perform root cause analysis on smaller self-contained data analysis tasks that are related to assigned data processes.
• Writes various SQL statements for data generation for purpose of analysis.
• Work to ensure high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
• Develop and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
• Daily Data quality checks and Data profiling for accurate and better reporting and analysis.
• Involved in translating the business requirements into data requirements across different systems.
• Involved in understanding the customer needs with regards to data, documenting requirements and complex SQL statements to extract the data and packaging data for delivery to customers.
• Generated portfolio analysis and P&L reports by performing risk analysis and risk management (Credit Risk, Market Risk, Reinvestment Risk, and Inflation Risk) based on the client investment objectives.
• Wrote complex SQL and PL/SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Performed unit testing on transformation rules to ensure data moved correctly.
• Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting
• Wrote the SQL and PL/SQL queries on data staging tables and data warehouse tables to validate the data results.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Researched and fixed data issues pointed out by QA team during regression tests.
• Participates in the development of Enhancement for the current Commercial and Mortgage Securities
• Writes SQL Stored Procedures and Views and perform in-depth testing of new and existing systems.
• Manipulate and prepare data, extract data from database for business analyst using Tableau.
• Review normalized schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments.
• Exploits power of MS SQL to solve complex business problems by data analysis on a large set of data.
• Involved in the formulation and implementation of a structured credit policy and related processes to manage and monitor credit risk.
• Use Tableau for SQL queried data, and data analysis, generating reports, graphics and statistical analysis.
• Queried questions up front to determine key issues and foresee potential show-stoppers that might arise later and in-depth understanding of OTC derivatives operations.
• Develop Reports using the SQL advanced techniques like Rank, Row number etc.
• Analyze data using Tableau for automation and determine business data trends.
• Provide guidance for transitioning from Access to SQL Server.
• Transfer data objects and queries from MS Excel to SQL Server.
• Strong Data modeling skills including Star Schema and Snow-Flake models and E-R modeling, Dimensional modelling.
• Working knowledge on different data sources as Flat files, Oracle, SQL Server, RDBMS, Teradata and have knowledge in Data extraction, profiling, identifying data quality issues.
• Delivered Enterprise Data Governance, Data Analyst, Metadata, and ETL Informatica solution
• Assists ETL team to define Source to Target Mappings.
• Proven track record in troubleshooting of ETL mappings and addressing production issues like performance tuning and enhancement.
• Compile and Generate Reports in a Presentable Format to the Project Team.

Environment: Tableau, R Studio, Tableau, QlikView, PL/SQL, T-SQL, HTML, SSRS, ETL, SSIS, Java, MS Visio, MS Access, MS Project, MS Share Point, MS Access, Agile, Informatica.

Confidential, Charleston, WV

Sr. Data Analyst

Responsibilities:

• Involved in reviewing business requirements, analyzing data from data sources like excel/SQL Server for design, development and production rollover of reporting within Tableau desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in tableau.
• Create or enhance existing applications utilizing Microsoft Access and SQL Server
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Defined best practices for creating tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user needs, standardizing dashboard size, look and feel.
• Fine-tuned SQL queries for maximum efficiency and performance.
• Built dashboards for measures with forecast, trend lines and reference lines.
• Published workbooks by creating user filters so that only concerned teams can view them.
• Developed Cumulative workflow diagrams for scrum to track work items.
• Participated in daily stand-ups with clients on daily design and development effort.
• Accessed and transformed massive data sets through filtering, grouping, aggregation and statistical calculation.
• Worked on generating OTC Derivatives volumes by total trade, incoming/outgoing payment items, number of new transactions
• Interfaced with business users to verify business rules and communicated changes to ETL development team.
• Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings and profiling results
• Creating and executing SQL and PL/SQL queries to perform Data Integrity testing on an Teradata Database to validate and test data using TOAD.
• Performed Data Validation with Data profiling. Involved in System Testing and User Acceptance Testing
• Responsible for BI Data Quality. Worked on data mining and data profiling.
• Worked with data architects team to make appropriate changes to the data models.
• Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
• Experience in designing complex Drill-Down & Drill-Through Reports using Business Objects. Experience in creating UNIX shell scripts for file transfer and file manipulation.
• Writing the SQL queries in Oracle SQL Developer and managing the database and assisted in making Data
• Strong understanding of Tableau features including calculated fields, parameters, table calculations, joins, data blending and dashboard actions.
• Used statistical techniques to describe data using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
• Created SQL queries for Report Mapping, Report Layout and Data Flow Diagrams
• Created a library of presentation templates by topic for future use.
• Ability to correspond with clients, responding to their questions and concerns with detailed information, while adhering to company's policies and procedures.
• Adapt to a changing environment and circumstances and Identity potential show stoppers and escalates to the senior management.

Environment: MS Office Suite, Windows 7, MS SQL Server, MS Project, UML, Erwin, Business Objects, Informatica, HTML, XML, Oracle, MS Visio, MS Access, SAS, DB2, Tableau.

Confidential, St Cloud, MN

Sr. Data Analyst / Business Analyst

Responsibilities:

• Monitored performance against project baseline and maintained project documentation in a central repository.
• Arranged for information available to project stakeholders.
• Involved in requirement gathering of the Data Warehouse, ETL testing effort, analyzing business requirements, Data Model Design, Data flow from various Sources to Target.
• Prepared ETL and Reporting test cases for requirements.
• Involved in ETL data verification after successful loading of data in the database.
• Developed Stored Procedures and Functions in PL/SQL for Business Objects Intelligence Application. Performed data mapping, data analysis and process analysis for Oracle tables and views.
• Involved in data setup for all the test cases used for ETL testing
• Prepared ETL and Reporting test cases for requirements
• Written SQL queries for testing ETL and Reports
• Worked with internal and external parties to organize the various components needed to initiate, run and conclude major projects
• Supported business process re-engineering by analyzing “As Is” and “To Be” systems.
• Supported project teams with vendor communication and internal support group coordination
• Set up and managed support functions covering planning, tracking, reporting, quality management and internal communication.
• Worked with specialists in the field of development, users and customers, produce goal and target specifications, solved any conflicts that arose and minimized potential risks
• Established standards, tools and procedures for use on the project, including Issue, Risk, Change and Information Management
• Ensured working conditions that permit project personnel to implement the development work in the most cost-effective manner
• Used Excel extensively to manipulate data using formulas, pivot table, and macros.
• Facilitated compiling weekly vendor project delivery status reports and monthly scorecards reviewed project activities for compliance with procedures and standards Managed the support and provision of project tools and equipment
• Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community.
• Prepared the Business Workflow using MS-Visio with input, output, and Pre-and Post-condition.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation and Aggregator Transformation.
• Created Mapplets, reusable transformations and used them in different mappings.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Performed performance tuning of source level, target level, mappings and session.
• Responsible for creating and modifying the PL/SQL procedures, functions according to the business requirement.
• Used Informatica debugger in finding out bugs in existing mappings by analyzing data flow and evaluating transformations and done unit testing for the individual developed mappings.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.
• Created sessions and Workflows to schedule the loads at required frequency using Power Center Workflow Manager.
• Analyzed the load dependencies and scheduled the workflows accordingly to avoid the loading conflict issues.
• Analyzed Session Log files in case the session fails to resolve errors in mapping or session configurations.

Environment: Oracle, Erwin, SQL server, Informatica power center, BO, Hyperion, UNIX and Shell Scripting, MS Office Suite, MS Access, HTML, XML, MS Visio.

Confidential, Vineland, NJ

Sr. Data Analyst/ETL Developer

Responsibilities:

• Facilitated collection of functional requirements from system users and preparation of business requirement documents using Rational Requisite Pro that provided appropriate scope of work for technical team to develop prototype and overall system.
• Played a pivotal role in JAD sessions helping to develop detailed solutions and documented the Functional and System specification requirements.
• Worked as an Interface between the end users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Followed a structured approach to organize requirements into logical groupings of essential Functional Requirements, Non-Functional Requirements, Interface Requirements and Report Requirements and insures that critical requirements are not missed.
• Conducted GAP analysis to regulate the gaps in the requirements and conveyed to various modules of the project.
• Prepared Workflow diagrams to analyze AS IS and TO BE scenarios, designed new process flows using MS Visio and documented the business process and various business scenarios.
• Performed quality audits of the requirements and distributed to all stakeholders. Conducted user interviews and JAD Sessions as a part of the requirements elicitation.
• Gathered all transaction fields and data from all these different source systems.
• Worked on data profile and data definition after gathered all fields from sources.
• Worked on Source fields to Target fields mapping and put the transformation rules for each field.
• Experience with data mining and led the development of new and innovative systems, processes and mining algorithms to increase and improve mining results.
• Created Source Mapping Excel Sheet for our group where all source and target fields are mapped and all business rules are applied to map all fields.
• Created SQL complex queries and SQL performance tuning.
• Team Building, creating production and analysis report, documentation for various data processes.
• Extensively involved in ETL code using Informatica tool to meet requirements for extract, cleansing, transformation and loading of data from source to target data structures.
• Created ETL Mappings, Sessions and Workflows using various transformations like Update Transformation, Lookups, Filters, Routers and XML etc.
• Worked with ETL team responsible for Designing, modeling, and creating ETL procedures to load bulk data into the highly de-normalized database.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Good experienced in communicating with different source persons, scheduling meeting with Source Business Person as well as Source Technical Persons.
• Created final source approval and Gap/Recommendation Technical Document for each source systems.
• Designed some Source system related diagrams using Microsoft Visio and prepared presentation on that.
• Prepared documented reports for the usage of existing systems and new systems.

Environment: MS Office Suite (Word, Excel, Access, PowerPoint, and Outlook), MS-Project, Visio, MS-Excel, MS Office Suite. Informatica, Oracle, DB2, SQL Server, MS Access, HTML, XML, PL/SQL.