SUMMARY

• Over 7 years of professional IT experience in MS SQL Server Database Design, Development, Analysis and Reporting.
• Worked on various environments for installing, updating and configuring SQL server 2000/2005/2008/2008 R2/2012 on operating system Windows 2000/2008 server.
• Professional experience includes array of domains from Banking, Insurance, Mortgage, and Health care to Telecommunication Company.
• Well versed with HIPAA, Facets, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions
• Within those domains, involved as Developer, Consultant, Administrative roles and responsibilities.
• Expert in using designing and scheduling tools like MS Visio, MS Project and source control tool such as Team Foundation Server (TFS).
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Proficient in Using XML related technologies including XSD, XPATH and XAML.
• Conducting User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
• Experience in Designing, Developing and maintaining Web applications using Visual Studio, .NET,C#,VB.NET
• Hands on experience in all phases of SDLC (Software Development Life Cycle) and Relational Database Architectures.
• Good experience in SQL Server 2008/2012 database Development and data migration
• Involved in analysis and also creation of the databases relationships using ER (Entity Relationship) diagrams.
• Extensive experience in Microsoft T - SQL statements (DDL and DML) including features like Temporary Tables, Raking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
• Good Experience in creating database objects like Tables Stored Procedures, Views, Indexes and User Defined Functions consumed at various stages of Migration process, Reports or Data Validation.
• Experience in creating and managing Clustered and Non-Clustered Indexes to improve database performance.
• Good knowledge of Normalization/De-Normalization, Data Design methodology and building Referential Integrity for the relational Database Model.
• Experienced in database administration work such as setting SQL Server Agent jobs for backups
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard and Query Execution Plans.
• Experience in SQL Server installing, Configuration, Performance Tuning, Query Optimization, and Database Maintenance Plans.
• Strong technical knowledge in Trouble shooting and Performance tuning.
• Experienced in extracting, transforming and loading (ETL) data, from different Heterogeneous Data sources like MS Access, Flat File, Excel and Oracle, to MS SQL Server using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
• Involved in migration project of DTS Packages (2000) to SSIS (2005) and troubleshoot any migration issues.
• Experienced in creating Logging, Break Points, Check Points, and use Error Handler in SSIS and automating the ETL process.
• Excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For each Loop Container etc) and various Data Flow Transformations (such as Derived columns, Conditional split, Lookup, Merge Join, Data Conversion.
• Experienced in Deploying SSIS packages using Manifest files and Import/Export Wizard while creating various Configuration Files to make the packages work in various environments.
• Involved with Performance Tuning of SSIS packages.
• Experienced in configuring and maintaining Report Manager, Report Server and Repot Builder for SQL Server Reporting Services (SSRS).
• Knowledgeable about other aspects of reporting service such as Report Authoring, Report Management, Report Delivery and Report Security.
• Well versed with diverse types of reports such as Drill down, Drill through, Parameterized, Cascaded parameterized, Linked, Chart, and Sub-reports using SSRS.
• Assisted in the scheduling the reports to refresh and run on daily, weekly and monthly basis and also deployment of the reports using Direct deployment and Uploading files using the Report Manger.
• Involved in integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and Performance Point 2010 and Dashboards.
• Expertise in data mining concepts like Building Cubes and Dimension Modeling, creating Data Marts, Kimball / Inman Methodologies, Star / Snowflakes Schemas with different architectures and data sources using SSAS.
• Experienced in building cube starting from scratch and their deployment.
• Experienced in performance optimization of SSAS cubes using Partitions, Hierarchies and Attribute Relationships.
• Good knowledge of MDX Scripting to perform various tasks including creating Calculated Members.
• Excellent Communication Skills and proper follow-through on all directives, bulletins and schedules from the Team Lead, And Ability to present the information to the Business Users and partners.
• Able to work effectively in High Pace Environment giving excellent performance and highly capable of working in a Team Environment with a Positive Attitude. And Able to meet tight deadlines and manage competing priorities.
• Sociable, Self-Motivated, Dedicated and Responsible individual with Excellent Work Ethics, Quick Learner, able to adapt well to changes on workplace.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008/2008 R2 and 2012, Access 2000/2003

Languages: T-SQL, MDX, VB Script,C#,.net

Developer Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, DTS Import/Export, Visual Studio 2005/2008, BCP, Team Foundation Server (TFS)

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Reporting Tools: SQL Server Reporting Services (SSRS),crystal Reports

Operating Systems: Windows NT/ 98/2000/2003 Server XP/Vista, UNIX, Linux

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Phoenix AZ

Sr. SQL Developer

Responsibilities:

• Involved in Analysis, Requirements gathering, Development, Testing.
• Analyzed current Claim Authorization Process across all the FACETS Markets. Identified possible constrains that pends claims related to Claim Authorization Mismatch.
• Responsible for creating database objects like views, Store Procedures and Functions etc. Using SQL Server 2008/2012.
• Designed, coded, tested and debugging business logic for software Applications
• Responsible for data analysis and Reporting to management. Used MS Access, MS Excel. MS Visio, pivot tables And V-lookups
• Worked with Clients for more efficient solutions in T- SQL using SQL Server 2012.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Worked with Business Analysts and users to understand the requirements.
• Implemented logical design into Physical design.
• Involved in the normalization of databases in the OLTP.
• Used different kinds of joins to join more than 24 tables.
• Improved performance of the SQL Queries and stored procedures using SQL profiler and Index tuning advisor.
• Created and involved in the Creation of around 168 packages to load data into Production server. Created one table to execute all packages in the sequence order.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations using SSIS 2012.
• Experience in SSIS Script Task, Look Up Transformations and Data Flow Tasks using T- SQL and (VB) Scripts.
• Provided on call support for production and development servers.
• Created Stored Procedure and used these procedures in the SSIS Packages to improve performance.
• Created and reorganized the indexes at regular intervals for better performance.
• Tested all Stored Procedures on testing environment.
• Involved in Developing the .NET components and ASP.NET Web form applications like Company website as well as code samples for fellow staffers.
• Maintained the table performance by following the tuning tips like normalization, creating indexes Optimized and tuned the SQL Queries.

Environment: MS SQL Server 2008R2/2012, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS), MS Office 2010, MS Visio 2007.

