SUMMARY

• 8+ years of IT experience in Data Analysis including project planning and management with various business domains such as banking, mortgage, insurance, manufacturing and health care.
• Working experience in Big - Data and Teradata using industry best practice tools and techniques, combined with solid academic principles to deliver maximum value to the client.
• Proficient in Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP & OLAP, Data Mapping, Data Quality, Data Cleansing, Data Reconciliation, Data Profiling, Data Masking and Data Validations
• Experience in relational and dimensionaldatamodeling and logical and physical database design.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) and Indexes.
• Worked closely with various teams in the company to identify and solve business challenges utilizing large sets of data in a distributed processing environment and to develop marketing & management strategies.
• Experience in analyzing raw data to draw conclusions and recommendations
• Experience in manipulating, cleaning and processing data using Excel, Access and SQL.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle, Waterfall and Agile methodologies.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Proficient in preparing different requirement artifacts like Functional Specifications (FS), workflow/process flow, algorithms, use cases, Service Request (SR) and Requirement Traceability Matrix (RTM).
• Developed and implemented a business intelligence strategy that ensures the systemdatais secure, integrated and accessible to staff.
• Worked with various groups including business users to resolve dataintegration issues and troubleshooting & testing of data issues.
• Development and maintenance of Business Metadata for the assigned applications and any corporate-level reports.
• Involved in Delivery Data Steward activities from Impact Assessment (IA) Notification, Creation of Business Metadata, User Acceptance Testing (UAT) and Post-Production Validation (PPV) etc.
• Experience in Data Extraction, Transforming and Loading (ETL) using various tools
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Experience in advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Excellent strengths in mathematics, applied statistics, construction engineering and visualization capabilities, and to see through the data and analyze it to find conclusions.
• Excellent communication, analytical and leadership skills and a good team player.

TECHNICAL SKILLS

RDBMS: MS SQL 2008, 2005, 2000, MySQL, Oracle SQL/11g, MS-Access

Programming Languages: C, C++, SQL, PLVB.NET, MATLAB

Data Analysis Tools: R, Python, SAS, MS-Excel, Abinitio Data Quality, Teradata, Hadoop

Data Modeling Tools: Erwin 4.0, ER/Studio, Informatica ETL, Vision 2002

Operating System: Windows 8/XP/NT/ 2000/2003/2007, UNIX and Linux

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reporting,CAS, Cognos Version 8

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Data Analyst / Data Steward

Responsibilities:

• Worked on large sets of structured and unstructured data, and analyzing it to draw meaningful conclusions.
• Build and analyze queries from Teradata & Oracle databases using SQL.
• Completion of IDM assessments that identifies important data within applications and compliance gaps to the Policy
• Development and maintenance of business metadata for their assigned applications and any corporate-level reports
• Documentation of data quality checks and thresholds for important data elements
• Ensure monitoring of the important data elements for data quality and integrity and creation of data quality reporting that is performed on at least a quarterly basis
• Worked on customer mortgage and loan data across multiple internal and external sources into a consolidated customer database.
• Participate in daily agile meeting, weekly and monthly staff meetings and collaborate with various teams to develop and support ongoing analyses.
• Conduct dataaccuracy analysis and support stakeholders for decision-making.
• Analyzing data using advance Excel functions such as Pivot Table, Charts and Graphs.
• Worked on querying data and creating on-demand reports and involved in data validations.
• Developed and executed data retention plans that establishes the retention period for important data and the business justification for that defined retention period
• Supported Product Strategy DA team in testing, data analysis, and other projects as needed
• Provided technical support to data warehouse teams. Data set sizes are usually huge (in excess of hundreds of millions of records).
• Involved in Delivery Data Steward Activities from Impact Assessment Notification, Creation of Business Metadata, Data Masking, Coordinating User Acceptance Testing (UAT) and Post-Production Validation (PPV) etc.

Environment: SQL Server 2005/2008/2008 R2/2012, MS Access, MS Excel, MS PowerPoint, R, SAS, Teradata, HTML, XML, Visio, ASP.NET, Cognos Version 8, Abinitio, Oracle SQL/11g, Informatica ETL, UNIX.

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques.
• Build and analyze queries from databases using SQL.
• Working with client on customer data by relating from multiple internal and external sources into a central consolidated company-wide customer database.
• Daily movement of users and handling cases, analysis and Ad hoc Reporting.
• Provide input to improve customer dataprocessing.
• Participate in weekly staff meetings and collaborate with various teams to develop and support ongoing analyses.
• Conduct dataaccuracy analysis and support stakeholders for decision-making.
• Analyzing data using advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Handled the company’s day-to-day reporting anddataaccess needs.
• Developed and implemented a business intelligence strategy that ensures the systemdatais secure, integrated and accessible to staff.
• Worked across departments to identify and understand key business questions, and standardize key metrics and measures.
• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Analysis, design and data modeling of Logical and Physical database using E-R diagrams.
• Design/Build Extract Transform Load procedures in SQL Server 2005/2008/2008 R2 using DTS packages to import/export data feeds to/from data warehouse and claim systems.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Designed and created Report templates, bar graphs and pie charts based on the customer data.

Environment: SQL Server 2005/2008/2008 R2, MS Access, MS Excel, MS PowerPoint, R, SAS, Informatica ETL, Abinitio, VBScript, HTML, XML, Visio, ASP.NET, VB.NET, BIDS.

Confidential, Overland Park, KS

Data Analyst / Modeler

Responsibilities:

• Reporting requirements and reports generation using MS Excel and advanced use of VBA and macros.
• Conducteddatamodeling anddatamapping for reportingdataelements.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and assisted in the development of current and Confidential state enterprisedataarchitectures.
• Worked with project team representatives to ensure that logical and physicaldatamodels were developed in line with corporate standards and guidelines.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems.
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddata validation issues.
• Worked on logical and physical modeling of variousdatamarts as well asdatawarehouse using Teradata.
• Involved in defining the source to targetdatamappings, business rules, datadefinitions, and datamasking for shared test environment.
• Responsible for defining the functional requirement documents for each source to Confidential interface.
• Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testing team.
• Reverse engineered all the Source Databases using Erwin.
• Defined milestones in project plan using MS Visio with the help of WBS and network diagram.
• Produced documentation including detailed Business Requirements, Functional Requirements and assisted to produce Technical Specification and Operations Manual.
• Assisted Developers inDataModeling using Entity Relationship Diagrams (ERD).
• Collaborated with cross-functional teams throughout the project life cycle.
• Useddataanalysis techniques to validate business rules and identified low quality missingdatain the existing EnterpriseDataWarehouse (EDW).

Environment: SQL Server 2005/2008/2008 R2, MS Access, MS Excel, MS Word, MS Outlook, Erwin, Crystal Reports, Teradata, MS PowerPoint, R, SharePoint.

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

• Tested database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Identified, suggested and managed improvements in the process to meetdataquality criteria.
• Created adhoc reports and pivot tables in Excel using VBA and macros.
• Identified and prioritized strategic themes of the business to align them with IT strategies thereby growing revenue, improving profits through efficient quality of services.
• Collected keydatametrics to determine mandatory and discretionary investments based on the prioritizations and projected the expected returns using MS Access.
• Responsible fordatamapping anddatamediation between the sourcedatatable and WMOdata tables using MS Access and MS Excel.
• Created SQL queries to pull outdataand metrics from the database.
• Reviewed all artifacts created with respect to Logical and physicaldatamodels including Tables, procedures, indices, synonyms, views, functions, triggers, sequence and constraints.
• Analyzing change request for the existing mapping and creating an impact analysis for the change ondata.
• Prepared testdatapreparation strategy anddatamasking strategy for the shared test environment.
• Co-ordinate with development and QA team for handling of defects with respect tomortgage data and portfolio data.
• Interact with clients/business users when issues arise ondatagovernance.
• Provide support during parallel and reverse parallel runs.
• Created spreadsheet with all the production issues/solutions as part of lessons learnt and to help form FAQ for the maintenance team.
• Created ETL mapping documents for every mapping anddatamigration document for smooth transfer of project from development to testing environment and then to production environment.

Environment: SQL Server 2005/2008/2008 R2, PL/SQL, MS Access, MS Excel, MS PowerPoint, Quality Center 10.0, .NET, XML, HTML, Windows and Unix, Shell Scripting, COGNOS.

Confidential, Durham, NC

Data Analyst

Responsibilities:

• Gathered Business requirements based on the project scope and SDLC methodology.
• Conducted JAD sessions with SME including business owners, sponsors andanalysts.
• Collected metrics using MySQL like number of emails generated, percentage of who opens, forwards and clicks-through for the campaign.
• Analyzed and conducteddatamapping of the metrics with the member profiledataand also the attendance and purchasingdatato understand the overall profiles of the members.
• Designed and developed Use Cases and Activity Diagrams using UML in rational rose and Visio.
• Created MySQL queries to pull out user-level activitydataand various other metrics defining popularity of products on the website.
• Collected user related visitor-level metrics like frequency of visits, duration and number of unique visits and stickiness to measure the effectiveness of the recommendations available.
• Extensively used MySQL Toad for querying underlying database tables and resolvingdataissues, and involved in data masking.
• Assisted the Product support team to create and constantly update the FAQ section by actively researching issues and addressing customer questions.
• Worked with the Product managing team in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Conducted back end email tracking using MySQL to do the success rate study to measure Email Broadcast campaign success, deliverability and measure marketing response for each of the campaigns.

Environment: SQL Server 2005/2008/2008 R2, MS Access, MS Excel, MS Word, MS Outlook, Crystal Reports, MS PowerPoint, R, SharePoint, Visio.

Confidential

Data Analyst / Developer

Responsibilities:

• Created and/or strengthen systems fordatacollection, management, reporting and analysis. Advised the agency on technology needs to maximize efficiency and support a culture of managing todata.
• Assisted in the creation and documentation of the business processes fordatacollection, entry, reporting, review and use ofdatato strengthen performance management.
• Implemented logical and physicaldatamodeling.
• Developed PL/SQL stored procedures for the end-user report requirements.
• Created crystal reports on the stored procedures and exported the Business Objects reports to WEBI, to be viewed by all users on the intranet and extranet.
• Created many simple, complex and Adhoc reports using Crystal reports as maindataproviders and having the Powerful functionalities like @functions and formulae.
• Created queries for multidimensional analysis using slice, dice and drill modes.
• Analyzed complex business needs presented by the user community and/or clients and recommended technical solutions to improve the reporting environment.
• Deployed Eport Reports on the intranet website in form of PDFs.
• Accomplished Performance tuning of SQL queries and stored procedures using Database tuning advisor in SQL Server
• Trained end users in basic and advanced ad hoc reporting skill.

Environment: Windows XP/2000 Advance Server, SQL Server 2000/2005, SSRS, Crystal Reports, Web Intelligence, InfoView, MS Excel, MS Word, MS PowerPoint.