SUMMARY

• Around 5 years of MS SQL Server Development experience in Finance, Telecom, and HealthCare and Insurance domains with expertise in MS SQL Server 2000/2005/2008/2012/2014 and suite of products like SSIS and SSRS.
• Extensive experience in using Microsoft BI Studio products for implementation of ETL methodology in data extraction, transformation and loading (ETL)
• Expert in data warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles using Normalization and De - Normalization techniques
• Experienced in whole cycle of DTS/SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.
• Experienced in generating On-demand, Scheduled reports, Adhoc Reports for Business Analysis or Management decisions using MS SQL Server Reporting Services (SSRS)
• Expert in writing Parameterized Queries for generating Tabular reports, Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS and integrating them with SharePoint server
• Strong experience in Performance tuning, and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, SQL joins, Queries, Sub queries, Dynamic queries and Common table expressions (CTEs).
• Worked with several version controls like Visual Source Safe (VSS), CVS, Subversion (SVN), TFS and Red gate
• Understand rules and regulations of HIPAA as imposed during Electronic Data Interchange (EDI).
• Vast experience with bug tracking tools like HP QC, Jira and TFS and good experience in working with agile and waterfall methodology.
• Involved in writing and developing various technical documents such as User Requirements Specifications, Data and Functional flow diagrams, ER-Diagrams, Test case and unit test documents.

PROFESSIONAL EXPERIENCE

SQL Server/BI(SSIS/SSRS) Developer

Confidential, Fort Worth, TX

Responsibilities:

• Analysis/Design, Development of Databases, SSIS packages for migration, SSRS reports for auditing of migrated data.
• Worked with business analyst to design ETL architecture for data migration.
• Designed efficient dynamic SQL to find and load delta records from DB2 system.
• Maintenance and production support of Databases, SSIS packages, SSRS reports.
• Involved in creating technical design documents, process flow diagrams and technical specs, DW artifacts, Data Lineage doc, Deployment scripts and ETL manual and setting up Dev and QA environment for DW.
• Designed Enterprise Operational Metadata data model for audit purpose at enterprise level.
• Designed and Implemented robust ETL template to fit Enterprise Operational Metadata data model and to support all existing and upcoming projects to enhance audit/metadata capturing functionality.
• Involved in various HIPAA and validation for EDI transactions using 820, 834, 835, 837, 270/271, 267/277, 278
• Designed dashboard using SSRS to represent metadata for the migration audit database and developed many other reports for data integrity check between source and target systems.
• Performed reverse engineering to create mapping document from existing legacy applications.
• Coordinated all aspects of the project with other teams, such as Data Architecture, DBA, Quality Assurance, Support, Infrastructure and management.
• Expert in Performance tuning and optimization.
• Communicating status and issues in a clear and professional manner
• Participate in Disaster Recovery Activity, develops improvements for performance, availability and reliability.
• Monitors the flow of data to and from funding sources using EDI or other means as required; reconciles feedback from funders regarding the actual data submitted.
• Design and Implementation of EDI
• Performing code reviews to enforce coding standards, code consistency, use of design patterns and adherence to application design.

BI Developer (SSIS/SSAS)

Confidential, Birmingham, AL

Responsibilities:

• Developed physical and logical structure of the new data warehouse (SQL database) and process work flow by using Visio
• Created several tables, views and stored procedures using SQL Server.
• Developed several SSIS packages and data flow tasks by using SSIS.
• Extracted data from different sources and stored in to SQL Staging tables in BI Staging database.
• Successfully extracted data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
• Strong experience Creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.
• Understand Enrollment processing in the organization, to include Clearinghouse, EDI, Market Prominence, Claim processing system and Data warehousing.
• Wrote T-SQL queries, Store Procedures and used them to build packages and reports.
• Involved in maintaining the Database Backups for the team using SQL lite speed backups, database performance tuning, using migration methodologies for improvement.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Created partition using partition scheme and functions of SQL server to achieve better performance in retrieval of data from database.
• Organized data from a data warehouse into multidimensional cubes with SQL Server Analysis Services (SSAS) to allow the execution of sophisticated reports and complex queries.
• Monitored the CPU usage, IO statistics, Memory usage to identify any OS level performance killers, enabling database level trace for performance test.
• Extensively involved in maintaining and updating the database documentation

SQL Server Developer

Confidential, Albany, NY

Responsibilities:

• Responsible for writing T-SQL Queries, Functions, Stored Procedures using T-SQL, designing and developing various Sales Analysis, KPI's, and Dash Board reports using Microsoft SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS).
• Created several tables, views and triggers using SQL Server.
• Developed several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS 2008, Excel 2007
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the performance.
• Extensively involved in generating reports like matrix, parameterized, Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts and drill through reports using SSRS.
• Managed Roll based and Item level security in SSRS.
• Used Snapshots and Caching options to improve performance of Report Server.
• Designed and implemented user log in and security in SSRS.
• Involved in deployment of various SSRS Reports in Test and Production environments. Also, in charge of production support.
• Compressed data files by removing empty database pages and updating index statistics.
• Configured snapshot replication for reporting, user acceptance test and development servers.
• Designed and implemented user log in and security.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created Perspectives of the cube to simplify the process of browsing for the end users.
• Expertise in creating physical and logical structure of the new data warehouse (SQL database) and process work flow by using ERWIN.