SUMMARY

• Over 7 years of IT Experience in Analysis, Database Design, development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.
• Extensive programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2000/ 2005/2008/2012 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Experience in Business Requirements Gathering, Data Modeling, Development, Testing, Implementations and Documentation.
• Extensive knowledge of normalization and relational database management systems.
• Proficient in Logical and Physical database design & development (using normalization, dimension modeling, Data Modeling and SQL Server Enterprise manager).
• Expert in data architecture and data modeling, using Erwin in Transact - SQL (DDL, DML), views, stored procedures and also using database triggers.
• Strong experience in creating complex Stored Procedures, Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements.
• Expertise in Analyzing Query Plans, Using Extended Stored Procedures, Managing Indexes and Locks, Troubleshooting Deadlocks.
• Working knowledge in .net technologies ASP.NET, C#.
• Expertise in creating Reports with complex formulas and to query the database for business Intelligence using SSRS.
• Proficiency in creating different types of reports such as Table Reports, List Reports, Drill-down, Drill through reports, Group reports, sub-group reports, Total Reports, Sub-total Reports.
• Expertise in Integrated SQL Server Reports with SQL database using views and stored procedures.
• Expertise in developing Reports like Standard parameter Reports, cascading Reports for each and every Departments.
• Experience in developing ad-hoc reports using Report Builder.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
• Experienced using in FTP and SFTP servers to upload files.
• Extensively worked in creating and integrating Micro strategy reports and objects (Attributes, Filters, Metrics, Facts, etc.) with the data warehouse.
• Created and maintained Databases, creating Roles and managing user permissions.
• Experience in MS SQL Server configuration, performance tuning, query optimization, back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Expertise in Debugging, Optimizing and Performance Tuning of MS SQL SERVER 2005/2008/2012 Dashboards /Reports.
• Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2000/2005/2008 R2/2012.
• Good Knowledge in Physical and Logical Data Modeling.
• Highly motivated and a conceptually strong individual with exceptional analytical and design skills.
• Excellent professional written and verbal communication and interpersonal skills. Proficient in technical writing and presentations.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 , Windows XP/Vista

Languages: T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML

Tools: /Utilities Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008/2012 , SQL * Plus, Erwin, Aginity Workbench for Netezza 4.1

Databases: MS SQL Server 7.0/ 2000/2005/2008 R2/2012, Oracle10g/9i, MS Access, Netezza 7.0.2

Data Modeling Tools: Microsoft Visio, UML, Erwin

Software: MS Office, Adobe, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Power BI Reports

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

SQL Server BI Developer

Responsibilities:

• Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance.
• Developed SQL Server 2012 Databases objects i.e. Schemas, Synonyms, Tables, Indexes and Stored procedures.
• Written complex SQL statements using joins, sub queries and Query expression.
• Extracted data from various sources like SQL Server 2012, Oracle 11g, IBM DB2, Flat files, XML and Web services from Client servers and through FTP.
• Designing and implementing ETL mechanism for business requirements that includes incremental, historical data loads and transformations using SSIS.
• Implemented ETL parallel execution mechanism to improve performance in ETL process.
• Involved in re-design, re-code, and deploy new data extractions using SQL Server Integration Services, and designed and produced documentation of data transformations for all extractions.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Complex ETL Packages using SSIS to extract data from staging tables to Data Mart tables with incremental load.
• SSIS packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Derived Column, Sort, Row Count, Script Component and Data Conversion.
• Created SSIS packages for File Transfer between Linux to Windows Server locations using FTP task & Script Task.
• Loaded data from Flat files into staging tables by using Bulk Insert Task
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created, Scheduled and Monitored jobs in SQL Server Agent.
• Provided support to database Servers in Production, QA and Development.
• Created ETL process and data mapping documents for future references.

Environment: MS SQL Server 2012, BIDS/Data tools (SSIS), T-SQL, C#,Linux, Share Point Portal Server, Putty, Notepad++, TFS, Oracle 11g, Toad for Oracle 9.7.2.5, IBM DB2 9.5.1, Visual Studio 2012.

Confidential, Columbia, MD

SQL Server BI Developer/ NZ Developer

Responsibilities:

