SUMMARY

• Over 8+ years of IT experience with a strong background in Data warehousing projects administration, development and three years of ETL experience using SQL Server SSIS/SSRS/SSAS.
• Proficient in Installing SQL Server 2000/2005/2008/ R2/2012/2014 and configuration of their tools.
• Solid hands on experience with Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Estimate, schedule and track ETL projects throughout SDLC.
• SQL Server 2000/2005/2008/ 2008 R2/2012 /2014 RDBMS database development including T - SQL programming.
• Good noledge in RDBMS concepts, data models, Star/Snow Flake Schemas.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2012/2008 R 2/2008/2005/2000 , Team foundation server (TFS).
• Expert in TSQL, DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Good understanding of system tables in Oracle 10g and performance tuning them.
• Expert in Dash board Reports, Cascading parameters with using SQL server 2008R2.
• Expert in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in DTS, Bulk Insert, BCP.
• Experience in implementation and support of SQL Server Database Systems, Reporting Services (SSRS), Analysis Services (SSAS) and Integration Services (SSIS) built cubes and drill down reports, partitioned views and large data sets.
• Experience in writing Distributed Queries between SQL Servers.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Very good noledge in scheduling and deploying reports on report manger.
• Experience in creating reports using Report Manager 3.0.
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Extensive working noledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Experience with high level of accountability, demonstrated initiative and innovation and ability to manage competing priorities, varying workload yet still achieve results.
• Self learning ability and Leadership Quality.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Databases: SQL server 2000/2005/2008 R2/2012/2014, MS Access

Languages: Transact- SQL, SQL, HTML, C.

Operating Systems: Windows NT/98/ 2000/XP/Vista/2003, MS-DOS

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL, Informatica.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Microsoft Visio 2000/2003,Altova tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS,Access Manager, Excel, PowerPivot, Power BI, SQL Server2008 Analysis Services and SQL Reporting services, DTS, ProClarity, PPS-2007, MOSS

PROFESSIONAL EXPERIENCE:

SQL Developer

Confidential, Virginia Beach, VA

Responsibilities:

• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Scheduled Jobs to run SSIS package in night feed to ODW for fresh day data.
• Load data form ODW database to Data warehouse using SSIS packages.
• Created sub report and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.
• Successfully did the GO-Live for loading of the CVS data of 10 million records into the Facets.
• Implemented different transformation tools in ETL packages as project requirements, such as slowly changing dimension, lookup, fuzzy lookup, conditional split etc.
• Monitor security batch processing jobs in multi-platform shop via Control-M &Tidal Schedulers.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Created reports to retrieve data using Stored Procedures dat accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
• Working on T-SQL to migrate data into (Facets) application.
• Great ability to create and manage various database objects liketables, views.
• Worked Extensively on ETL process using SSIS package.
• Involved in testing different interfaces and web application forFACETS.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Worked onFACETSData tables and created audit reports using queries.
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience working with scheduling tools in Tidal.
• Development and deploying of theSSIS 2005/2008packages to maintain, update and migrate the data into and from the FACETSapplication database.

Environment: MS SQL Server2005/ 2008 R2/2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Erwin, MDX, MS Visual Studio.NET, Data mart, data warehouse, PowerPivot, Power BI, Office 365, C#, 2008, Team Foundation Server (TFS 2012), XML, TFS (SharePoint), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

SQL/SSRS/SSIS Developer

Confidential,Virginia Beach, VA

Responsibilities:

• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables.
• Monitor security batch processing jobs in multi-platform shop via Control-M &Tidal Schedulers.
• Strong noledge of scheduling and atomizing ETL package execution.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Designed and developed enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Involved in the overall SDLC including inception, elaboration, construction and deployment.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database. Made dynamic SSIS packages which did data scrubbing, including data validation checks.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse and performed action in XML.
• Extensively usedtidal in setting up DTS packages, DM Express tasks and jobs, FTP jobs to run daily, weekly and monthly.
• Filter and Sorting Data usingPower BI in Excel 2013.
• Experience in creating ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Created SSIS packages and transferred them to the appropriate destinations.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages
• CreatedSSISpackagesfordata Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Created SQL server configurationsforSSISpackages.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Developed and implemented Stored Procedures, Views, and Functions.

Environment: MS SQL Server, SSAS 2008, SSRS 2008,2012 SSIS 2008,2012 ProClarity, T-SQL,XML, ETL, Power BI, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Win SQL, SQL Server2000, SQL, Tidal.

San Jose, CA

MS SQL Server/ SSIS/ SSAS/ SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Installed and configured MS SQL Server 2008 along with Visual Studio on a network domain system.
• Worked Extensively on ETL process using SSIS package.
• Tested the reports and fixed bugs in the stored procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Established backup and recovery of SQL server 2008.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Used ADO .NET objects such as data reader, data adapter and dataset to fetch and handle user data with store procedures from SQL Server 2008.
• Created OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Power BI using Excel2012 for Reporting.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Implemented performance tuning of slow running queries and stored procedures using SQL Profiler and Execution plan.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Created SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc. and vice versa.
• Scheduled SQL jobs to run SSIS packages on a daily, weekly, monthly basis using MS SQL Server Integration Services (SSIS).
• Used various control flow tasks like FTP, File System task, for each loop container and data flow tasks.
• Created Excel including pivot tables, macros, and lookup functions to format a data set from the various SQL sources
• Created complex stored procedures, triggers and user defined functions using joins to apply business rules to data imported using SSIS packages.
• Deployed SSIS packages from Dev/Staging/Prod using SQL Server table configurations.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.

Environment: MS SQL Server, SSAS 2008, SSRS 2008, 2012, SSIS 2008, 2012 ProClarity, T-SQL, Visual studio 2008, DTS, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2, TFS

Confidential, CA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Developed stored procedures, functions, views and triggers.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports dat took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: MS SQL Server /2008R2/2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, ADO.Net, OLE DB, DTS Package, SSIS, Windows XP Professional.

Confidential, CA

MS SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in creating highly interactive score cards and Dashboards using Performance Point Server.
• Created ETL packages by extracting data from different sources, like flat files or excel files, and loading data into data warehouse by using SQL Server Integration Services (SSIS) 2005/2008/2008 R2.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005 from different environments for the SSAS cubes.
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in designing, developing, debugging and testing of reports in SQL Server 2005 Reporting Services (SSRS).
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures dat accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Planned a complete backup on the database and restored database from disaster recovery.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008 R2,2008, SSIS 2008, SSRS 2008, SSAS, BIDS, Visual Studio 2005, TFS, Erwin 7.2,MS Office & Windows NT/2003, IIS, Windows, Microsoft .NET framework 3.5

Confidential, McLean, VA

MS SQL Server/ SSAS/ SSRS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL, DML) statements using dynamically generated SQL.
• Designed an OLAP system with the help of ERWIN to visualize data structure.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2005.
• Created ASP.NET web pages and wrote code behind pages using C#.NET.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2005.
• Generated daily, weekly and monthly reports using SSRS 2005.
• Written code for Database connectivity and interaction using ADO.NET.
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Implemented client side and server side validation using java script and ASP.NET validation control.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, Windows Server 2003,Erwin 4.0.

Confidential, Chadds Ford, PA

MS SQL Server Developer

Responsibilities:

• Created Logical and Physical data models using ERWIN data modeling tool.
• Developed complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migration of the data from various sources using DTS.
• Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
• Compressed data files by removing empty database pages and updating index statistics.
• Developed and edited many complex reports with Crystal Reports 10.
• Designed and implemented user login and security.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Planned the complete back-up of databases for disaster recovery scenarios.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
• Reorganized database structures as needed, automated procedures at regular intervals.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in project planning, scheduling for database module with project managers.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, IIS, ASP.NET, Erwin 4.0, Crystal Reports 10

Confidential, Northbrook, IL

MS SQL Server Developer

Responsibilities:

• Developed logical and physical database using Erwin.
• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager on SQL Server 2000 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
• Made sure dat standards and best practices in database development were followed and maintained.
• Implemented client side and server side validation using java script and ASP.NET validation control.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Tuned SQL Statements using Indexes and designed and implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated reports, test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2000/7.0, Windows Server, Windows NT, Erwin, Crystal Reports 9.0