SUMMARY

• Around 10 and half years of IT experience with expertise in MS SQL Server 2005/2008/2012 suite of products like SSIS, SSAS, SSRS and SQL Server Data tools
• Experience in programming languages using .Net, C# .Net, ASP.Net, ADO.Net, MVC, AJAX and XML.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience in Data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Good knowledge using Control M scheduling tools for setting jobs for ssis packages
• Extensive experience in working with T - SQL queries (DDL and DML) and writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
• Experienced on Extraction, Transformation and Loading (ETL) process using DTS and MS SSIS application tools.
• Strong Analytics/Data warehouse experience usingSAP Business Objects Data Services/ Data Integrator.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Involved in Analyzing, MSAS Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services (SSAS)
• Experience in using tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Performed installation of SQL Server (to include clustered environment) and applied required patches to development, staging and then to production systems after thorough testing.
• Ensured the integrity and security of data from unauthorized individuals and also performed recovery of lost or corrupt data.
• Proactively monitored database systems to ensure secure services with minimum downtime.
• Extensive experience with Database Backups, Restoration & Disaster Recovery Procedures, Backup strategies and scheduling Backups.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
• Experienced migrating Crystal Reports into SSRS Reports.
• Experience and Expert in Generating on-demand and Scheduled Reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience on Policy-Based Management on SQL servers which includes four major steps those are Selecting Facets, Setting Conditions, Creating, evaluating Policies and Executing the Policy
• Experience in following domains: Health Care, Pharmaceutical Supply Chain, Investment/Banking, Health Insurance, Financial and Telecommunication.
• Excellent team player with good organizational, communication, interpersonal & analytical skills. Possess strong ability to quickly adapt to new applications requirements, processes, platforms and languages.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2010/2012 , Oracle 9i

Languages: C, C++, T-SQL, PL/SQL, ASP.NET, Visual Basic 6.0, VB.Net.

Scripting Languages: HTML, VBScript

Operating Systems: Windows Server 2003, Windows XP.

Tools: Visual studio 2012/2010/2008 , Erwin 4.0/3.5, IIS, SAP BO Data Integrator XIR2/11.7/11.5, SAP BO Data Services 4.0/XI3.2/3.1/3.0

Reporting: SSRS (MS SQL Reporting Service), Crystal Reports XI, Excel

PROFESSIONAL EXPERIENCE

Confidential, Lakeland, FL

SQL Developer, ETL/BI Developer, SSIS, SSRS, System Programmer

Responsibilities:

• Involved in the completeSDLCincluding Requirement Specifications, Analysis, Design, Development using .Net framework 4.5,5.0, VB.NET/C#, MVC, WCF Visual Studio 2012/2015
• Created front end UI for the reports using MVC web by creating views,Reportdetial views, Report controller, layout views and various WCF for landmark Atlas database
• Created various packages for loading landmark database into Atlas data abase by using
• Various kinds of transformations like look up, merge, copy etc. and also using different source and destination connection managers
• Created different kinds of fact tables and dimensions tables like lm tab landmark,facility details and company contacts, project contact tables, LM TAB ACTIVITIES, LM TAB PROJECT DATES
• Wrote complex T-SQL queries, stored procedures, and Views
• Created different types of store procedures for revisions,, remodel and new store data of the Confidential
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Created ETL controller process for controlling the monthly and daily process of loading by using ssis packages and configuration tables
• ImplementedSlowly Changing Dimension(SCD) type 2 to maintain Historical Data.
• Designed Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load. Worked on SSRS extensively to create and design reports.
• Worked with Report Builder to build Ad-hoc Reports.
• Worked on SSRS extensively to create and design reports.
• Worked with Report Builder to build Ad-hoc Reports.
• Created various kinds for reports like drill down, drill through using visual studio 2012/2015 like
• Revision reports, new store reports, remodel reports, submittals reports and landmark reports
• Performance Tune the Stored Procedures, User Defined Functions and long running queries.
• Used Team foundation server (TFS) for storing the store procedures, tables, indexes from development environment and used that for deploying into test and production environment.
• CreatedMaintenance Plansto do Backups, and setup log files to monitor jobs.
• DevelopedUI/Components/Classes/Methods/Functionsfor the application and also Functionalities such as Data retrieval using disconnected record sets, usingADO.NET / ASP.NET /Windows Forms / Web Forms / Server controls.
• Worked in ASP.NET /C# application development environment to use SQL Server Databases as backend database
• Used SQL Server Reporting services for creating, editing and scheduling various reports by using data driven subscriptions and SQL Server Agent

Confidential, Tampa, FL

Database developer Lead

Responsibilities:

