SUMMARY

• Around 7+ years of IT experience in the Analysis, Administrating, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server.
• Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
• Good at writing T - SQL, working on DTS, SSIS, SSRS, Data Cleansing, Data Scrubbing and Data Migration.
• Developing database objects like tables, views, materialized views, synonyms, stored procedures, functions, triggers, cursors, temp table, variables, CTEs and writing dynamic SQL and T-SQL.
• SQL Server 2005/2008/2012 RDBMS database development including T-SQL programming.
• Transferred data from various data sources/business systems includingDB2, MS Excel, MS Access, Flat Filesetc.
• Involved in conversion of DTS to SSIS packages and troubleshooting the Migration issues.
• Worked on reporting services, power view, PowerPivot and power view with SharePoint integration.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
• Experience in migrating from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008.
• Well-versed in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, Send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in Creating Configuration files to deploy the SSIS packages across all environments and also Skilled in Error and Event Handling: Precedence Constraints, Break Points, Check Points and Logging.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Worked on Data modeling, creating star and snowflake schemas in SSAS.
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Creating reports on relational databases and cubes.
• Creating Analysis Services Database, Cubes, Dimensions.
• Experience in working with Microsoft SharePoint.
• Hands on Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R 2/2005/2000/2012 and excellent communication and analytical skills, understands business requirements in various domains.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, VB Script, HTML, XML

Databases: SQL Server 2008/2005/2000/7.0, Oracle 8i/9i/10g, MS-Access, DB2 UDB V9.5/9.7

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Confidential Data Studio, Solution Explorer, Analysis Manager, SSIS, SSRS.

Software: MS Word, MS Excel, Power Point, MS Access

BI Tools: SSIS, SSRS, SSAS

Reporting: SAP Business Objects Crystal reports

Operating Systems: Windows-2000/NT4.0/98/XP/Vista/Win7, Unix/Linux, MS-DOS.

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. SQL Server Developer/BI Developer

Responsibilities:

• Actively involved ingathering and analyzingtheuser requirementsin coordination with Business.
• Performed thescope analysisof the user requirements.
• Migrated around DTS packages to SSIS 2008 version.
• Wrote Store Procedures, Functions, Views etc.,
• Transferred data from various data sources/business systems includingDB2, MS Excel, MS Access, Flat Filesetc. to SQL Server using SSIS/ETL using various data transformations components like data conversion, look up transformations etc. Created derived columns from the present columns for the given requirements.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Created several batch processes which loads data from DB2, MS Excel, MS Access, Flat Filesetc. to SQL Server on daily basis based on the business requirement.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling and enhancing and deploying the SSIS packages from development server to production server and performed Documentation for all kinds of reports and DTS and SSIS packages.
• Created complex SSIS packages using proper Control and Data flow elements and Used System Tables, System Stored Procedure, DBCC commands for Database maintenance and migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages. Involved in migration from SQL Server 2005to SQL Server 2008.
• Created Packages in SSIS with error handling and used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created ComplexETL Packagesusing SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Organized the ETL Packages and SQL Scripts in TFS 2008 (Team Foundation Server) to make all the objects centralized
• Used SQL Server configurations for all the ETL’s using environmental variable.
• Extensively usedT-SQLin constructing userfunctions, views, indexes,user profiles, relational database models, data dictionaries, and data integrity.
• 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.
• Developed, monitored and deployedSSIS packages.
• Responsible forScheduling Jobs, Alerting and Maintaining SSIS packages.

Environment: SQL Server 2000/05/2008 R2/2012, T-SQL, SSIS/SSRS/SSAS, TFS 2008,XML Files, XSD, Oracle 11g, HP Quality Center 10, Toad, Visual Studios 2008/2010, DB2 UDB on Unix, Active X Script, VBScript,C#,VB.NET, .Net, ADO.Net, ASP. Net, MS-Excel, Visio 2007, Windows 2010/2008/2003.

Confidential, TX.

Sr. SQL Developer/BI Developer

Responsibilities:

• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling and Created ETL SSIS packages both design and code to process data to target databases.
• Worked in enhancing and deploying, and scheduling the SSIS Packages from development server to production server and wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Migrated From Crystal to SSRS Reports.
• Developed Dashboards from Several sources like DB2, Oracle and SQL Server.
• Created various Status Reports for the end Management.
• Developed complex SSIS packages to migrate the data from flat files to SSIS. Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).Developed packages to copy tables, schemas and views and to extract data from Excel and from other legacy systems using SSIS.
• Created ETL/SSIS packages both design and code to process data to target databases. Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Interacted with users and developed various reports accordingly.
• Fine Tuning of long running PL/SQL, DB2 Queries.
• Scheduled reports using Data Driven Subscriptions.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Identify the Attributes and Measures and then create a dimension and fact tables with relation between these tables.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and multidimensional expression (MDX) queries.
• Participate in design discussion.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on the production change request issues based on the Specifications provided.

Environment: SQL Server 2008R2 Enterprise Edition, Business Intelligent technologies like SSIS,SSRS,SSAS, SQL, T-SQL, PL-SQL, DB2, MS Access, MS Excel,& Windows 2003 server.

Confidential, TX

SQL Developer

Responsibilities:

• Involved in analysis, design, development and enhancement of the application that applies business rules on the revenue data on weekly basis.
• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration task.
• Created and documented the mapping of the database objects from source to target database.
• Created store procedure specifically for cleansing and managing data and used the same in SSIS Execute SQL Task.
• Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T SQL code and SQL joins to ensure efficient data retrieval.
• Created SQL Agent Jobs for scheduling SSIS Packages, SSRS reports and alerts.
• Configured and fine-tuned all the ETL (Extract, Transform and Load) workflows.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and parameterized and Linked reports.
• Identified and worked with parameters for creating cascading parameterized reports in SSRS.
• Involved in Debugging and Deploying reports on the production server and analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Deployed and scheduled reports subscription using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models and configured the report builder for building Ad hoc reports.
• Migrated data from MS SQL Server 2005 to MS SQL Server 2008.
• Created SSIS script task with C# code for obtaining parameters from the applications.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Experience in performance tuning, query optimization, Database Maintenance plans.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, SQL Server Analysis Services 2005, T-SQL, Windows XP, MS Excel and SQL profiler.

Confidential

SQL Developer

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in merging existing databases and designed new data models to meet the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.

Environment: MS SQL Server7.0/ 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.