SUMMARY

• About 7 years of SQL experience with in SQL Server Suite of products (SSRS/SSIS/SSAS) and involved in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Experience in MS - SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Good Knowledge of data warehousingtechniques and standards.
• Experience in Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, and Bulk Copy Program (BCP).
• Experience in Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Created email subscriptions for data driven reports by using Report Manager.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Skilled at training users to use Query Studio and Analysis Studio, Cognos Workspace
• Perform activities like, Data Modeling, Data Integration, Data profiling, Data Mining, Data Mart
• Used Performance Monitor/Profiler to solve dead locks/long running queries.
• Worked on analyzing and performance tuning queries by looking at Query Statistics and Execution plans.
• Experience in writing complex SQL queries involving multiple table inner and outer joins, temporary tables, table variables.
• Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET, C#. allowing application development organizations to work on several versions of software simultaneously Strong technical knowledge in Troubleshooting and Performance tuning.
• Created views to facilitate easy viewing implementation.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in using variables, expressions and functions for the reports.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2014/2012/2008/ 2005 , Oracle, MS Access.

Operating System: Windows 2007/2003/2000 , UNIX.

DBA Tools: SQL Server Management Studio, SQL Server Business Intelligence Studio, Query Analyzer, SQL ProfilerReporting Tools Reporting Service (SSRS).

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio

Programming Language: C, C++, T-SQL, and Visual Basic, C#.Net

Utilities/Applications: UML, MS-Word (2010), MS-Excel (2010), MS-PowerPoint (2010).

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

SQL Server Developer

Responsibilities:

• Involved in installing and maintaining MS SQL Server 2008/2012/2014.
• Design and develop various SSIS package, using script task, data flow task, conditional split, execute sql task.
• Developed SSIS packages which has header and footer with increment sequence number.
• Design and developed SSIS package to extract data for members and providers from SQL server to flat files. Modified packages from old version .
• Modified SSIS package to load millions of rows by breaking one flat file into multiple small flat file.
• Defined logging and dynamic configuration of the package using sql server 2012 data tools.
• Create various SSIS catalog and sql server agent job script in order to deploy package into SQL server 2012 SSIS server.
• Created various Implementation plan which involves step by step process of deploying various project.
• Fixed old stored procedure by improving performance and applying new logic to it.
• Design and develop History table in order to get daily extract
• Created numerous ordinary to complex queries involving multi-table joins, Union, Correlated.
• Tuned and optimized queries by altering database design, analyzing different query options and Indexing strategies.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Creating Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
• Created reports from various migrated data sources into simple dashboards for easy reviewing.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Developed, deployed, and monitored SSIS Packages.

Environment: SQL server 2014, SQL server 2012, SQL server data tools 2010, SQL Server Management Studio, SSIS, SSRS, Microsoft Visual studio 2013

Confidential, Charlotte, NC

SSIS and SQL Consultant

Responsibilities:

• Involved in designing Enterprise Data warehouse and Data Marts.
• Worked with end user and Business Analyst for various requirements.
• Design TSQL queries based on business requirement which required lot of complex calculations.
• Created SSIS packages to load the dimensions and reference tables onto ODS.
• Created SSIS packages in such a way that they can be dynamically deployed into development, Testing and Production Environments.
• Involved in creating ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created SSIS packages in such a way that they can be dynamically deployed into development, Testing and Production Environments.
• Created ETL SSIS packages both design and code to process data to target databases
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
• Designed and implemented various Materialized Views in Oracle to use in Cognos Reporting.
• Developed OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards.
• Used Cognos Event Studio to manage scripts, cubes refreshes, report runs and notifications.
• Designed and implemented various Materialized Views in Oracle to use in Cognos Reporting.
• Experience in extracting data from EDI files and populating database.
• Used various control flow tasks like FTP, Bulk insert task, transfer job task etc. and different data flow tasks.

Environment: T-SQL, PL/SQL, MS SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Oracle, Cognos 8.4/8.3/8.2

Confidential - Columbus, OH

SSIS and SQL Consultant

Responsibilities:

