PROFILE SUMMARY

• AMicrosoft Certified Professionalwif around9 yearsof total IT experience in Database and Business Intelligence Technologies wif expertise on ETL process and Reporting as Sr. Data Analyst and MS SQL Developer.
• Work wif business and document teh business rules of teh data from different source systems in source to target data Mapping/BRD document.
• Experience in Data Analysis, Root cause analysis and Data Profiling using SQL, MS Access and MS Excel on teh business requirements on large volume of data sets.
• Experience in matching, merging and cleansing teh data sets using complex SQL for identifying unique customer details from different source systems in data warehouse using customer demographic, identification and address details.
• Identify, document, track and communicate data issues/analysis teh complex data sets to business and all team members.
• Design and Development using T - SQL, SSIS, SSRS, complex Stored Procedures, Configuration Files, Tables, Views and Functions. Writing Complex SQLs using CTEs, Analytical functions, SET operators, Complex JOINs, Subqueries, and Temp tables, etc.,
• Good experience in Data Modeling in Data Warehousing dimensional data modeling using Star schema and Snow flake schema (Fact and Dimension tables).
• Experience in relational Normalization (2NF, 3NF) forms/models.
• Performing Data transfers between different homogeneous/heterogeneous systems and SQL Server/Oracle as a part of Data Migration, Data Maintenance and other ETL tasks.
• Hands on experience in scatter plots, box plots, blending, clusters, table calculations, calculated fields, pivots and splits in Tableau 9 and Tableau 10.
• Experience in creating Test Plans, Test Cases and Test Data based on business requirement for testing.
• Experience in User Acceptance Testing, Integration Testing and System Testing of modules/applications during Production moves.
• Experienced various project related activities like mentoring team in specific modules, documentation and best practices.
• Strong problem solving and analytical skills wif ability to work independently as well as in a team (onshore/offshore).
• Good ability to quickly grasp and master new concepts and technologies
• Good exposure in Waterfall and Agile methodologies.
• Good exposure in Healthcare, Banking domains.

TECHNICAL EXPERTISE

Programming Languages: T-SQL, PL/SQL, C#, HTML, UNIX commands, VBA, Visual Basic

Databases: MS SQL Server, Oracle, Netezza, Teradata, MS Access

Database/Application Tools: MS Management Studio, Visual studio, SQL developer, Toad for Oracle, Teradata SQL Assistant, Erwin

ETL Tools: SSIS, Informatica (ETL, DQ, MDM)

Reporting/Analytical Tools: SSRS, SSAS, Tableau

Defect Tracking Tools: HP Quality Center/ALM, JIRA

Methodologies: Waterfall, Agile

Domain: Data Warehousing, Banking, Healthcare

Other Utilities: Visual Source Safe, MS OFFICE, SVN, TFS

TECHNICAL SKILLS

Confidential, CA

Sr. Business/Data Analyst

Responsibilities:

• As a member of IT Data Services Management team, created source to target designs, provided detailed data analysis and managed metadata in support of teh development and/or implementation of new or enhanced systems projects or programs.
• Participated in development of strategic and tactical planning activities, and works wif IT PMO, business users, and technical peers to provide solution estimates.
• Review business requirements and leads source to target design efforts including system technical flows, use case analysis for a complex portfolio set of applications
• Implemented improvements to teh quality of processes, standards and metrics.
• Worked wif subject matter experts from teh project team to determine data requirements for analytical systems, develop these requirements into functional specifications and detailed data flow design documents, and participates in teh full development process life-cycle from concept, through testing, to implementation.
• Involved in identifying necessary data, reconciling wif teh new application and teh legacy data sources and ensuring a successful implementation.
• Communicating business term definitions, establishing data quality rules, researching and analyzing data in support of business functions, process and workflow knowledge, and user acceptance testing.
• Leads teh data and system impact analysis incorporating system designs and system architecture.
• Participate in problem management process. Performs data profiling and detailed data analysis of source systems and target analytic solutions.
• Proficient on querying and extracting data from repositories such as Netezza, Oracle, SQL Server, etc.

Confidential, Texas

Sr. Data Analyst and MSBI SQL Developer

Responsibilities:

• Attending various meetings wif business/clients on requirement clarifications, design walk through sessions for teh projects.
• Understand teh business requirement and preparation of Business Requirement and Technical design Document.
• Carrying out Data Analysis and Data Profiling using complex SQL and Excel on teh business requirements.
• Implement Data Governance Rules for Data Quality, Data integrity, Data cleansing and Error Validation for reporting and correcting source data issues
• Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions for Data Analysis.
• Created scatter plots, box plots, blending, clusters, table calculations, calculated fields, pivots and splits in Tableau 9.
• Extensively used SSRS for creating Complex drill down & drill through reports, Matrix reports, Sub reports and Charts.
• Review teh mapping and requirement design document wif business and project team members.
• Involved in Root Cause Analysis of issues and provided extended production support based on teh demand and complexity of teh issue.
• Responsible for maintaining teh data quality and integrity of teh tables used for other reporting purposes.
• Analyzing teh Data Issues reported by teh end users of teh tools (Cognizant20 & Prolite) and providing teh resolution and tracking it to teh closure.
• Documented, clarify, and communicate requests for change requests wif teh requestor and coordinate wif teh development and testing team.
• Supported development and QA team members on providing teh solutions for teh issues.
• Created Test Plans, Test Scenarios, Test Cases based on business scenarios for UAT and SIT.
• Created Test Data for Development, QA and UAT team members for difference scenarios.
• Worked wif all teh team members till teh project closure.
• Performed post production validation after go-live.

Confidential

Data Analyst and SQL Developer

Responsibilities:

• Understand teh business requirement and preparation of Functional design and Source to Target mapping document for various business rules of teh data from different source systems in to target.
• Review teh mapping and requirement design document wif business and project team members.
• Implement Data Governance Rules for Data Quality, Data integrity, Data cleansing and Error Validation for reporting and correcting source data issues.
• Carrying out Data Analysis and Data Profiling using complex SQL and advanced Excel functions on teh business requirements.
• Carrying out extensive data analysis on matching, merging and cleansing teh data sets using complex SQL for identifying unique customer details from different source systems in data warehouse using customer demographic, identification and address details for Master Data Management.
• Involved in Root Cause Analysis of issues and provided extended production support based on teh demand and complexity of teh issue.
• Identify, document, track and communicate data issues/analysis on complex data sets to business and all team members.
• Responsible for maintaining teh data quality and integrity of teh membership, claims, providers, PCP tables used for other reporting purposes.
• Engage wif business owners to define Reference, Master, and Metadata (e.g., dictionary, data architecture, standards)
• Support teh business by leading analytical data designs (e.g., dimensional modeling, DW table & index design, DW database design)
• Establish data quality standards and best practices and work wif Design/Development/QA team to ensure teh data rules are being supported and properly maintained.
• Ensure teh development of capabilities to enable easy access to high quality, integrated Reference, Master and Metadata.
• Work wif Architects to Develop and implement a comprehensive data repository and storage architecture including solutions for data sourcing, data integration & staging, data hub (data warehouses, stores, marts, etc.), data privacy, reporting/analytics/views, data quality & governance.
• Created Test Data for Development, QA and UAT team members for difference scenarios.
• Worked wif all teh team members till teh project closure.
• Performed post production validation after go-live.

Confidential

Technologies MS SQL Server, SSIS, SSRS 2005/2008, Teradata v2r5, Oracle, C#.Net, HP QC, SVN, UNIX, T-SQL, PL/SQL, VBA, Visual Basic, Erwin

Business/Data Analyst

Roles and Responsibilities:-

• Interact wif Business, SME, Design team to understand business requirement and prepare BRD, Data Mapping and Technical Design documents.
• Attending various meetings wif business/clients on requirement clarifications, design walk through sessions for teh projects.
• Perform detailed Data Analysis, Data Profiling, Data Cleansing, Data Quality and Data Integrity using complex SQL/Excel and discuss wif Business and Design team on teh results and document teh mapping rules.
• Worked wif Business to provide teh reference lookup data for all different source codes.
• Worked wif Data Architects and Data Modelers to Design and Development of data warehousing FACT and Dimension tables in star and snowflake schema data models using T-SQL, MSBI Technologies.
• Extensively used SSRS for creating Complex drill down & drill through reports, Matrix reports, Sub reports and Charts.
• Work wif QA and DEV Team on root cause analysis and fixing issues testing.
• Review teh mapping and requirement design document wif business and project team members.
• Prepared project/knowledge transfer documentation for team members and production maintenance.
• Created Test Plans, Test Scenarios, Test Cases based on business scenarios for UAT and SIT.
• Created Test Data for Development, QA and UAT team members for difference scenarios.
• Work wif release management and support team on production deployment and maintenance activities.
• Worked wif all teh team members till teh project closure.
• Performed post production validation after go-live.