• Involved in the completeSDLCincluding Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked ssis migration from orlacle data base to sql server database
• Worked with data analyst and data modeler to design the complete data warehouseSchemausingErwinwith proper relationships defined.
• Worked with data analyst to figure out the business logic that needs to be implemented in the warehouse day-to-day load.
• Profiled data from the source, and transformed the data to meet the user’s requirement.
• Designed and developed theStaging Databaseand loaded from source to staging and from staging to the Destination tables applying different transformations.
• DataCleansingand Data Transformation.
• Analyzed the data to implement incremental load.
• Used different sources likeDB2, Mainframesand Flat Files to Extract Data.
• Extensively worked on Stored Procedures, Functions inT-SQL.
• Used sysdts log table and configuration files in the packages.
• Used Tabular andMatrix ReportsLayout to design reports, based on the requirement.
• Created Dashboards and KPI’s using SSRS.
• Worked on SSRS extensively to create and design reports.
• Worked with Report Builder to build Ad-hoc Reports.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• UsedSQL Profilerto trace Performance of Queries and to index the Tables.
• Involved in analyzing different modules of facetssystem andEDIinterfaces to understand the source system and source data.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatics Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatics Designer.
• Worked extensively on theQuery studioand canned reports to carry out theUAT.
• Successfully did the GO-Live for loading of the CVS data of 10 million records into the Facets.
• Worked on theETL documentationfor the packages.
• Experience with Tivoli job scheduling
• Extensively usedJoinsandsub-Queriesto simplify complex queries involving multiple tables
• Attended functional testing anduser acceptancesessions and worked on the feedback provided by them.

Confidential, Horsham, PA

SQL/ETL Developer

Responsibilities:

• Worked on SSIS migration packages for loading orcs(checks data) and claims daily and monthly data into the database by using various transformations
• Involved in loading bulk data from CDW tables and files data into the ocrs bill line history fact tables by using store procedures
• Created linkage process by linking the claims data to the premium tables for pulling the data for
• Various columns like service from date, servicecerteffectivedate, genederidPremiumdueageid, planbenmodskey etc.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Wrote complex T-SQL queries, stored procedures, and Views.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.
• Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Created ETL controller process for controlling the monthly and daily process of loading by using ssis packages and configuration tables
• Proficiency in data warehousing techniques forSlowly Changing Dimensionphenomenon, surrogate key assignment and cƒhange Data Capture.
• Extensively usedData Services Management Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations usingMDX.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries withMDX, Data Mining Models, developing reports usingMDXand SQL
• Created various kinds of reports like Parameterized reports, drill down, drill through and sub reports for monthly and quarterly sales of claims data reports using ssrs and tableau, Qlickview
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool

Confidential, Lakeland, FL

SQL/ETL Developer

Responsibilities:

• Involved in the Database design (Logical Data Modeling and Physical Data Modeling) of the system
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote Teradata Macros and used various Teradata analytic functions.
• Experience in converting SQL 2005 SSIS packages to 2012 SSIS
• Migrated almost 40 to 50 packages from oracle data bases to sql server databses
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Worked on database normalization forms like 1NF, 2NF and 3NF using T- SQL and SSIS packages.
• Wrote complex T-SQL queries, stored procedures, triggers, cursors and user-defined functions.
• Loaded Claims,Drugs,Providers data into the databases using ETL framework by using SSIS packages and store procedures
• Loaded and maintained the raw data in master stage database and cleaned up this raw data in master data database and finally created dimensions and fact tables in Edwdata database for all the member data, Providers data, drugs data and claims data.
• Created views for users and store procedures for loading the drugs, providers and claims data by using ETL framework and also created SSIS setting and date base admins tables for maintaining the ETL framework
• Developed different dynamic store procedures to load member and claims data from more than 60 different client’s files daily and some of them are weekly using bulk import process and SSIS packages.
• Worked in transferring the data using various kinds of packages like unzip, decrypt, moving files packages
• Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
• Extensively used System Variablesand creatingUser-Defined VariablesforSSISPackages.
• Organized Error and Event Handling by giving Precedence Constraints, Break Points, Check Points, Logging and viewers also.
• Documented Informatica mappings in Excel spread sheet.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Experience with Tivoli job scheduling
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purpose using SSAS.
• Defining relationships betweenDimensionsandMeasure groups. Involved in the design and development of the SSAS cubes andMDXqueries
• Design and implementation of tables, stored procedures, triggers, views, SQL statements for database operations using ADO. NET.
• Data Access layer is implemented usingADO.NETto Communicate with theSQL Server Databaseand to access, update the data in the database.
• Created various kinds of reports like Parameterized reports, drill down, drill through and sub reports for their weekly, monthly and quarterly sales of pharmacy and claims data
• Used SQL Server Reporting services for creating, editing and scheduling various reports by using data driven subscriptions and SQL Server Agent
• Worked on various reports like drill down, drill through reports,paramterized reports using ssrs and c
• Performed unit test after each product build and also regression test for every existing code.

Confidential, FL

SSIS Developer Lead

Responsibilities:

