SUMMARY

• A Microsoft Certified Professional with 8+ years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Experience in maintaining one to many and many to one relationships while moving data between two databases.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in writing TSQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Supported team in resolving SQL Reporting services and TSQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• IOS Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C# in script component of SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writing parameterized queries, drill through reports andformatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Proficient in Data warehousing and SSAS skills: MDDB/MDX, KPIs, CalculatedMembers, OLTP, OLAP (MOLAP, HOLAP, and ROLAP), Relational and DimensionalModeling skills (star schema and snowflake schema).
• Performance Oriented in Developing and Extending Cubes, Dimensions and DataSource Views, Data Mining Models, and Deploying and Processing SSAS Objects.
• Experience in writing TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Worked with report manager for deploying the reports across all the environments.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions with SSAS.
• Expertise in creating Aggregations, partitions in cubes using SSAS.
• Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Strong experience in SQL database design, architecture, data modeling (conceptual, logical and physical) using Erwin
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008/2014.
• Knowledge on Azure SQL Databases and Azure SQL DataWarehouse.
• Knowledge on PowerShell scripts for automating tasks and importing the content changes related to application.
• Strong work experience asBusiness Objects Developer.
• Knowledge on Oracle Data Integration Tool(ODI).
• Knowledge on Oracle 9i and PL/SQL
• Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies

TECHNICAL SKILLS

Operating Systems: Win 2000/NT/2003/2008 server.

RDBMS: MS SQL SERVER 2014/ 2012/2008/2005/2000, MS Access, Oracle8i/9i.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005, Query Editor,Reporting Server, Ms-Access.

ETL Tools: Data Transformation Services (DTS), MS SQLServer Integration Services (SSIS),IBM AS/400,Informatica,ODI(Oracle Data Integration).

Reporting Tools: Crystal Reports XI/X, MS SQLServer Reporting Services (SSRS).

Data Modeling: ER-Win 4.0, MS Visio 5.0.

BI Tools: MS SQL Bussiness Intelligence, Business Objects.

Programming Languages: Unix,C#, VB,XHTML and XML.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL-Developer/DBA

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2014(BIDS) andCrystal Reports.
• Provided all configuration details, including the product version, product level, engine edition, database file sizes, and CPU and memory resource, of all the SQL Server 2005/2008 accounted for migration.
• Granted DB access to users following the security standards
• Coordinated with the application teams and performed backups of SQL Server 2005/2008 Involved in Migrating Crystal reports to SSRS Reports.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Createdparameterized reports, Drill downandDrill throughreports using SSRS.
• Write TSQL Scripts for database backup jobs and daily/weekly jobs.
• Involved in creating multiple parameterized stored procedures, which were used by the reports to get the data.
• Installation and Maintenance of SQL Server 2008 R2/2005 on Test, Development and Production Environments.
• Created and Maintained Databases across Development and Production Instances.
• Loading data from various sources like OLEDB, flatfiles, MS Access to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Experience in Performance Tuning in SSIS packages by usingRow Transformations, BlockandUnblock Transformations.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Createdindexeson selective columns to speed up queries and analyses in SQL Server Management Studio.
• Involved in automatingSSIS Packages usingSQL Server AgentJobs, Window Scheduler.
• Involved in Monitoring and troubleshooting complex packages by usingData Viewers Grids.
• Write TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Creating joins and sub-queries for complex queries involving multiple tables.
• Optimized query performance by creating indexes.
• Used query execution plan to optimize the store procedures to reduce the cost.

Environment: SQL Server 2005/2008/2014 SQL Reporting Services (SSIS), Crystal, Microsoft Windows 2012/2008 R2/2008 Servers.

Confidential, Dallas, TX

SQL-Developer/DBA

Responsibilities:

• Created a new software solution for inhouse need,using TSQL as back end and .net as front end application.
• Even did UAT Testing for inhouse application.
• Developed SSRS ad-hoc reports,Parameterized Reports and subreports.
• Working on SymmetricDS Software and solving the issues occrued on that software.
• Crated database backups and restored the databases.
• Wrote TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Used Background Worker, Multithreading and TPL for implementing parallel processing and printing of returns.
• Provide support out of office hours, during weekends and during major release work to development and customer to help them resolve issues faced.
• Migrating the data using SSIS package.
• Configured and Monitored transactional replication.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Configuring XML files for the application to run the reports.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Troubleshoot problems by checking sessions and workflow logs.
• Created Linked Servers between different Servers in SQL server.
• Database Backup and restores.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Environment: Windows 2007 enterprise, SQL Server 2008/2005,SQL Integration Services(SSIS), Business Intelligence Development Studio, TFS, Symmetric.

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSISin Business Intelligence Development Studio (BIDS).
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Day to day activities including monitoring the jobs and resolving the issues occurred in the job.
• Created ssis package to migrate data between databases.
• Used robo copy to transfer files between databases.
• Write TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Creating joins and sub-queries for complex queries involving multiple tables.
• PowerShell scripts to automate daily administrative tasks.
• Optimized query performance by creating indexes.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used query execution plan to optimize the storeprocedures to reduce the cost.
• Configured and Monitored transactional replication.
• Gathered & loaded data intoQlik Viewfrom various data sources (SQLSERVER 2008, CSV and excel files).
• Supporting the ETL Inbound for the LegacyMDMsolution built.
• Daily routineDBAtasks like handling user's permissions and space issues on Production and Semi-Production servers and handling maintenance jobs.