• Involved in the completeSoftware Development Life Cycleincluding Analysis, Design, Implementation, Testing and Maintenance.
• Developed SQL Server 2008 R2 Databases objects i.e. Synonyms, Schemas, Tables, and Indexes, Stored procedures, Views, Triggers and user-defined functions.
• Designing and building data load stored procedures, using MS SQL Server.
• Written complex SQL statements using joins, sub queries and correlated sub queries and Query expression.
• Written Queries usingT-SQLStatements,Views, User Defined Functions, Stored Procedures,TriggersinSQL Server 2008 R2 for inserting/Updating/Deleting the data into the relational tables
• Design and Build Extract Transform Load processes using SQL Server Integration Services and created the packages to import/export data feeds to/from data warehouse and legacy systems.
• Involved in re-design, re-code, and deploy new data extractions using SQL Server Integration Services, and designed and produced documentation of data transformations for all extractions.
• Fine-tuned the Stored Procedures, Functions and Views for optimum performance.
• Used SQL Profiler and Estimated Execution Plan to optimize queries and Stored Procedures.
• Created SSIS packages for data load and transfer to and from various data sources like SQL Server, Netezza and IBM DB2.
• Scheduling SSIS package Jobs from SQL Agent.
• Created and Deployed Packages by Using SQL DB Control.
• Troubleshoot the slow execution queries and stored procedures.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Performed maintenance tasks which includes backup / restore by using SQL Server 2008 R2 using SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Migration: Microsoft SQL Server 2008 R2 Database into Netezza 7.0.2 Database by using SSIS.
• Created and modified the Mapping documents.
• Worked with NZLoad to load flat file data into Netezza tables.
• Created tables and Views in Netezza.
• Worked with NZadmin to see the long running queries and their view plan. Identified the right columns to distribute the data for a given table.

Environment: Microsoft SQL Server 2008 R2, SSIS, T-SQL, Netezza 7.0.2, MS-Excel, Windows XP/7, VS Business Intelligence Tool, TFS, SharePoint, MS Visio, SQL Data Examiner, Ultra Edit, IBM DB2 10.1, SQL DB Control, Aginity Workbench for Netezza 4.1.

Confidential, Reston, VA

Sr SQL server BI Developer

Responsibilities:

• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.
• Involved in database designing using Normalization.
• Exported reports to various formats like PDF, Word and Excel.
• Involved in security and user role assignment to different reports.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load and extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Involved in the development of SSIS package mappings and also tuned for better performance.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Conditional Split, Derived Column, and Data Conversion Transformations.
• Responsible for creating batch files and scheduling the jobs.
• Involved in analyzing Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008, SSIS 2008, SSRS 2008, T-SQL,OLAP Service, Visual Studio 2005,SQL Server Profiler, Erwin Data Modeller 7.2, Windows Sever 2000/2003/2008 R2, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).

Confidential, Colorado Springs, CO

SQL Server SSIS/SSRS

Responsibilities:

• Developed complex T-SQL code for the application.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Designed and implemented the stored procedures and triggers for automating tasks.
• Developed SQL Server Stored procedures and DTS packages to extract data from database.
• Implemented constraints on tables.
• Created so many queries, Stored Procedures, Functions on OLTP Database.
• Created SSIS Packages to migrate slowly changing dimensions.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Testing of applications for performance, data Integrity
• Database and Log Backups and restoration, backup strategies, scheduling backups.
• Generated reports using MS Reporting services.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Created indexes, constraints and rules on database objects.

Environment: SQL Server 2005, Unix, MS Access, DTS, Query Analyzer, SSIS, MS reporting Services, BCP, Erwin, Import & Export Data, Windows 2003 Server.

Confidential, Wilmington, DE

SQL Server BI Developer

Responsibilities:

• Interfaced with Business users for better understanding the reporting requirements.
• Interfaced with the client as part of the Requirements engineering team to finalize the project scope.
• Involved in Database design including optimizing the database schema, creating database indexes and coding database procedures/queries.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages
• Implemented SSIS for data transformation logic process.
• Designing and building data load procedures, using MS SQL Server SSIS
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Extracted Data from Various OLTP Databases to OLAP Database.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Developed Stored Procedures, Functions and Database Triggers.
• Developed reports using SQL Server Reporting Services (SSRS)
• Developed reports and Landscape reports.
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Developing a Report as per user requirement using MS Reporting Services
• Published reports as PDF formats.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, Excel, TSQL, Microsoft Visual Studio 2005,SQL Reporting Services, SQL integration services.

Confidential

SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access.
• Created and managed new security accounts.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000, T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS.