SUMMARY

• 8 years of diversified experience in IT Industry as Report Analyst, DW/ BI Analyst and Data Quality Analyst.
• Experience on Software Methodologies - Agile & Waterfall & Full Software Development Life Cycle (SDLC)
• Responsible for Initiative design, Initiative estimation, Gap Analysis.
• Expert level knowledge in Database concepts like Entity Relationships, Database constraints, data types, Normalized and De-normalized data models, Star and Snowflake Schemas
• Designed and developed database programs like Stored Procedures, Functions and Views.
• Extensive experience in complex Data Analysis by writing complex SQL queries.
• Performed a role of Data, System and BI Analyst on semi data acquisition, transformation and reporting process and converting that into a SQL Server DW and Reporting based system.
• Developed T-SQL scripts and SSRS reports to analyze data coming from various applications Finance, Marketing, Clinical, and CRM etc.
• Experience with data analysis and reporting tools like Access, SSRS, Excel 2010, 2007 and 2003.
• Experience in application development using TOAD and SQL.
• Extensive experience in Finance, Healthcare and Sales data and Support applications.
• Experience of using T-SQL, SSIS and SQL Server 2012 along with complex inner-outer joins, set operations, sub-queries, correlated sub-queries.
• Knowledge of relations databases, entity relationships, SQL data types and Database constraints
• Experienced in DB Views, Functions and Stored Procedures for speedy and effective data analysis and system analysis.
• Developed reports and ad-hoc reports using SSRS and Excel.
• Developed drill drown reports, reports with charts and scorecards, linked reports and used conditional formatting.
• Knowledge of Excel calculations, pivot tables, v-lookups and several data analysis & reporting features in Excel.
• Used excel effectively to communicate data analysis, discrepancies to the business users, management and executives.
• Proficient in using Microsoft Office ( Excel, Power Point, Word) for documentation, reporting discrepancies, and doing presentations.
• Participated in daily Scrum meeting and also assisted management and team to achieve sprint goals.
• Strong analytical and problem solving abilities.
• Extensive Experience in data analysis and testing of ETL process by using complex joins, Group By, Having, Sub queries, Co-related Sub Queries, and Views etc.
• Experience of HP ALM/Quality Center to Create, modify, Track issues until resolution and to produce reports on defects by their status & category. Also used ALM for writing test cases and executing test cases using the test lab.
• Provide Regular updates, status on Defects to Project Team & management.
• An enthusiastic and self-motivated team player with the ability to manage multiple projects simultaneously, meet stringent deadlines and achieve project objectives
• Possess the level of communication and interpersonal skills together with the resourcefulness required to adapt to new environments, challenges and increasing amount of responsibilities

TECHNICAL SKILLS

DBMS: TOAD, Oracle, Teradata, Microsoft Azure, SQL Server Data Tools 2012, Management Studio 2008R2, 2005, Enterprise Manager, Business Intelligence Development Studio 2012, 2008R2, 2005. Visual Studio 2010, 2008

App. Dev.: .Net, SharePoint, JAVA Script, Info Path, Custom Web Parts in SharePoint 365, SharePoint 2010

Reporting: Tableau, SSRS 2012, 2008 R2,OBI, Crystal Reports 9, 11

ETL: SSIS 2012, 2008 R2, 2005, T-SQL

Languages: SQL, T-SQL, VB Script

Team Collaboration: SharePoint 365, 2007, 2010

Version Control: Team Foundation Server, Clear Case

Office Tools: Word, Excel, Power Point, Visio, Outlook

Operating Systems: Windows Server 2008, 2003, Win. 7, Vista, XP, 2000, 98

Business Skills: Client Relations, Proto Typing of Reports & UI, Requirements Gathering, QA Activities-Test Plans, Test Cases, Tracking & reporting Defects, Business Process Modelling, Process Documentation, Project Management, Gap Analysis, Use Cases, Testing & Development Traceability Matrix, User & Documentation, Effort Utilization tracking, Review test Cases, Risk Analysis

Defect Tracking Tools: HP Quality Center, Bugzilla, SharePoint, 2007, 2010, Team Foundation Server 2010, Microsoft Test Manager

PROFESSIONAL EXPERIENCE

Data/Report Analyst

Confidential

Responsibilities:

• Understanding the business requirements by attending meetings and going through the project documents.
• Document the requirements and create technical specifications based on the business requirementsand reporting needs.
• Create user stories, provide level of effort for each work assigned.
• Created scripts to createnew tables, queriesfor new enhancement in the application using TOAD.
• Query data using Teradata and SQL to get business specific data.
• Analyze data from the multiple billing systems.
• Created volatile tables and wrote complex queries and stored procedures in Teradata for analysis and comparison between old and new system.
• Prepared Tableau and SSRS reports, dashboards as per the business needs.
• Queried data from various data sources in SQL and Teradata to do ad hoc reporting.
• Converted queries from Oracle to Teradata.