• Will responsible for developing tools for reporting tool in support of Enterprise Data warehouse.
• Extensive knowledge of usingPackage Configuration wizardto configureSSISpackages.
• Experience in converting SQL 2005 SSIS packages to 2012 SSIS
• Experience in writing script tasks using C# in ssis packges
• Responsible for designing and implementing SSRS Reports(SQL Server Reporting services)
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2010/2012. Extensively worked in sorting the data, defining subtotals for the reports
• Performance Tune the Stored Procedures, User Defined Functions and long running queries
• Wrote complex SQL queries, stored procedures, triggers, cursors and user-defined functions.
• Transferred the MS Excel Sheet Reports into SSRS based reports by migration the data by using SSIS packages and then Use views and tables and stored procedures to develop new reports.
• Created Excel for generating reports to state of Florida format using macro in excel by writing VBScript code.
• Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Created Parameterized reports, Linked reports, Snapshot reports, Cached reports, Ad hoc reports, drilldown reports, Drill through reports and sub reports
• Worked with Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin
• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases
• Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet reporting needs.
• Used Team foundation server (TFS) for storing the store procedures, tables, indexes from development environment and used that for deploying into test and production environment.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Experience with Tivoli job scheduling
• Experience in using ServiceNow database and execute that report in real time.

Confidential, Jackonsville,FL

SQL/ETL Developer

Responsibilities:

• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Merged Data from Heterogeneous Data stores and Legacy System implementing SSIS on the System.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Good experience in writingMDXqueries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Participated in to Design ETL architecture and processes for near real time loads of insurance and policies related record from different locations. Successfully met challenges of very high volume (over Three million rows a day), dependency on multiple source data feeds, short ETL time windows..
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the problems.
• Migrated and Converted Crystal Reports into SQL Server Reporting Services (SSRS) by using MS SQL Server Reporting Services.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Imported XML data file and put into the desired database.
• Used XML Queries after debugging of SSIS packages and to modify XML Queries written in XML.
• Optimized the performance of queries by Data Manipulations which includes modifications in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Installed and configured SQL Server 2005, SQL Server Integration Services and SQL Server Reporting Services which were highly efficient to Monitor the Central console and SQL server Instances and detecting problems before affecting transaction of Online users.
• Worked on shell scripting by writing various commands using kshell, Bourne shell (SH).
• Deployed SSIS and SSRS, which helped connect its disparate data sources that range from legacy mainframe data to multiple clusters of database server in different format.
• Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet reporting needs.

Confidential, Seattle,WA

SQL Server Developer

Responsibilities:

• Installed and Configured Confidential SQL Server 2005/2008 and Confidential CRM
• Worked on cross platforms like SAS (Statistical Analysis System) to SQL server, Transformed the SAS Macros to SSIS.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
• Developed, monitored and deployed SSIS packages.
• Worked in transferring the data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing the ETL operations
• Utilized Integration Services (SSIS) to produce a Data Mart for reporting.
• Extensive knowledge of usingPackage Configuration wizardto configureSSISpackages.
• Expertise in creatingPropertyExpressions,Script TasksforSSISpackages
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated Services
• Implemented SSIS data, created maintenance procedures and provided data integrity
• Worked in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Involved in Analyzing, MSAS Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services (SSAS)
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Implemented Snow Flakes Schema and Star Schema
• Worked with Development teams in relation to application tuning and Performance tuning
• Involved in the Database design (Logical Data Modeling and Physical Data Modeling) of the system and worked with tools like ER Studio 8.5
• Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS 2005. Extensively worked in sorting the data, defining subtotals for the reports
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies and formatted the reports using the Global variables and expressions.

Confidential, Los Angeles, CA

SQL Server Developer

Responsibilities:

• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created SSIS packages to export data from Oracle to SQL Server Database.
• Rectifying and performance tune the diamond data feed process. Debug, Performance tune and enable the DTS packages for error logging. After tuning the DTS packages now take minutes rather than hours load the same amount of data.
• Backing up system & other databases and restoring them as per requirements.
• Developing, deploying reports using SSRS.
• Applying various release from time to time.
• Performance Tune the Stored Procedures, User Defined Functions and long running queries.
• Used SQL Server Reporting services for creating, editing and scheduling various reports
• Involved in the migration of databases from MS SQL 2000 to MA SQL Server 2005.
• Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views and SQL Joins and other statements for various applications.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Configure Permission for the Distribution Agent and created subscription.
• Monitored the Publication and Subscription and Verified that Changes at the Publisher are replicated to the Subscriber.
• Prepared documentation for the SQL Server 2005 Replication.
• Created backups and restore of database and schedule to run.
• Experience with TWS job scheduling

Confidential, Buffalo, NY

SQL Server Developer

Responsibilities:

• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Gathered the Data from Heterogeneous Data Sources and Legacy System implementing SQL Server 2005 and SQL Server Integration Services (SSIS) on the System.
• Installed and configured SQL Server 2005, SQL Server Integration Services and SQL Server Reporting Services.
• Migrated Data from MS Access, MS Excel to SQL Server 2005 by using SQL Server Integration Services (SSIS).
• Wrote complex T-SQL queries, stored procedures, and Views.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.
• Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow Tools and Data Flow Tools and then verify it.
• Possessed Expert knowledge in creating Indexed Views, complex Stored Procedures, user-defined Functions, and effective Triggers to facilitate data manipulation and consistency.
• Transferred the MS Excel Sheet Reports into SSRS based reports by migration the data by using SSIS packages and then Use views and tables and stored procedures to develop new reports.