PROFILE SUMMARY

• 6 years of Database Analyst experience on various Domains like Banking, Financial and Telecommunications.
• Solutions - oriented IT professional with solid background developing enhanced business tools and processes. Technical analyst driving the full project life cycle based on industry best practices. Talented programmer with web application creativity and front end functionality and improved information/data security. Effective workflow manager, able to work independently with minimal direction and provide guidance in team setting.
• Data Analyst with diverse experience in all stages of the Software Development Life Cycle with emphasis on Business Analysis, Data Analysis, Gap Analysis and Quality Assurance.
• Experience on creating Source to Target mapping documents, gathering business requirements from business/user, creating Process Flows and Data Flow Diagram DFD . Working directly with ETL team for data extraction, Data Quality DQ team for validation.
• Experience on gathering business requirements from business/user, creating Process Flows and Data Flow Diagram DFD .
• Worked with MDM and Ref Data as per the business need.
• Worked in different relational databases environments such as Oracle, SQL Server, DB2 and MS Access.
• Worked with heterogeneous relational databases such as Teradata Oracle, MS Access and SQL Server
• Experience in working third party tools like WinSQL and TOAD.
• Worked with Data Management team for exceptional data handling.
• Hands on experience in testing ETL mappings and Business Object BO reports.
• Experience in complete Unified Modeling Language UML, Software Development Life Cycle SDLC, Software Testing Life Cycle STLC and Bug Life Cycle BLC .
• Proficient in all cycles of test life cycle from test planning to defect tracking and managing defect lifecycle.
• Experience in defining scope and objectives, researching and root-cause analysis analyzing business and user requirements for complex projects.
• Experience in creating Business Required Document BRD, Functional Required Documents FRD, and Functional Specification Document FSD .
• Experience in defining scope and objectives, researching and root-cause analysis analyzing business and user requirements for complex projects. Experience producing detailed functional or operational requirement documentation, monitor project progress, identify potential road-blocks and keep projects on track. Experience working extensively in a Data Warehousing environment.
• Involved in preparation of Test data to test the functionality of ETL Sources Mappings and Targets.
• Interacting regularly with the development team, creative services, database designer, system administrator and the higher management to meet the deadlines of Project milestones.
• Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.

TECHNICAL SKILLS

Data Modeling

Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Conceptual, Logical Data Physical Modeling, Erwin r7.2/3/4, Sybase Power Designer.

Databases

Oracle 11g, 10i 9i/8i, SQL Server 2008/20052000, DB2, TeraData 12, MS Access 2007.

BI

Business objects

ETL

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

Tools: WinSQL, TOAD, Autosys, Teradata SQL Assistant, ClearQuest, ALM

Environment: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3,Sun Solaris7, WinNT4.0

AREAS OF EXPERTISE

Data Management, Database marketing, Data analysis, Data warehousing systems, Relational database, SQL, SAS, MS Office products

PROFESSIONAL EXPERIENCE

Confidenital

Data Analyst l services firm and one of the largest banking institutions in the United States, with operations in more than 60 countries worldwide. Confidential Co. is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management and private equity.

Responsibilities:

• Requirement gathering from business users to prepare an Interface Specification Document to be provided to various LOBs for sourcing data both transactional data and reference data .
• Involved in gathering requirements from the Business Users in creating an effective data model to capture all the required data attributes.
• Data Modeling for different domains in staging layer.
• Involved in performing a gap analysis on the existing data model of the staging layer versus the requirement on Data Management Portal.
• Providing pseudo code to ETL development team for capturing exceptions as a part of DQ process.
• Preparing S-T mapping document incorporating different business transforming logic for implementation of the ETL process.
• Involved in exception handling process by create work flow to escalade it to the respective LOBs.
• Run a BO report to validate the process developed in DM Portal for report generation.
• Worked closely with the Project Manager in creating the process swim lane.
• Involved in a periodic reconciliation of data between the various source and the end target system and create a BO report on the reconciliation breaks to be displayed in the DM Portal.
• Provide SQL queries to extract data from the Legacy System on alerted accounts and customers information to feed into the Portfolio Analyzer system.
• Analyzing feed metrics data as a result of the ETL process to come up with the efficient SLA time to provide to the Operation team.
• Creating a Monthly Release Notice to communicate and aware various business partners on upcoming releases and implementations.
• Involved in creating a detailed user manual on the DM portal applications to be provided to the users.
• Data profiling using Informatica Analyst tool, generate score cards.
• Involved in writing use cases for UAT testing and writing validation scripts using SQL.
• Creating Data Model for Feed Management.
• Worked on creating a Data Model for Compliance Regulatory Library and helped implementing the SDLC process.
• Brain storming on possible BLT exceptions that can arise as a part of the ETL implementation.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Worked on automation process to maintain Reference Data from various systems to refresh the data periodically.
• Environment: Oracle 10g, SQL, TOAD, MS Access, ALM, UNIX, Windows, Erwin, Abinitio, Informatica Analyst, Business Objects XI R3.1, Share Point, MS Excel, MS Visio SharePoint Portal, SQL server 2008, PL/SQL

