SUMMARY:

• Over 7+ years of IT experience in the field of Business/Data analysis, ETL Development, Data Modeling, and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion ,Data Quality, Data Integration and Metadata Management Services and Configuration Management
• Over 2+ years of experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Embarcadero.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, Cognos and OBIEE
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Sun Solaris, AIX, HP
• Experience in Working with different industries like Financial, Media, Retail and Banking.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side
• Experience in creating functional/technical specifications, data design documents based on the requirements
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

Technical Skills:
Business Modeling: Microsoft Visio
Requirements Management: Requisite Pro, Microsoft Office (Word & Excel)
Front End Tools: Microsoft Project, Microsoft Office
Databases: SQL Server 2008, Teradata V2R5.x/6.x/7.x/12.x, Oracle Toad 10, Oracle SQl Developer 2.1.1, MS Access
Document management: Visual Source Safe 6.0, Share point, Ultra Edit
Defect management tool: HP Quality center 10.0
Methodologies: Data Modeling – Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, CMMI Compliance, Waterfall, Agile, Iterative
BI Tools: Cognos 8, MicroStrategy, Business Objects, Microsoft SQL Server Reporting Services, Tableau, WebFocus
ETL Tool: Informatica, Microsoft SQL Server Integrated Services
Data modeling: Microsoft SQL Server Analysis Services

Education Details:

PROFESSIONAL EXPERIENCE

Description:
Stucky Application software is being used by the Structured Finance Group of Fifth-Third Bank, in both Chicago and Cincinnati. Stucky’s Application is to track Commercial collateral on Asset Based Lending loans, monitor their Borrowing Based of Aging, Receivables and Inventory.William Stucky & Associates provided 2 software applications to the bank; Stuckynet & Stucky NTABL. Both systems have been used by the bank for over 5 years. They are used for Asset Based Lending - for structured finance deals. This will ensure that the bank does not loan more money than what the customer can support. In this particular project we have added new fields to the existing screens and have generated several new reports.
As a Sr.Data Analyst, I was involved in documenting the business process by identifying data required in determining the Asset Based Lending loans that are eligible for financing and securitization, from multiple sources and the method of obtaining and storing data.

Responsibilities:

• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Interacted with teams in AFS, ACBS and infolease to extract the information for the reports.
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse
• Worked extensively with the ERwin Model Mart for version control
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provide 24 x 7 problem management support to the development team.
• Document various Data Quality mapping document.
• Perform small enhancements (data cleansing/data quality).
• Performed data analysis on the existing data warehouse’s of AFS, ACBS and infolease.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Communicated with the third party vendor to do the programming.
• Upgraded the present application by adding new functionalities and adding new reports.
• Wrote regression test cases, did smoke testing with users.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment:
MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQLServer, Erwin, Business Objects, MS Outlook

Confidential,Texas, Aug ’2010–Apr’2011
Sr. Data Analyst

The Project is to build an Impact Data Mart (IDM) from the existing Analytic Data Warehouse (ADW) to Global B2B Buyer Hosted Catalogue (BHC) data with supporting Buyer and Catalogue information.
Responsibilities:

• Met with Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• ConductedJAD sessionsto gather requirements, performedUse Caseandwork flow analysis, outlined business rules, and developed domain object models
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database
• Created a conceptual design based on the interaction with the functional and technical team.
• Analyzed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system
• Analyzed, created and formatted the Reports as per Business Requirements.
• Analyzed and created various adhoc Reports for users based on User Requirements.
• Created both list and drill down reports identifying the data hierarchy
• Performed report validation writing SQL queries using TOAD on an Oracle database.
• Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements
• Analysis of the data identifying source of data and data mappings of BHC.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interact with the SME’s to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Createdand maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows).
• Worked in collaboration with various areas of the organization, identified additional stakeholder Requirements, and Documented requirements in a Software Requirements Specification document.
• Created use cases, activity diagrams and state diagrams using Rational Rose.

Environment: Oracle 10g, Windows, Microstrategy, MS Visio, MS Project, Informatica

Confidential, Washington DC, Sr.Data Analyst Jan‘2009-July ‘2010
STARSS (SIRIUS XM Tool for Acquisition Retention sales and services)

Worked as a Sr.Data analyst, to create a sales and service data mart required for Business Intelligence and reporting purposes. The Existing STARSS system which allows the agents to enter, modify new sales/service data is used as one of major source systems.

Responsibilities:

• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for sales and service data.
• Define the list codes and code conversions between the source systems and the data mart.
• Worked with internal architects and, assisting in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Responsible for defining the key identifiers for each mapping/interface
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Involved in configuration management in the process of creating and maintaining an up-to-date record of all the components of the development efforts in coding and designing schemas
• Developed the financing reporting requirements by analyzing the existing business objects reports
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates
• Document data quality and traceability documents for each source interface
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Evaluated data profiling, cleansing, integration and extraction tools(e.g. Informatica)
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects

Confidential,IL USA Oct 2008 – Jan 2009
Role: Business Analyst and Data Analyst

Responsibilities:

• Liaised with business and functional owners during project scoping and planning to identify the high-level requirements for the project.
• Documented the functional requirements and created the various other process flow diagrams and artifacts.
• Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement.
• Defined specifications like use case documentation, activity diagram, and business process flow using Microsoft Visio.
• Participated in Joint Application Development (JAD) sessions for requirements gathering.
• Created Required Data Elements (RDE) to define the business rules for source to target mapping.
• Created Requirements Traceability Matrix (RTM) and tracked solution validation to requirements matrix.
• Performed gap analysis of business rules, business and system process flows, user administration, and requirements. Worked with the functional owners to bridge the gaps.
• Lead calls with the SMEs and business to finalize complex Business logics and Transformation rules.
• Coordinated and managed the execution of User Acceptance Testing.
• Involved in creation of OALP, Data analysis ,Data processing - Extracting data from different sources, Cleansing and transferring data, Distribution of data, Mappings Creation, Debugging, Optimization, Slowly changing dimensions, Comparison of mappings, Designing the data mart.
• Involved in the data profiling activities for the column assessment and natural key study.
• Performed complex data analysis in support of ad-hoc, standard, and project related requests.
• Identified and resolved data related issues.
• Ensured Quality standards to meet the Data Quality SLAs.
• Performed Data Mining to analyze the patterns of the data sets.
• Provided support to the development and testing teams during the lifecycle of the project.
• Responsible for framework modeling, report writing (relational and multidimensional) and creating dashboard components.
• Analyzed emerging business trends, production patterns and forecasting demand using BI Reports
• Involved in updating the existing Universe and Model when the reports require changes.

Twin City Fan Companies, Chennai, India Jun 2006 – Sep 2007
Role: Business Analyst

Responsibilities:

• Create functional requirements documentation and data flow diagrams to assist in the analysis of a process.
• Scheduled, Facilitated and managed meeting sessions with business team members from various business areas.
• Formulate policies and procedures necessary for data management, processing and quality assessment functions Ensured system deliverables meet business requirements by participating in identifying, designing and testing solutions.
• Performed Risk Analysis of the requirements to identify the project critical success factors and prioritize functional requirement.
• Ensured requirements integrity by managing changes to requirements.
• Created Requirements Traceability Matrix (RTM) and tracked solution validation to requirements matrix.
• Created Required Data Elements (RDE) to define data mapping rules.
• Involved in importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
• Involve in the data profiling activities for the column assessment, data inconsistency and natural key study
• Collaborated with business leaders, IT groups and vendors to ensure issues communicated clearly and accurately.
• Determine the data quality standards for the organization and ensure adherence of the processes data to these standards
• Performed Data Mining to analyze the patterns of the data sets.
• Provided consultation as required through project life cycle.
• Data analysis on the BI side includes customer profitability, sales trend, inventory turnover, variance between standard and actual product cost.

Confidential,India Aug 2005 – May 2006
Role: Data Analyst and Quality Analyst

Responsibilities:

• Collaborated with business leaders, IT groups and vendors to ensure issues communicated clearly and accurately.
• Perform data analysis to evaluate the data quality and resolve the data related issues
• Responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using Microsoft Excel as statistical tool.
• Performed Data reconciliation of source, Referential Integrity, Null and Default value checks and Business Rules applied.
• Debugged data issues between source systems and EDW.
• Profiled data in the sources prior to defining the data cleaning rules.
• Verified the data loads as well as the reports.
• Involved in identifying reporting needs and helping the business in creating specification, and worked closely with report development team to achieve the reporting goal.
• Assisted the project manager in setting up the direction for business analysis team.
• Developed custom routines for generating test cases.
• Created the Test Specifications, Test Scripts and Test Categories for the testing of data in the EDW.
• Attended defect triage meetings with the end users and developers.