SUMMARY

• 7 years of Industry experience as a Data Analyst/DW Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping and Data Modeling.
• Proficient in gathering and converting User Requirements into Business Requirements and Functional Requirement Specifications (FRS) and use Modeling tools like Rational Rose and Microsoft Visio for requirements modeling. \
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Experience in Business Intelligence (BI) Technologies like Microsoft Business Intelligence (SSIS, SSAS, and SSRS), Informatica, Business Objects, and OBIEE
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Experienced on Cloud Database and Data Warehouse (AQL Azure and AWS Redshift/RDS)
• Very good understanding of DataWarehousing concepts,DataAnalysis,DataWarehouse Architecture and Designing.
• Experience working withdatareporting tools, includingDataAdvantage.
• Hands - on experience with an enterprise Content Management System
• Worked on employee benefits, health insurance, defined-benefit pensions, andhealthcarepayer operations.
• Very good understanding ofDataWarehousing concepts,DataAnalysis,DataWarehouse Architecture and Designing.
• ExperienceinDataAnalysis,DataValidation,DataCleansing,DataVerification and identifyingdata mismatch.
• Good experiences in DimensionalDataModeling using Star Schema and Snow Flake Schema using Ralf Kimball methodology and well versed with UNIX shell scripting and Oracle SQL programming.
• Experience using query tools for Oracle, Sybase, Teradata, DB2 and MSSQLServer to validate reports and troubleshootdataquality issues.
• Developed ETL Mapping Document based onDataprofiling and source system analysis.
• Strong experience in Excel and MS Access
• Expert in Teradata,SQLServer and Oracle systems.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Creative and aggressive self-starter with integrative thinking skills, capable of communicating creative ideas through graphical analysis charts and statistical data display

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Data Analyst

Responsibilities:

• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Develop, build and manage Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Involved in writing T-SQLProgrammingfor implementing Complex Stored Procedures and User Defined Functions for different tasks.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team
• Optimizing and tuning the Redshift environment, enabling queries to perform up to 100x faster for Tableau and SAS visual analytics
• Wrote complexSQLqueries for queryingdataagainst differentdatabases fordataverification process.
• Prepared the Test Plan and Testing Strategies forDataWarehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively usedSQLprogrammingin backend and front-end functions, procedures, packages to implement business rules and security
• Implemented variousDataMining techniques using variousPythonpackages, SPSS Statistics and SPSS Modeler tools
• Helped the Testing team by writingSQLstatements to validate the reports
• Used multipledataproviders, Master/Detail, cross tab, Charts.
• Created several Ad-hoc reports in Business Objects XI R2 to validate thedata.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis)
• Defects identified in testing environment where communicated to the developers using defect tracking tool Quality Center.
• Responsible for differentDatamapping activities from Source systems to Teradata
• Developed scripts, utilities, simulators,datasets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for dailydata loads.

Confidential, Long Beach, CA

Sr Data Analyst

Responsibilities:

• Elicit requirement to be able to generate the tools and info needed to process the ICD-10 information by 2013 (Claims Processing, Training etc.)
• Createddatarequirements and testdatato test type II slowly changing dimension tables.
• Prepareddataquality criteria and governance forDataWarehousing Application.
• Extensively usedSQLprogrammingin backend and front-end functions, procedures, packages to implement business rules and security.
• Used to perform ETL on flat files before loading into aSpotfiredashboard
• Worked with SSIS system variable, passing control and audit variables between packages.
• Written complexSQL, T-SQLqueries for queryingdataagainst differentdatabases fordataverification process anddataretrieving process.
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Developed reports using the Teradata advanced techniques like rank, row number.
• Developed scripts, utilities, simulators,datasets and other programmatic test tools as required executing test plans.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Analyzeddatafrom various sources like Oracle, flat files andSQLServer.
• Worked ondataissues with migration from development to testing.
• Produced and verified analysis datasets, tables, listings and figures usingSASfor clinical trial data, medical record data, and claim data.
• UsingPythonindatacollection programming.
• Thorough understanding of thebusinessprocess to help determine the user needs.
• Review Implementation Plan and testing types, techniques and environmental needs.
• Defect Management&triage, provide expertise to resolve defects that raise business issues.
• Actively involved in documentation of UAT (User Acceptance Test), Functional Test, Integration Test Scenarios and Bug Log.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Actively participated in weekly status meeting with Team members, Team managers, Business analysts & Technical team and also generated Weekly Status Reports to the Team manager.

Confidential, Deerfield, IL

Data Analyst

Responsibilities:

• Formulated and defined systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements following RUP.
• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying thedatasources required for the requests.
• Very good knowledge onHealthcareprocesses,healthcaredata, claimsdata, providersdata, patientdata, encounters etc.
• Worked ondataprofiling,dataanalysis and validating the reports sent to third party.
• Designed and developed Ad-hoc reports as per businessanalyst, operationanalyst, and project managerdatarequests.
• Extracted, Analyzed and PresentedDatain a Graphical Format, such a way that helped project manager to make Business Decisions.
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD.
• Communicated with business users and analysts on business requirements.
• Gathered and documented technical and business Metadataabout thedata.
• Worked onDataVerifications and Validations to evaluate thedatagenerated according to the requirements is appropriate and consistent.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Analyzed data on the consumer market to determine target customers and on the supply market to customize services usingSASdata step.
• Experienced in using OLAP functions like sum, count, csum and etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loadingdatainto staging tables via views.
• Created daily and monthly reports usingSQLand UNIX for Business Analysis.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using TeradataSQL.
• Experience in Power Point Presentation (FinancialData, Charts).
• Expertise in generating graphs using MS Excel Pivot tables.
• Extracteddatafrom existingdatasource, Developing and executing departmental reports for performance and response purposes by using oracleSQL, MS Excel.
• Extracteddatafrom existingdatasource and performed ad-hoc queries.

Confidential, Princeton, NJ

Business Data Analyst

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Manipulating, cleansing and processing data usingSAS/Base andSAS/SQL.
• Generated ad hoc reports, analyses, and data files in response to specific data inquiries usingSQL, Power Pivot, Excel, and Access
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Test Director.
• Translated customer/clients' needs into new features and new services.
• Develop process improvement projects by gathering and analyzing data.
• Define Key Process Areas for different Projects.
• Extensive knowledge of CRM tool Salesforce.com implementation cycle in Sales, Marketing, Service and support modules..