SUMMARY

• 7+ years of IT experience as a Data Analyst proficient in design, development, testing, implementation, and support of enterprise data warehouse.
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Expert in MS Excel including date functions, text calculations, look ups,Pivottables, ODBC, advanced summations, and VBA.
• Experienced with Fixed Income, Mortgage Backed Securities, Derivative, Options, Equities, Corporate Bonds, Credits, Foreign Exchange, Banking, and other financial products.
• Excellent comprehension of Financial Instruments and Trading.
• Combined views and reports into interactive dashboards in TableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Build, published and customized interactive reports and dashboards, report scheduling using Tableauserver.
• Experience with the design and development of Tableauvisualization and dashboard solutions using TableauDesktop.
• Involve in design and development of Tableauvisualizations, which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Expert in evaluating datamodels to design Tableausolutions.
• Exceptional presentation, organizational, and communication skills.
• Hands - on experience in datadriven decision making, quantitative analysis, operation research and data mining.
• Experience in HIPAA, Oncology as a Healthcare Business Analyst.
• Ability to write Functional Requirement Documents, Data Exchange Documents, ability to design data mapping documents using Informatics.
• Experienced in ETL and data modeling.
• Build the business rules for supporting the Data Governance.
• Development of the MDM mapping and cleanse functions according to the data governance principles.
• Implemented Data Governanceacross business lines for datastandardization and accountability.
• Extensively worked on source to target mapping (STTM) documents for data lineage.
• Strong knowledge of DataWarehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Good Knowledge on Ab Intioarchitecture.
• Worked in several areas of DataWarehouse and datamarts including Analysis, Requirement Gathering, Design, Development, Testing, and Implementation.
• Extensively worked on UNIX and Ab Intioenvironments to invoke Database Utilities and file handlings.
• Outstanding ability to analyze research and test on Oracle, SQL Server and SAS.
• Excellent skills in writing complex SQL queries in Oracle, SQL Server, and SAS (Situational Analysis System) databases.
• Knowledge of business processes in Capital Market Infrastructure Entities.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Expertise in Data Flows, Data Architecture, DataProfiling, Data Quality. and ability to create Data Dictionaries.
• Proficient in various types of testing: regression, black box, functional, UAT.
• Worked as a data modeler, data architect and data analyst in several projects. Very good understanding of data warehouse concepts.
• Created ITILService Delivery Management Processesfor the ITILlifecycle.
• Extensive experiencein facilitating Agile-Scrum Ceremonies like Daily Scrum/Stand Up meeting, Sprint Planning, Review, Retrospective and Backlog Grooming meeting.
• I have excellent analytical and problem-solving skills.
• Excellent ability to understand complex business scenarios and translate them into simpler and scalable solutions.
• Strong Analytical and Problem Solving skills with ability to gather and analyze data and generate reports.

TECHNICAL SKILLS

Technologies: Microsoft .Net, XML, HTML, DHTML, Java, J2EE

Environment: s: UNIX, Windows, IBM Mainframe (MVS/TSO), COBOL, DB2/SQL, JCL, VSAM, File Aid, Rapid SQL

Application Server: Microsoft IIS 6.0/IIS 5.0, Microsoft Server, Windows, Mainframe

Databases: DB2, MS SQL Server 2005/2000, MS Access, Oracle 11i/10g/9i/8i, My SQL, Oracle PL/SQL Programming and Tuning

Tools: Microsoft Visio, Microsoft Access & Excel,Visual Studio 2008/2005, WebSphere, MQ Series, Share Point 2007, MS Office Suite, Tableau, Orchestra Networks EBX5, Rational Suite (RequisitePro), Clear Quest, Clear case, Ab Initio, Enterprise Architect, QTP, Scrum works, Crystal reports, Informatica, Business Objects, IBM Cognos 10, Erwin.

Project Methodologies: RUP, RAD, Waterfall, Agile, Scrum

OS: Windows Vista, Windows XP Professional, Linux, UNIX