Confidenital

Data Analyst

Confidential is the largest data warehouse developed and maintaining by Verizon wireless. As the name implies it contains all the metrics of various services that are offered by Verizon Wireless to the customers throughout all regions in U.S.A. These metric provides the useful information to the business people for analyzing the market trend and providing various new facilities to the customer by taking effective decisions. It contains the data of various customers who are using various services. The data for the warehouse is coming from various source systems and it got populated into warehouse by using internal staging system, whenever necessary. The warehouse consists of data from granular level to aggregate level which is used for Cube creation for generating reports.

Responsibilities:

• Worked with business requirements analysts/subject matter experts to identify and understand requirements.
• Defined key facts and dimensions necessary to support the business requirements along with Data Modeler.
• Created draft data models for understanding and to help Data Modeler.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Source to target mapping from the ODS Legacy System to new EDW, new billing system to the new EDW and from the legacy EDW to the new EDW system.
• Create code conversion master data table to implement the code change during the ETL process.
• Worked closely with ETL team to provide pseudo code for the complex transformation logic, answer questions that ETL team has regarding the mapping document regarding the relationships between different entities.
• Brainstorming to create a robust solution to handle exception data as a result of the DQ validation.
• Create weekly report for all the exception data using BO to provide it to the source LOBs for remediation and tracking the progress.
• Capture different kinds of DQ validation rules to ensure that the EDW gets the cleansed data for report generation.
• Perform Gap Analysis of the staging data model against the Business requirement and resolve an existing gap through a change management process.
• Manipulating, cleansing processing data using Excel, Access and SQL.
• Performed Data Validations using SQL developer.
• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models of new the EDW.
• Analyzed the source data coming from various data sources like Mainframe Oracle.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements.
• Tested the data using the Logs generated after loading the data in to EDW Data warehouse.
• Prepared Traceability Matrix with requirements versus test cases.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Worked extensively on the T-SQL environment to run out the queries and explore the Databases.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling..
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis DDA, Data Quality Analysis DQA and Data Profiling on source data.
• Environment Informatica Power Center 9.1, Oracle 11g, SQL Server 2008, SSIS 2008, PL/SQL, Erwin 4, TOAD, MS Excel, MS Access.

Confidenital

Data Analyst

Confidential is the largest data warehouse developed and maintaining by Sprint. As the name implies it contains all the metrics of various services that are offered by Sprint to the customers throughout U.S.A. These metric provides the useful information to the business people for analyzing the market trend and providing various new facilities to the customer by taking effective decisions. It contains the data of various customers who are using various services. The data for the warehouse is coming from various source systems and it got populated into warehouse by using internal staging system, whenever necessary. The warehouse consists of data from granular level to aggregate level which is used for Cube creation for generating reports.

Responsibilities:

• Conducted Interviews, brainstorming and Question and Answer sessions to identify requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Facilitated JAD Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design.
• Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non Functional Requirements.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using Visio.
• Created and maintained Data Dictionary and pursued to reach consensus.
• Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.
• Provided primary liaison between business/operations/vendors and development
• Created data models and data flow diagrams for the to-be process.
• Researched upstream data sources and ensured its owners attested all source data sources.
• Created report specifications containing mapping to source data sources.
• Developed business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Created and executed SQL queries using Rapid SQL and MS Access and scripts to validate data movement and generate expected results for UAT.
• Conducted UAT to verify whether all the Requirements were catered to by the application.
• Used Rational Test Manager for Test Case Management and Rational ClearQuest for defect tracking and resolution.
• Worked with the developers on resolving the reported bugs and various technical issues.
• Involved in preparing a simple and detailed User manual for the application, for an intended novice user.
• Environment: Oracle 10g, SQL, Rapid SQL, OLTP, TOAD, MS Access, MVS, Test Manager, Requisite Pro, Clear Quest, UNIX and Windows

Confidenital

Data analyst

Confidenital is a full-service commercial bank, providing a broad mix of financial services to businesses and individuals, also offers investment and financial management, trust services and private banking.

Responsibilities:

• Involved in requirement gatherings with Business team.
• Involved in discussions to gather source information for different source system.
• Created Source to Target Mapping documents, documented business and transformation rules and participated in working sessions and ensured full business participation throughout the process.
• Created DFD Data Functional Design artifacts that incorporated the process flow visios, S-T Mapping document and all the specifications for proper ETL implementation.
• Involved in creating the test strategy.
• Prepared Test plan, test case according to the Source to target mapping document
• Tested the FSDs and ETL mapping which were developed to load from different source systems in the Teradata Staging /Target areas.
• Validated the data between the Source to Staging and Staging to Target using the Source to target mapping document as reference.
• Performing own Data profiling on source to compare with list of valid values while mapping source to target and writing exception cases if necessary.
• Helped the Infrastructure team in loading the XML's generated by the Informatica into the ALGO Limit management system.
• Tested the data using the Logs generated after loading the data in to LMT.
• Worked on GAP analysis for missing requirements.
• Involved in Functional Testing of the LMT project.
• Tested the BO reports generate by the BO team using ACR ALGO as a source.
• Prepared Traceability Matrix with requirements versus test cases.
• Conducted internal and final DFD reviews with the ETL team EIS, Data Quality and Metadata Management team, data architects, and business and application data stewards.
• Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre this involved Bug life cycle.
• Environment: Erwin, Teradata, Oracle, Abinitio, Abinitio EMEM Data Profiler, Informatica Power Center 8.6, Business Objects XI R3.1, Teradata SQL Assistant, Oracle, Toad, Windows XP, Share Point, Altova XML SPY, XML, MS Access, MS Excel, SharePoint Portal.

Confidenital

Business Analyst

Provident Bancshares Corporation operates as the bank holding company for Provident Bank that provides financial services to individuals, small businesses, and middle market businesses in the United States. Enhanced and modified the productivity of the credit card production core application to reduce the cost of application maintenance and improve productivity. The whole application process has been updated in order to meet the business requirements of the client. Re-designed the core credit card production and billing application, developed a process-centric approach to application maintenance, and provided enhanced documentation of the current system.

Responsibilities:

• Understanding and analyzing the requirements of Clients.
• Prepared interview questionnaires for the users and gathered requirements.
• Performed Functional and GUI testing to ensure that the user acceptance criteria are met.
• Examined, analyzed and modeled Test plans Use Case Model cases Test procedures based on RUP methodology.
• Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams Activity diagrams, Sequence diagrams, Collaboration diagrams in VISIO
• Actively participated in performing testing for thoroughly understanding of the engineering process
• Worked with SQL and Data Warehousing for arrangement of customer data.
• Created Use Case scenarios and work flow diagrams after requirements gathering.
• Coordinated work plan between project manager and client with MS Project.
• Participated in Business Modeling by understanding the needs of the business, and also documenting Business use cases initial as well as System Use cases
• Coordinated with other programmers to solve their problems.
• Participated in Walk Through and Defect report meetings periodically.
• Tested the project according to business rules and specifications.
• Documented Test cases, Test results and Test procedures.
• Environment: Windows 2000, MS Office, MS Visio, MS Project, Oracle, Visual Basic, Solaris 8, UNIX, SQL Server and ER Win.