SUMMARY

• Around 8 years of IT experience as an Business Intelligence and Data Analyst Technical consultant.
• Good experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using SQL Server
• Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, ER Diagrams and OLTP and OLAP System Study and Analysis
• Strong technical knowledge inMS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS)
• Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard
• Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Good Data Warehousing concepts including Meta data and Data Marts.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities
• Good knowledge of SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports with thorough knowledge of report service architecture. Table, chart and matrix report using SSRS
• Expertise in writing T-SQL queries using Joins, Sub queries, Stored Procedures, Triggers etc in T-SQL in SQL Server.
• Expertise in writing DML DDL and Transaction queries in T-SQL for MS SQL Server database.
• Experience in checking data quality using SQL/Integration Services, identifying errors and error patterns, and suggesting some data cleansing mechanisms.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Created a wide variety of actionable dashboards and reports, ad-hoc reports, drill-down reports, drill-through reports, tabular reports, matrix reports, parameterized reports, cascading parameterized reports, snap shots reports.
• Migration ofSQL DatabasesfromSQL 2008 to SQL 2016
• Develop, test, and maintain SQL queries, and stored procedures built and with established standards
• Expert in using gauges to track the performance of business fields of interest.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista/7, Windows Server 2003/2003 R2/2008/2008 R2, UNIX

Database Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010, TABLEAU

Languages: T-SQL, XML

OLAP Tools: MS-SQL Server 2012/2008R 2/2008/2005/2000, Oracle 11g/10g/9i/8i, MySQL and MS Access 2003/2000/97

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010

ETL Tools: SSIS, DTS, Import/Export Wizard

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

MS BI Developer/Data Analyst

Responsibilities:

• Responsible to understand the business requirements by doing a complete analysis of the client’s requirements and preparing possible approaches for the requirement accompanied with understanding doc before making the proposed changes.
• Worked with business teams to gain a rich understanding of their business, analytical, and reporting needs, including the identification of critical metrics.
• Analyze health management programs including: data collection, validation and outcome measurement for Qualifications and Accumulations
• Performed Internal data cleansing and data reconciliation analysis
• Created SQL Queries reports to perform Trend analysis in various functional areas of health care management to manage progrogram performance proavtively
• Performed data mapping and transferred data from various sources (Access, Oracle, and Excel) to target database (SQL Server) tables using SSIS
• Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T SQL code and SQL joins to ensure efficient data retrieval
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Performed operations like Datavalidation and error handling
• Worked on Data Ingestion, Data Validation, Ingestion Stored Procedures, created File missing alerts and adhoc requirements for internal team.
• Helped in deploying packages and SQL script to Test and Production Environments
• Involved withData Profilingactivities for new sources before creating new subject areas in warehouse
• Performed complexdata analysisin support of ad-hoc and standing customer requests
• Created, documented and maintained logical & physical database models
• Produce reports for and interface with senior management and internal and external stakeholders
• Handled multiple projects and timelines effectively and communicate risks and issues to manager regularly
• Assisted with training for new hires and lower level Data Analysts

Environment: SQL Server 2005/2008/2008 R2/2012, MS BI (SSIS, SSRS, SSAS), SQL, TOAD, Flat Files, XML, EDI Files

Confidential, Ocean City, MD

Data Analyst (SQL Server, Tableau)

Responsibilities:

• Involved in understanding functional requirements, translation of technical documents and data mappings
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, implementation, testing and support. Involved in dimensional modeling of the data warehouse to design dimensions, facts, Star Schema
• Design and create data visualizations (reports and dashboards) as required to support user stories.
• Analyzed the gatheird business requirements for designing and developing Tableau visualization solutions. working with Data warehouse and Data Marts for performing data operations in EDW
• Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.
• Strong attention to detail, documenting business and technical requirement based on user interviews.
• Defined, executed and interpreted complex/nested SQL queries.
• Wrote SQL queries for data validation of the reports and dashboards as necessary.
• Establish standards and best practices for dashboards and related technologies for the project.
• Manage a repository of re-usable data visualization templates and views.
• Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designs visualizations for initial concepts and prototypes dat can be presented to customers for feedback
• Worked closely with a team of technical and non-technical staff and consultants to iterate thru versions of the deliverables.
• Designed complex Tableau analytical dashboards featuring (Cascading Filters and Parameters)
• Extracted data from multiple sources including (Excel, SQL, CSV, XML, etc.)
• Designed Schema using dimensions, fact, logical, physical, alias and extension tables.
• Created calculated fields, Parameters, Filters to develop user-friendly, interactive and actionable reports and dashboards.
• Involved in publishing of various kinds of live interactive data visualizations dashboards reports and workbooks from Tableau Desktop to Tableau servers.

Environment: SQL Server 2005/2008/2008 R2/2012, ERWIN 4.0, SSIS, SSRS, Visual studio 2008, Visio, MS Excel 2007, XML

Confidential, Birmingham, AL

Data Analyst

Responsibilities:

• Involved in Technical decisions for Functional requirements, Data Mapping, Data Dictionary, Interaction with Business Analysts, Client team, Development team.
• Understanding the various complex reporting requirements of the company and creating web reports using Reporting Services.
• Implemented the logical design to the physical design by creating tables.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored Procedures, Functions, Triggers, Constraints, Indexes, Views, Rules, Defaults and complex SQL statement.
• Analyze source system data to determine the data model and ETL solution dat will meet business requirements.
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, Merge, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup, Row Count.
• Generated a wide array of reports such as Cascading Parameterized Reports, Tabular reports, and Drill down reports, Drill Through Reports
• Created and modified indexes to optimize query performance
• Developed stored procedures and functions to implement necessary business logic for interface and reports.
• Wrote complex T-SQL queries for reporting and data extraction from SQL Server.
• Created report snapshots reports to improve the performance.
• Render reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and manage subscriptions.
• Facilitated production ad-hoc and parameter driven reports using Microsoft T-SQL, SSRS and communicated project status to management as well as clients on a regular basis.
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by the BI team

Environment: ERWIN 4.0, SQL Server 2005/2008/2008 R2, Visual studio 2008, Visio, MS Excel 2007, XML