Confidential, Westhils CA

MS SQL Developer

Responsibilities:

• Analyzed business needs and developed Technical Specifications based on interaction with Managers and Development Teams.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• In Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008/2012.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Extensively used DML scripts to perform modification tasks like Insert, Update and Delete data in database tables.
• Developed Many Excel Reports like Pivot Table, chart Reports for Data manipulation.
• Created Macros to automate moving and formatting data, and Macros to run financial formulas behind the Scene.
• Involved in extensive DATA validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
• Wrote C#,VB.NET Code for Script Task in SSIS 2008
• Also responsible for transferring data from Production Server to the Development Server occasionally on Incremental Basis for the purpose of checking the consistency in data.
• Used the WCF services as the major component in communicating with the data access layer.
• Implemented WCF Web service for Integration with other Inbound Applications using .Net 4.0, C#, WCF ADO.Net Entity Framework, XML, XSLT, SOAP and SQL Server 2008.
• Created Rest Web Services to communicate between SOAP Web Services and UI.
• Implemented MVVM, consumed WCF services for presentation layer using C#, Visual Studio2010
• Involved in Development of data access, business and Application layer using LINQ,C# AND ASP.NET
• Developed Console Application using C# Link Entity Framework.

Environment: MS SQL Server 2008R2/2012, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (SSIS, SSRS, SSAS), MS-Visual Studio, XML, MS Office 2010, MS Visio 2007, Team Foundation Server.

Confidential, Los Angeles CA

SQL BI Developer

Responsibilities:

• Installed SQL Server 2008 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2005 to SQL Server 2008 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2008 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
• Created jobs and scheduled jobs using SQL Server Agent.
• Deployed code into the production environment. Provided 24/7 production support for the production database