Data Analyst/ System Analyst

Confidential

Responsibilities:

• Understood the requirements from the business and documented the detailed requirements.
• Used Visio for documenting process flow and system flow diagrams.
• Queried data from various data sources to show gap analysis, data analysis and ad hoc reporting using excel.
• Mapped the data requirements on data sources.
• Wrote stored procedures and queries using TOAD.
• Worked with System Architects, Application designers to design overall system.
• Performed system analysis, mapped the reporting requirement on different data elements and built report prototypes using Excel.
• As a BI Analyst worked on transforming the data for SSRS Reports and SSIS.
• Created data dictionary and communicated it to developers.
• Developed SSIS packages
• Modeled Normalized Application data structures as well as Dimensional / OLAP / De-normalized data structures.
• Developed database programs like Functions, Stored procedures.
• Performed extensive system analysis and analysis of data in order to understand data relationships.
• Presented data analysis to developers to explain the data model.
• Performed data extraction, transformation and loading (ETL) data from various relational databases, flat files, excel files, in house applications to populate Dimensions, Facts into Data Warehouse.
• Developed Reports, Dashboard, KPIs and Scorecards.
• Performed Advanced analytical, diagnostic and reverse engineering existing ETL code to support and enhance.
• Communicated effectively with all levels of management, both written and verbal, tailoring message to suit the target audience.
• Developed quality functional specifications and technical design documents.
• Ability to work independently as well as in a team environment and success with meeting deadlines under pressure.

Environment: Microsoft Azure, SharePoint 365, SQL Server 2012, T-SQL, SSIS, Excel 2010, TFS, .NET, Visio

Data Quality Analyst II

Confidential, Jacksonville, FL

Responsibilities:

• Attend requirements/design reviews and provide feedback on new/enhanced Software Business Requirements and High Level Designs.
• Developed complex SQL queries for data manipulations and Statistical reporting.
• Developed report prototypes using excel.
• Developed parameterized and drill down reports for detail data.
• Actively participated in collecting, gathering and taking sign off on Enterprise Data Quality definitions
• Performed data quality profiling on data coming from various applications like Finance, Marketing, clinical, CRM etc. and worked with Business users to analyze data and identify the opportunity for data quality improvement as well as for setting up acceptable threshold for data quality measures.
• Validated data by writing queries in TOAD.
• Analyzing and understanding all Technical Design Document, Mapping Document
• Responsible for Verifying and Validating DDL, tables developed in Ab initio by writing queries using IBM Data Studio and SQL Server.
• Used Rational Clear Case for all Documentation and prototypes.
• Attending Change Request meeting to plan the changes in Testing.
• Analyzed and Validated Dashboards and Reports generated from Info bank (Oracle) and SSRS (BI). Validated the report layout and data in the report by using Excel and by writing Queries.
• Developed reports to find out and to analyze production data quality issues.
• Worked on maintaining and supporting weekly data processing, data quality checks and any report issues.
• Developed queries using stored procedures and functions to analyze the data.
• Developed reports using SSRS and wrote SSIS packages.
• Did end to end validations and analysis from when the data landed into tables to data delivery in form of Reports.

Environment: SQL Server 20012, 2008R2, SSRS 2012, 2008R2, Oracle 10G, OBI Reports, SQL Server Management Studio, Visual Studio 2010, .Net Excel 2010, Windows server 2008R2, T-SQL, Visio, HP Quality Center, UFT 11.5, QTP11, 10, SharePoint 2010, TFS

Sr. BI Analyst/ Data Analyst

Confidential, Jacksonville, FL

Responsibilities:

• Elicited requirements using interviews, JAD sessions, review of current processes and process modeling.
• Analyzed and evaluated requirements gathered from multiple sources in order to identify true business needs and related details.
• Delivered gathered requirements through process flow models, Business Requirements Document (BRD), Use Cases and GUI wire frames.
• Interacted successfully with multiple stakeholders and Subject Matter Experts (SME) for requirements gathering, reviewing and finalization.
• Worked using Agile Methodology.
• Actively participated in collecting, gathering and taking sign off on Enterprise Data Quality definitions
• Participated in chain of meetings and iterative processes to define the Data Management Strategy.
• Performed data quality profiling on data coming from various applications like Finance, Marketing, clinical, CRM etc. and worked with Business users to analyze data and identify the opportunity for data quality improvement as well as for setting up acceptable threshold for data quality measures.
• Designed data quality testing procedures in manual as well as automated fashion using SQL, T-SQL and SSIS packages.
• Developed T-SQL scripts and SSRS reports to analyze the data and data quality issues and to surface data quality improvement opportunities.
• Developed reports to find out and to analyze production data quality issues.
• Worked on maintaining and supporting weekly data processing, data quality checks and any report issues.
• Worked on developing Data Quality Management strategy for the enterprise.
• Participated daily Scrum meeting and also assisted management and team to achieve sprint goals.
• Performed functional testing, UAT testing, system testing, Unit testing, GUI testing, integration testing, regression testing, interface testing and database testing. Performed system and data analysis to come up with test strategy and success criteria and performed manual testing accordingly.
• Developed QA Automations to perform data validations.
• Validated stored procedures, jobs, triggers and replication.
• Perform extensive application testing, data warehouse, ETL, QA by performing research in source systems and data feeds.
• Develop detail QA reports with data visualizations to show data issues
• Develop Excel, ad-hoc SSRS reports to communicate data issues to developers
• Develop extensive SQL queries joining multiple tables using complex inner-outer joins, set operations, sub-queries, correlated sub-queries
• Perform data comparison across databases using linked servers
• Develop T-SQL programs, functions, stored procedures to automate the data QA.Test SSIS package which used various tasks like lookups, merge joins, e-mail etc.
• Perform testing against data sourced from Web Services, Text Files, CSV Files. SharePoint lists
• Lead QA efforts on several projects
• Developed SSRS reports, Dashboards, Scorecards, KPIs having Drill Downs and linked reporting, data visualizations as well as detail tabular data with multiple pages.
• Used TFS to track the QA issues and to manage application code.

Environment: SQL Server 20012, 2008R2, SSRS 2012, 2008R2, Oracle 10G, SQL Server Management Studio, Excel 2010, Windows server 2008R2, T-SQL, Visio, HP Quality Center, QTP9, SharePoint 2007, 2010, TFS

Data Quality Analyst

Confidential

Responsibilities:

• Worked with business users to understand business terminology and reporting requirements.
• Understood data feeds originating from different sources.
• Validated the source systems data with the staging tables, developed control totals and identified data anomalies by using analytical SQL queries in Management Studio as well as data analysis techniques in excel spreadsheets. Extensively used Sub-queries, correlated Sub-Queries, Group By, Having clause, views, and functions for doing this.
• Developed test cases for weekly sales feeds to validate the source data files. Documented the test cases and test results to communicate to responsible teams for source data as well as data extraction.
• Developed test cases for functional and regression testing.
• Tested Workflow triggered from UI screens.
• Performed software applications testing and participated in UAT during the development phase of the reports.
• Enhanced the test scripts so as to use for production support of the reports.
• Performed user entry validation and stress testing of User Entry screens
• Created test data for various reporting test cases by adding/updating existing data in database using INSERT, UPDATES and some stored procedures to repetitively update the data.
• Retrieved data from UI and validated it against data in tables by writing queries.
• Reverse engineered SQL functions, stored procedures to understand ETL processes in order to develop test plans and test cases.
• Provided additional help to the development team by isolating the data anomalies to T-SQL v/s SSIS codes.
• Performed Smoke and Regression testing using test cases for monthly release cycles with 2 other developers.
• Created defects and coordinated defect fixing with development teams.
• Developed QA Automation Scripts using VB
• Communicated summary of testing status to project lead.
• Participated in test plan review and sign-off meetings.

Environment: SQL Server Management Studio, Visual Studio, Excel 2007, Windows server 2003, MS SQL Server 2005, T-SQL, SSRS 2005, 2008 R2, Visio, HP Quality Center, VB Script, SharePoint 2007, 2010, Clear Case

Data Quality Analyst

Confidential

Responsibilities:

• Analyzed and tested data coming from interfaces. Performed testing on Calendars, Combo boxes etc.
• Analyzed data processing issues in ETL system using complex SQL queries.
• Created test data set for various reporting applications by simulating various test cases.
• Performed GUI testing.
• Developed test cases for new reports and enhancements to existing reports.
• Executed functional test plans and documented results.
• Performed User Entry validation and Stress testing of User Entry screens
• Tested Workflow triggered from UI screens
• Performed positive and negative as well as regression testing
• Verified data in reports against data in tables using SQL queries.
• Maintained defect logs for any bugs found during testing.
• Tested data in Systems Test, Systems integration and UAT environments.
• Coordinated with development teams for resolving identified defects.

Environment: SQL Server 2005, SSRS 2005, SQL Server Management Studio, MS Access 2007, T-SQL, MS Excel 2007 and MS Office Suite

Technical Support Executive

Confidential

Responsibilities:

• Achieving daily, weekly and monthly targets as specified by company policy.
• Knowledgeable customer interaction.
• Customer satisfaction through satisfaction surveys.
• Attending escalation calls along with taking regular calls.
• Conveying the client requirements to the team with regards to the process.

Environment: s: Citrix, Windows XP, Internet Explorer, Solutions Intranet.