• Created Stored Procedures, Views, Triggers, User defined Functions and scripting Complex T-SQL logics for business logics.
• Importing file exception reports after the missing data is recovered by the data entry team.
• Re-processing the complex T-SQL scripts to update the data in Staging Purchase History table and Purchase History table.
• Validation of the scripts and to check in the scripts like tables, views and stored procedures in to TFS.
• Created stored procedures, Functions, Triggers, Cursors and SQL scripts Using SSMS.
• Optimizing the T-SQL script using the estimated execution plan based on the cost of the steps and indexes.
• Cleaning, fixing the data which is incomplete and identifying the various exceptions in the received data.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Expertise in Backup configuration, monitoring and tuning.
• Worked on File integrity validation, Data integrity validation and Data quality analysis.
• Created SSIS packages with which data resources such as Flat files, Excel files, were loaded daily in order to create and maintain a centralized data warehouse.
• Created Complex SSIS packages using various transformations provided by SSIS such as data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Created different types of Reports such as Cross-Tab, Drill-down, Summary, OLAP, Sub reports and formatting those using SSRS.
• Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates.
• Assisting the data entry team when needed and pulling the required data from various tables using complex T-SQL queries.
• Worked on the completeness check, roll back check in fixing and cleaning of the data.

Environment: MS SQL Server 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2008/2010 OLAP.

Confidential, Dallas, TX

SQL Server Developer/ BI Developer

Responsibilities:

• Created complex SQL codes using Views, temporary tables, triggers and stored Procedures.
• Expertise in tuning T-SQL procedures, triggers and other database objects.
• Expertise in designing DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Designed and developed DTS packages for transferring data from flat files and Access files.
• Experienced in various stages of SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Upgrade enhancements, maintenance, support and bug fixing for the product.
• Involved in converting SQL Server 2005 DTS packages to SQL Server 2008 SSIS packages.
• Created various packages for performing ETL process using SSIS.
• Programmed SQL Server 2005 Reporting Services using Microsoft Visual Studio 2003.
• Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2005.
• Created database objects for improving the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Involved in creating SQL reports.
• Created cubes and dimensions using SSAS.
• Maintained all SQL documents including installation and data conversion Procedures, standard security documents, etc.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.

Environment: T-SQL, SQL Server 2005/2008, Windows 2000 Server, Query Analyzer, MS Access 2000, Oracle, DTS, OLAP Services.

Confidential

SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Actively involved in the complete software development life cycle for a design of database for new Financial Accounting System.
• Successfully implemented the physical design of the new designed database into MSSQL Server 2008/2005.
• Used MS SQL Server 2008/2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services, system events support and billing.
• Stored Procedures and Functions were optimized to handle major business crucial calculations.
• Set up SQL Profiler to trace various Database activities, application Responses and Performance tune them.
• Implementation of data collection and transformation between different heterogeneous sources such as flat file, Excel and SQL Server 2008/2005 using SSIS.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Defined Check constraints, rules, indexes and views based on the business requirements.
• Documented the database design and developed data dictionary for databases.
• Managed the historical data in the data warehouse from various data sources.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Designed and deployed Reports with Drop Down menu option and Linked reports
• Developed drill down and drill through reports from multi dimensional objects like star schema and snowflake schema using SSRS and performance point server.
• Created subscriptions to provide a daily basis reports and managed and troubleshoot report server related issues.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS).

Environment: MS SQL Server 2005/2008, SSIS, SSRS, Microsoft.NET, MS Office Access2003, Excel, Erwin.

Confidential

SQL Developer

Responsibilities:

• Involved in installing, configuration and maintaining MS SQL Server 05/08 and Clients.
• Design and create SQL Database, and sql objects like tables, indexes, and views based on user requirements.
• Implemented Domain and Referential integrity constraints like Primary Key, Foreign Keys Check and Not Null/Null
• Created indexes and implemented optimizer fill factor for all tables.
• Create and Modify User Defined Functions, Stored Procedures, Triggers, Views according to the business requirements.
• Worked with the developers and provide necessary SQL Scripts using T-SQL.
• Design of ETL processes to transfer customer related data from MS Access, Excel to SQL Server.
• Prepare documentation related to database design, objects security and rules.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.

Environment: MS SQL Server 2005/2008, Windows 2000/NT, Enterprise Manager, Query Analyzer, SQL Profiler, MS Access.