TECHNICAL SUMMARY:

• Extensive 7+ years of IT development experience as SQL Server Developer 2000/ 2005/ 2008/2008R2/2012.
• Experience with Transact - SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Knowledge of databases in clustered and unclustered environments.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Experience in migration of DTS Packages to SSIS Packages and loaded the data from SQL Server 2000 to SQL Server 2005 as well as Sybase database.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Data analysis and data migration by transferring them using SSIS packages.
• Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting.
• Extensive experience in creating SQL Reporting Services (SSRS) and SSIS Infrastructure that pulls data from data sources and provides a simple to use reporting environment.
• Expert in uploading SQL Server Reports on to the report manager and organize them in folders and worked with delivering the reports using ‘pulled’ and ‘pushed’ methodologies.
• Experience in generating formatted SQL server Reports, handling Parameterized SSRS 2005/2008
• Experience converting MS Access reports to SQL Server Reporting Services.
• Expert in creating packages, Jobs, Sending Alerts using SQL Mail. Experience in SQL Server Analysis Services (SSAS) OLAP Cubes and Data Mining, SSAS 6.5/ 7.0/ 2000/ 2005/ 2008/2008R2/2012.
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

BI Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS)

Databases: MS SQL Server 2012/2008R2/2008/2005/2000, Oracle 8i,9i/10g, MS Access 97/2000.

Languages: T-SQL, C#, ASP.NET

Data Modeling Tools: MS-Visio, Erwin 7.2/4.5, Visual Studio

Operating Systems: Windows server 2003,windows 95/98/NT/4.0/2000/XP, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SQL Server Developer/SSIS/SSRS.

Responsibilities:

• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key to streamline the process of replication.
• Participated in Creating tables, indexes and designing constraints. Created Backend validations using Insert/ Update and Delete triggers. Created views for generating reports.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Worked with Indexes and used Scan and Seeks for performance tuning. Developed, monitored and deployed SSIS packages in production server.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting, worked with Multi-Threading Concepts and Synchronous and Asynchronous transactions
• Developed, monitored and deployed SSIS packages by exporting data from DB2 Databases.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created a SQL Reporting Services (SSRS) and SSIS Infrastructure that pulls data from data sources and provides a simple to use reporting environment.
• Created SSRS reports using Report Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Designed and developed Drill down and Drill Through reports with Drop down parameters.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Created logging, custom logging and error handling packages.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.

Environment: SQL Server 2012/2008R2/2008/2005,SSIS,SSRS,Visual Studio 2010/2008, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio.

Confidential, Wilmington, DE

SQL BI Developer/SSIS/SSRS/SSAS.

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Involved in updating slowly changing dimensions strategies
• Defined requirements and comprehended the complex business rules required for writing the code.
• Developed Analysis Services Projects.
• Responsible for identifying and defining Data Source and Data Source views.
• Responsible for defining calculated members.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Created and managed subscriptions for the reports
• Developed Drill down Tabular, Matrix and List Reports using SSRS.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created reports on both relational databases as well as against analytical cubes.
• Migrated some crystal reports to SSRS reports.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Developed and coded applications in T-SQL
• Developed reports that deliver data from cubes.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.

Environment: MS SQL Server 2008R2/2008/2005, T-SQL, Windows 2000/2003, Crystal Report 8.5, MS SQL Server Integration Services, MS Access, MS Excel, HTML, XML.

Confidential, Woodbury, MN

SQL Server Developer/ SSIS/SSRS.

Responsibilities:

• Installing different hot fixes for deadlocks, blocking and indexes.
• Detection and resolving of blocking and deadlocks using Profiler.
• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Experience in mapping multiple related systems.
• Designed the system architecture that is used to structure, plan, and control the process of developing an information system
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data.
• Experience in migrating some of the DTS packages in to SSIS.
• Used Recompile and with option query hints to avoid parameter sniffing problems.
• Improved query performance by adding covered indexes, adding file groups.
• Creating and managing schema objects such as tables, views,joins,clusters, indexes,functions,procedures, triggers & maintaining Referential Integrity.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS 2005 and Crystal reports. Used table control, matrix control for cross tab reports.
• Configured Reporting Services in SQL Server 2005.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Troubleshooting performance issues with Fragmentation using Profiler, System Monitor and DMV’s.
• Configured nodes and virtual server to set up Active/Active Clustering.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: SQL Server 2005/2008, Enterprise Edition, SQL, Enterprise manager, SSRS 2005, SSIS 2005, MS Access 2000.

Confidential

SQL Server Developer/ SSIS/SSRS.

Responsibilities:

• Generated SQL Scripts for copying/migrating databases and database objects.
• Gathered data for validation and populate them into tables using stored procedures.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Extensive use of Stored procedures, Writing new stored procedures and modifying existing ones and tune them such that they perform well
• Involved in designing various reports to flat files generated by the database script.
• Create Stored Procedures, Triggers, Views, joins and Functions for the Application
• Create, debug, and execute T-SQL scripts and stored procedures
• Extensively involved in error handling stored procedures
• Imported various Sources, Targets and Transformations using Transact-SQL Server.
• Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.
• Actively involved Normalization & De-normalization of database
• Extensive Testing on the Performance of the Stored Procedures.
• Worked closely with Application Developers and Business Analysts to produce all required documentation
• Identified, tested and resolved database performance issues to ensure database optimization.
• Created complex views, partion views for the application to increase the performance and reduce server load.
• Write complex T-SQL statements for retrieval of data.
• Testing the Performance of the database and fine-tuning is also done for complicated queries that take time to carry out, Analyzing and creation of appropriate indexes to optimize application performance
• Create joins and sub-queries for complex queries involving multiple tables.

Environment: MS SQL Server 2005, Windows 2003 Server, Transact-SQL, SSIS, SSRS, Erwin Tool