Environment: MS SQL Server 2008R2, SQL Server Management Studio (SSMS), SSIS, SSRS, SQL Query Analyzer, SQL profiler, XML, MS Office 2010, MS Visio 2007, ERWIN Data Modeler.

Confidential, Dublin, OH

Sr SQL Developer

Responsibilities:

• Worked with Business Analysts and users to understand the requirements.
• Involved in installation and Configuration of SQL server 2008.
• Involved in developing logical and physical modeling of the database using Erwin.
• Highly used T-SQL for developing complex Stored Procedures, Triggers and User Defined Functions, Views, Indexes.
• Used SQL Profiler, System Monitor, Query Analyzer for Troubleshooting, Monitoring, Optimization and Tuning of SQL Server.
• Developed a customer data warehouse to understand customer behavior to various Claims related programs and identify critical customers in support of improved decision-making across the organization.
• Fine-tuned long running claims reports.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) packages and also modified the packages accordingly using the new features of SQL Server Integration Services.
• Created SSIS packages using various Transformations for export data from different data sources and Transformed data and load it to SQL Server 2008.
• Improved the Scalability and Manageability of large tables by creating Table Partitions and maintained Data Consistency and Data Integrity by applying various constraints like Primary Key, Foreign Key, Unique, Check, and Default.
• Implemented error handling and roll back process in SSIS Packages.
• Used SSIS package Configuration, changing the variables dynamically and SSIS logging.
• Built MDX queries for Analysis Services & Reporting Services.
• Worked on claims processing reports on investigation and payment
• Developed Claims reports that would produce Excel outputs for users
• Responsible for gathering/refining requirements from the customer for developing reports.
• Responsible for Full Report cycle including Authoring, Managing, Security and Generation of reports.
• Developed Query for generating drill down, drill through, parameterized, cascaded reports in SSRS 2005.
• Backing up, Restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Worked on database security, Replication and Log shipping activities.
• Designed Web-based ASP.NET and C# Internet applications linked to firm wide SQL Databases.
• Involved in Developing the .NET components and ASP.NET Web form applications like Company website as well as code samples for fellow staffers.
• Wrote C#, VB.NET Code for Script Task in SSIS 2008.
• Set Physical Security of SQL Server, to prevent unauthorized users from accessing the servers.
• Created Master SSIS packages in order to execute a set of packages on a timely basis and deployed those packages using Manifest Files and Import/Export Wizard so that the packages were available for use to other team members.
• Employed many Slowly Changing Dimension methodologies to maintain and update historical data.
• Designed and implemented a variety of SSRS reports such as Parameterized, Drill Down, Drill Through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements using both Tabular and Matrix report formats.

Environment: MS SQL Server 2008R2/2008, SSMS, SSIS, SSRS, SSAS, Windows 2003 server, DTS, SQL Query Analyzer, SQL profiler, Crystal Reports, Visual Studio 2005, XML, C#,ASP.Net, ERWIN Data Modeler, MS Visio 2007, MS Office 2003.

Confidential, Dublin, OH

MS SQL BI Developer

Responsibilities:

• Involved in FACETS Implementation Testing, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Validated EDI Claim Process according to HIPPA compliance.
• Analyzed the requirements and selected the dimensions based on the analysis requirements.
• Designed Tables, Constraints, Views, and Indexes, and created the Cubes for Business Intelligence.
• Involved in writing Test Plans for SQL Stored Procedures and User Defined Functions.
• Created Views to facilitate easy User Interface Implementation and Triggers on them to facilitate consistent data entry into the database.
• Developed the ETL Process to load the data from the mainframe production databases to the Oracle database models.
• Involved in High-Level Documentation for SQL Server Database Design, Periodic Data Refresh, and Database Upgrades.
• And finally set standard, guidelines, and best practices based on the documentation.
• Executed Database Tuning, Performance Planning, Back Up Planning, and Database Administration.
• Participated in the Normalization and De-Normalization of database along with creating and managed Clustered and Non-Clustered Indexes to improve database performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of the database servers.
• Designed SSIS packages dynamically that could run on various Environments by creating XML and SQL Server Configuration Files.
• Experience in SSIS Script Task, Look Up Transformations and Data Flow Tasks using T- SQL and (VB) Scripts.
• Developed OLAP model based on Dimension and Facts for efficient loads of data mainly based on Star Schema.
• Created the New Dimensions, Shared Dimensions, and Time Dimensions and implemented those dimensions while generating Cubes from SSAS.
• Hold responsibility for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX Queries, Perspectives, KPI’s, Scorecards and Dashboards.
• Created Partitions and designed various Storage Modes to increase the performance of cubes using SSAS.
• Involved in Scheduling, Creating Snapshots, Creating Report Subscriptions and Data Driven Subscriptions.
• Developed MDX Scripts to create datasets to generate various reports which included Interactive Drill Down Reports and Report Models.
• Documented all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, TSQL, Business Intelligence Development Studio (SSRS/SSIS/SSAS), Oracle 9i, XML, Windows 2003 Server, Microsoft, SQL Profiler, OLAP

Confidential, Ann Arbor MI

MS SQL Developer

Responsibilities:

• Worked with various teams like Business Stakeholders, Business Analysts, Application Developers, and Production Teams to identify needs and followed by solution options.
• Installed SQL Server 2008 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2005 to SQL Server 2008 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2008.
• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2008 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.
• Created jobs and scheduled jobs using SQL Server Agent.
• Deployed code into the production environment. Provided 24/7 production support for the production database
• Coordinated with the functional team and designed various types of reports as per the business needs.
• The report types included Drill Down, Drill Through, Parameterized, Linked, Sub-reports and Ad-hoc reports.
• Created Cascaded Parameters for reports as per business and customer requirements in order to allow convenient filtering of the contents.
• Worked on Dimensional modeling using Star Schema and Snowflakes Schema mostly adhering to Star Schema.
• Constructed cubes, starting from scratch, using SSAS based on data volumes used in ad-hoc analytic research and Automated Reporting.
• Optimized the performance of cubes by creating reasonable Partitions, defining proper Hierarchies and setting the proper Attribute Relationships.
• Created a Report Model based on SSAS Cubes, also changing Default Configuration on existing cubes.
• Implemented Key Performance Indicators (KPI) in order to identity the performance of the application and displayed those KPIs in the Dashboard.
• Creating Sub Cubes and Perspectives to allow/restrict users to view data depending on the departments they belong to.

Environment: MS SQL Server 2008/2005, Windows Server 2003, SQL Server Management Studio, Business Intelligence Development Studio (SSIS, SSRS, SSAS), MS-Visual Studio.

Confidential

Software Developer

Responsibilities:

• Actively involved with the front end .Net Developers as a part of a team for gathering and analyzing the needs of User Requirement.
• Written complex T-SQL queries for back- end data validation and testing.
• Tuning SQL Scripts for better performance in SQL Server 2005.
• Developed a web application using C#, LINQ Entity Framework, and WCF and PHP.
• Used the WCF services as the major component in communicating with the data access layer.
• Implemented WCF Web service for Integration with other Inbound Applications using .Net 2.0, C#, WCF ADO.Net Entity Framework, XML, XSLT, SOAP and SQL Server 2005.
• Created Rest Web Services to communicate between SOAP Web Services and UI.
• Used Data Annotations for validation.
• Implemented MVVM, consumed WCF services for presentation layer using C#, Visual Studio
• Created dynamic web interface layouts using ASP.NET, MVC 3 Framework, JQuery, JavaScript, C#, HTML, LINQ, and Razor View Engine.
• JSON format is used for serializing & transmitting structured data over network connection.
• Developed some UI modules using Jquery, AJAX Library, CSS and JavaScript.
• Extensively developed Stored Procedures, and Functions in SQL Server 2005.

Environment: MS SQL Server 2005/200,ASP.NET,C#,VisualStudio SSIS, DTS, MS Visio, XML, SSMS, ERWIN Data Modeler, DBCC.