Environment: Windows 2007 enterprise, SQL Server 2008/2005, SQL Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Source safe.

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Write TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Creating joins and sub-queries for complex queries involving multiple tables.
• Optimized query performance by creating indexes.
• Using DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created several SSIS Packages to pull data from SQL server and Flat files into Excel sheet and to archive the data as per the business logic.
• Requirement gathering and creating mapping specs.
• Created Email Notifications for critical events at database application level.
• Created various SSIS packages which would load raw physical data in to the tables of the databases.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Designed, implemented and maintained UNIX-based custom statistics collection package.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Used spreadsheets for reporting server.
• Developed and tested system maintenance tasks such as Database Backup andRecovery, Database mirroring and replication.
• Implemented Logshipping for Disaster Recovery.
• Created Queries and Packages to use in Merging and to provide access to viewdatain base objects ofMDMHub.
• Involved theMDMTargetdatamodel creation (i.e. creating the base objects).
• Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls.
• Created powerpivot file and power view reports in excel.
• Developed web-based reports, scorecards, and dashboards .
• Created reports with multiple views in power view.
• Strong experience in Data Warehousing and ETL usingSSIS.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Using Team foundation server 2010.
• Assign permission to user(s), role(s) and object. Administrate security for server’s logins (Windows and SQL server account).

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005,Team Foundation Server(TFS),Crystal Reports,Informatica.

Confidential, MN

SQL Developer

Responsibilities:

• In this agile project all tasks are assigned to the team members using the Share point priorityTasks. The tasks are completed as per the priority heirarchy.
• Responsible for development of stored procedures, functions and database Triggers.
• Imported data from Cache Monitor using SQL Server Integration Services (SSIS)packageInvolved in migrating from cache to SSMS.
• Involved in creating stored procedures,Indexes in MS SQL Server environment using 2012.
• Created, indexes,Triggers,Stored Procedures in SSIS Package.
• Created Complex ETL Packages using SSIS to extract data from Cache Monitor to SSMS with execute SQL Task and Incremental Load.and even created and dropped indexes in execute sql task.
• Created SSIS packages for Migrating from one Database to the other using Data Reader Source.
• Used VB scripting in SSIS.
• Access SQL Server using front end applications like VB.
• Writing C# code in SSRS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
• Performed remote and onsite application system design, development and ongoing maintenance on multiple AS/400s
• Responsible for helping in the implementation of various new applications of Kronos Workforce Central application with the use of technical, analytical and functional skills.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Even used special field casting and data conversion in Data Reader Source.
• Wrote PL/SQL packages to calculate Missing Information and Determining Eligibility in the processing of a Medical/Health Families Application.
• Created reports based on the format specified in the design document.
• Involved in creating Sub reports in MS Reporting services(SSRS).
• Passed parameters to the Reports using Report parameter menus.
• Used Deployment wizard for Deploying the Reports.

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005,IBM AS/400.

Confidential, Augusta, Maine

SQL Developer

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSISin Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Prepared the complete data mappingand Report Definitionsfor the project which involved around 33 reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created DTS, SSIS packages and also converted some DTS to SSIS packages.
• Prepared documentation and designed the GUI forms by using VB.Net.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Designed, implemented and maintained UNIX-based custom statistics collection package.
• Used VB scripting in reports and also in SSIS.

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005, OLE DB.

Confidential, Grand Rapids, Michigan

SQL Server/SSIS Developer/SSAS

Responsibilities:

• Implementation of MS SQLServer 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using TSQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008database and configuration of Report manager.
• Responsible for performing TSQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQLServer 2008/2005.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Build scalable and secure database applications in service broker using microsoft sql server 2005.
• Developed, deployed, and monitored Packages using ETL tools Like SSIS .
• Creating complex MDX Queries. Accessing and manipulating data within MDX.
• Working on performance tuning and optimizing MDX queries to reduce the runtime and increase performance and efficiency.
• Expert in creating Star schema cubes usingSSAS.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Performed reliable messaging between SQL server instances using service broker.
• Supported, monitored and tuned Informatica ETL processes.
• Took part in creation of Star Schema and Snowflake dimensional schema in MS analysis services (SSAS).
• Created cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQLServer 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQLServer 2008, Ms Access2007, Office2007, Windows Server 2003.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Performed Database code Migration from SQL Server in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. .
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2000, TSQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.