Business Skills: Business Process Analysis & Design, Gap Analysis, Impact Analysis, JAD/JRP Sessions Requirement Gathering, and Use Case Modeling, Data Mapping

PROFESSIONAL EXPERIENCE

Confidential, CINCINNATI, OH

SENIOR DATA ANALYST

RESPONSIBILITIES:

• Worked as Business Analystand Analyzed specifications and identified source dataneeds to be moved to datawarehouse, Participated in the Design Team and user requirement gathering meetings.
• Build and publish Tableaureports utilizing complex calculated fields, table calculations, filters, parameters.
• Evaluated datamodels to design Tableausolutions.
• Developed interactive datavisualizations and developed automated processes for updating content used in standardized dashboards.
• Involved in Managing datadesign standards, master dataand metadata management.
• Created extracts, published datasources to tableauserver, refreshed extract in Tableauserver from TableauDesktop.
• Assist Project Manager in creating project plan, work break down structure using MS Project and Project charter.
• Validated ETL mappings and tuned them for better performance and implemented various performance and tuning techniques.
• Worked with QA teams to resolve the issues in production and development.
• Researched and identified Data Qualityissues reported by the end users (customer relationship management).
• Assisted in the hiring process of new data quality and exclusively led the extensive on boarding process.
• Develop Data Miningprocesses for large datafiles.
• Used data miningtechniques to improve business practices.
• Appropriate follow up for ProjectLeader or other to act upon
• Coordinated projectschedules, estimates, cost control, project risk managementactivities
• Reviewed and approved projectinvoices on behalf of ProjectLeader or ProjectIntegration Manager
• Collaborated with Human CapitalBusiness Partner and work group to develop and implement employee recognition programs, awards, and incentive.
• Organized and supported ProjectLeader managing internal study team and customer meetings.
• Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Extensively used Ab Intio client tools Graphical Development Environment, Co-os, and Enterprise MetadataEnvironment (EME).
• Develop Mapping of data lineagefor each attribute stored in different datawarehouses and across several source systems.
• Design and Development of Graphs, Plans, PDL using Ab Intioand Usage of Active
• Data mapping for the existing data in the warehouse.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Worked with Architecture team to get the Metadata approved for the new dataelements that are added for this project.
• Handled metadata publish tasks to our internal datadictionary from internal DB MS Access.
• Configure model design tool (Power Designer), metadata repository (Informatica MetaManager), and analytical/reporting tool (Business Object) and set up Environment.
• Participated in the Incident Management and Problem Management processes for root cause analysis, resolution and reporting.
• Worked heavily with the XML files and automated and converted them into the specific format to make them easily testable and usable.
• Worked with Ab Initio Tool for ETL testing.
• Worked with Data Flows, Data Architecture and Data Dictionary to keep track of the changes.
• Designed the test formats in Excel. Also used VBA to write Macros; automated the test cases and different scenarios.
• Performed Data Analysis, Data Mapping and Data validation by writing SQL queries and Regular expressions.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.

Environment: RUP, XML, VBA, MS Project, MS Office, Ab Initio, Tableau, MS SQL Server, MS SharePoint, Informatica, MetaData and TeraData.

Confidential, RI

SENIOR DATA ANALYST

RESPONSIBILITIES:

• Worked with the stakeholders and management teams to gather requirements by conducting JAD Sessions 1-on-1 interviews.
• Worked on reducing the ambiguity between stakeholders and me by using tools like Erwin.
• Conducted GAP analysis and Feasibility analysis on the current and proposed system.
• Did SWAT analysis for the proposed system.
• Organized Joint Application Development (JAD) sessions with data steward and ETL teams while having walkthroughs for mapping documents.
• Worked on the current ETL system and understanding the challenges that can be faced in implementing the new system.
• Wrote Requirement documents for new ETL Process, data migration process and new Data Warehouse Design.
• Collaborated with the Data QualityEngineering team to determine automation requirements and tooling.
• Created DataMovement Models in SAP Power Designer for data lineage.
• Worked with an offshore team responsible for the functional qualityof new and existing product features to identify potential data qualitytesting requirements.
• Responsible for creation of Tableauworkbooks, dashboards using stack bars, Pie charts, bar graphs, scattered plots, geographical maps, Gantt charts.
• Used Ab Intiofor (ETL) extraction, transformation and loading datafrom heterogeneous source systems into target database.
• Performed Unit testing, Integration testing and System testing of Ab initio graphs.
• Analyzed the sources, targets, mapped and transformed the dataand loading the datainto targets using Abinitio.
• Generated and published Meta Datareports for the datamodel ETL and Reporting for the business users.
• Design and develop Meta Datareports for the ETL, Business and Support teams for day to day needs.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development, Repository Meta DataManagement and Reporting.
• Held responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards in Tableauthat answer key business questions
• Evaluated DataMart's for the Tableauvisualization.
• Created extracts from the datasource and refresh extracts on the monthly data
• Used datablending, groups, sets, dual axis, and synchronized axis to enhance the data visualization.
• Used dashboard actions for the drill down of various reports and URL action to connect to the tableauserver.
• Published reports from the tableaudesktop to the tableauserver and managing the sites and projects on the tableauserver.
• Creating DataConversion and DataIntegration Strategy, as a road map to construct Data Governancemodel that holds the master dataand dataacross different Business Units with consistency and in compliance.
• Designed data management using tools such as Orchestra Networks EBX5
• Conducted Functional Requirements and User Requirements Specification reviews.
• Worked consistently with developers and designers to make sure the plan is carried out efficiently.
• WorkedF with ComplexPivotTableModeling
• CreationPivotTablesfor Reports and creation of Graphs
• Worked on creating Data Mapping Documents, Data flow Diagrams.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review and Unit Integration Testing (UIT).
• Used SQL to perform Data Validation and Data Integrity testing.
• Kept the stakeholder updated on the progress of the project.

Environment: Scrum, MS-SQL Server, Erwin, MS-Office, Ab Intio, TeraData, Tableau, RDBMS-Oracle, Orchestra Networks EBX5

Confidential, RIVERWOODS, ILLINOIS

DATA ANALYST

RESPONSIBILITIES:

• Prepared Business Requirement Document for the Tool.
• Designed and developed wire frames for the screens of each and every module in the tool.
• Involved in an in-depth Gap analysis, generating reports and maintaining documentation of the gaps captured during the brainstorming Sessions.
• Created wireframes of the screens in every module which will make the development and the testing team more feasible in understanding of the functionality.
• Created Use Case Models, Analysis Models, Design Models, Implementation Models, authored Use Cases, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, activity diagrams) based on UML methodology using MS Visio.
• Gathered and documented the Impact Assessment on the project, due to change request, from the work stream owners and the project management team, in terms of project duration.
• Prepared and presented the process of the ongoing project in a form of Dashboard to the senior management.
• Co-ordinate with the project managers in the preparation of the project plans with any impact due to a change request.
• Experience in creating UML diagrams including Use Case Diagrams, Behavioral Diagrams (Sequence Diagrams, Collaboration Diagrams, Activity Diagrams and State Chart Diagrams, Class Diagrams, Data Flow Diagrams (DFD), and E-R Diagrams using Rational Rose and MS-Visio.
• Conducted surveys, interviews and JRP (Joint Resource Planning) and JAD sessions and translated them into System Requirements.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Developed business requirement specification documents as well as high-level project plan.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Excel downloads of summary data from SQL queries for further summarization and reporting with Excel lookups,Pivottables, graphs and formatting results appropriate for the particular internal consumer
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Experience with data migration (ETL development), document data manipulation processes and scripts
• Used SQL queries to review the current claim details which have been maintained in current Benefit administrator tool.
• Reviewed the functional test cases and updated the missed functionalities accordingly.
• Coordinated the UAT for the sign off on the tool from the customer end.
• Conducted project related presentations and provided reports to the higher management.
• Coordinated with the Business Users and resolved the day to day issues which were raised by them.
• Administrated and managed the content management using ClearCase provided access and rights to the specific users based on their role in the project.
• Maintained audit trails and records in ClearCase for the purposes of regulatory compliance in the project.
• Added and updated documents in SharePoint 2010.

ENVIRONMENT: MS SQL Server, MS SharePoint 2010, MS Office,Informatica, IBM Rational tools and Windows XP/2003.

Confidential, CLEVELAND, OH

DATA ANALYST

RESPONSIBILITIES:

• Worked closely with a project team for gathering business requirements and interacted with business users to translate business requirements into technical specifications.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Worked with querying databases using SQL and Perl scripts.
• Used Heat Maps to identify different RISK Mediums across different internal departments.
• Designed Informatica mappings such as pass through, split, Type 1, Type 2 and used various transformation such as Lookups, Aggregator, Ranking, Mapplets, Connected and Unconnected lookup, SQL overrides etc.
• Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
• Validated ETL mappings and tuned them for better performance and implemented various Performance and tuning techniques.
• Validated Job flows and dependences used by TIDAL scheduler to run informatica workflows and other shell scripts and store procedures.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Performed Unit Testing at various stages by checking the data manually.
• Performed Data Analysis and Data validation by writing SQL queries.
• Participated in the Incident Management and Problem Management processes for root cause analysis, resolution and reporting.

Environment: Rational Unified Process (RUP), Rational Suite (RequisitePro, ClearQuest, Clearcase), MS Visio, MS Excel, MS Project, Oracle 9i, MainFrame, COBOL, Informatica, Mercury Test DirectorMS SQL Server 2005, Rational Rose and Visual Basic.

Confidential

DATA WAREHOUSE ANALYST

RESPONSIBILITIES:

• Analyzing the reporting needs for Confidential Healthcare.
• Building a migrated BI Model in Cognos from an existing Business Objects based system
• The scope included analyzing the existing reporting Platform created using Informatica and Business Objects 5.1, and replicating the same in Cognos.
• Designing, developing and delivery of Cognos Catalogs, Cognos Architect Model, Impromptu Reports, Transformer model, Cognos Cubes and Drill through Reports.
• Optimization of cube build and performance.
• Publishing the cubes and reports to UNIX IWR and PPES server
• Creating and execute test plans/scripts to find errors and confirm reports/cubes meet specifications.
• Consulting with the Data Warehouse Analyst to prototype, test, and debug reports/cubes to meet business requirements.
• Change Control & Configuration Management of BI Artifacts
• Getting the user validation and deployment to production.
• Providing technical assistance with troubleshooting reports/cubes by responding to inquiries and questions

ENVIRONMENT: Oracle 8i/9i, Informatica, BO, Cognos

Confidential, PHILADELPHIA, PA

DATA ANALYST

RESPONSIBILITES:

• Performed analysis, review, and estimation of client requests; prepared and reviewed business requirements and client documentation.
• Produced functional specifications and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Analyzed the business requirements and involved in writing Test Plans and Test Cases
• Executed SQL Queries to verify the dataflow.
• Used SAS to import/export data to external file formats likeflat, Excel, XMLfiles.
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Wrote requirements for designing data marts that were used as the source for the various reporting systems in the company.
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation.
• Performed Data Modeling by creating logical and Physical models of the database system.
• Performed Data Analysis and Data validation by writing SQL queries.
• Involved in Data Analysis for the data warehouse and data mart system.
• Wrote requirements for various reports to be generated and migrated.
• Participated in writing Data Mapping documents and performing Gap Analysis on the systems.
• Performed Analysis and design of implementing a Star Schema Data Mart with facts and dimensions.
• Reviewed Business Requirement Documents and the Technical Specification.
• Used ERWIN for Logical and Physical database Modeling.
• Maintained documentation related to difficulties, complexities, and anomalies that may arise during the ETL process.
• Analyzed user statement of requirements to develop new reports.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes. .
• Involved in design, code, test, and various other review meeting.
• Responsible for weekly status.

Environment: RUP, Rational Tools, Microsoft SQL Server, SAS, MS-Office, MS-Visio, SQL, PL/SQL, Windows and UNIX.