PROFESSIONAL SUMMARY:

• 7+ years of strong experience in Microsoft SQL Server in administration, testing, development and production environment as an MS SQL Developer.
• Expert in creating stored procedures, functions and triggers.
• Highly experienced in Performance Tuning, Handling Indexes, and Query Optimization.
• Strong experience in MS SQL Server 2008/2005/2000 suite of products including SSIS, SSRS and SSAS.
• Expert in developing SSIS Packages to extract, transform and load (ETL)/DTS data into the data warehouse database from heterogeneous databases such as Oracle, DB2, and MS Access.
• Created reports using SQL Server Reporting Services, creating OLAP cubes and data warehouse database.
• Experienced in working with Star Schema modeling to develop ROLAP/MOLAP cubes using SQL Server 2008/2005 Analysis Services.
• Extensive experience designing and developing solutions for a Service Oriented Architecture (SOA).
• Worked in design of logical and physical data modeling using Erwin and MS VISIO data modeling tool.
• Technical expertise in high performance website systems, web services, in a .Net/IIS/SQL environment, and performance tuning/scaling of such systems.
• Extensive experience in performing data loads, database integration/conversions, performance tuning and optimization.
• Extensive experience on BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Hands on Experience in Data Warehousing & BI environment on Cognos 10.1, 8.4, 8.x and Tools like SSAS, SSRS, and SSIS.
• Extensively worked on IBM Cognos 8 Framework Manger, creating model and implementing best practices while resolving the loops and query items, namespaces, DMR (Dimensional modeling with relational data) and packages.
• Sound skills in Developing Dashboard Reports & scorecards using Report Studio and Metric Studio.
• Strong Complex reporting skills such as complex Dashboards, Drill - Through, Scorecard, Discontinuous Cross-Tabs, Summary Reports, ad-hoc reporting and advanced report authoring.
• Experience in developing new reports and customizing existing reports and change request processing.
• Strong experience in implementing Data warehousing solutions involving Dimension modeling, Star and Snow flake schema implementation (3 NF).
• Skilled in administration tasks such as data loading, creating and executing batch jobs, data unloading, performing backup and recovery, managing user and application tables, performing upgrades, and creating databases/file groups/files/transaction logs.
• Strong problem solving skills, analytical, extremely reliable, quick learner and ability to work independently as well as a team member.

TECHNICAL SKILLS:

• SQL Server Analysis Services 2008/2005
• MS Access
• FrontPage
• C, C++
• Visual Basic 6.0
• Visual C++
• ASP.Net
• VB.net
• C#
• PowerBuilder 5
• Erwin v4.0/7.2
• Cognos 10.1
• 8.4 BI (Framework Manager
• Report Studio
• Query Studio
• Analysis Studio
• Metric Studio
• Event Studio)
• Cognos EP Series 7.3
• UNIX
• Windows Vista/Server 2003/XP/2000/NT/9x
• T-SQL
• PL/SQL
• HTML
• XML
• VBScript
• JavaScript
• DB2
• Oracle 7.x/8i/9i
• Sybase
• Oracle Forms 6i
• Oracle Reports 6i
• Crystal Reports 8.5/XI
• ODBC
• MS Visio 2007/2003
• Office SharePoint Server 2007
• Visual SourceSafe.

PROFESSIONAL EXPERIENCE

Confidential, Libertyville, IL

Data Warehouse Developer/SSIS/SSRS

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Responsible for understanding key measures, transactions, dimensions, and success factors of the Brightstar US business.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Developed dashboards using Cognos 10.1.
• Created complex reports in Report Studio such asconditional, dashboards and drill through reports.
• Published Packages to the Cognos 8.4 using Framework Manager.
• Created various reports using Cognos functionalities likeSub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages,
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Construct prototype and finished BI objects using primarily Cognos front end and Microsoft Technologies.
• Provide 2nd level support for IT operations in the areas of daily processes that support BI services.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and indexpartitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimizePerformance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoringtools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: MS SQL Server 2008, T-SQL, SQL SSIS, SSRS, SSAS, Windows server 2003 Visual Source Safe, SQL Profiler, Visual Studio 2008,Visual Intercept Enterprise Edition, Oracle 10g, VB.Net, Cognos 10.1, 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio Cognos Connection, Cognos Configuration)BGE Home, Baltimore, MD Oct 2010 to Jul 2011

Confidential

Data Warehouse Developer/SSIS/SSRS

Responsibilities:

• Extracted data using ETL from OLTP to OLAP.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Developed Full Analysis Life Cycle Project.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Provided Full ETL Life Cycle support using required transformation like Derived Column, Conditional Split, and Lookup by using MS SQL Integration Services 2005.
• Designed and developed ETL Process for integrating data from sources like Excel, CSV, Flat Files and SQL Server.
• Designed and developed Logical Data Flow by applying complex transforms as per business rules for loading the extracted data into Enterprise Data warehouse.
• Designed and developed SSIS Packages for New Enterprise Data Warehouse with SSIS 2005.
• Developed and optimized SSIS Packages for “Lead Extraction Engine” which mainly involved high level business transformations on the data to produce the desired weekly and summary vendor extracts needed to monitor the overall effectiveness and profitability of Email List Management.
• Created and automated various FTP Processes and Email Processes using SSIS.
• Developed various Error Handling Strategies for the successful run of the build packages.
• Converted existing SQR reports to Actuate version 8.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008 for the above projects.
• Created matrix, tabular, parameterized, drill down and aggregation type of reports in SSRS 2008.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Managed role-based security to reports and reporting resources.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for maintaining scripts, promotion checklist, project documentation and documentation for the ETL Process in Team Foundation Server and Visual Source Safe.

Environment: MS SQL Server 2005/2008, T-SQL, SQL SSIS, SSRS, SSAS, Office SharePoint Server 2007, Win 2003 Advanced Server, Oracle 10g, VB.Net.

Confidential, Saint Louis, MO

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005 for the above projects.
• Created matrix, tabular, parameterized, drill down and aggregation type of reports in SSRS 2005.
• Closely interacted with end user to gather business requirements.
• Responsible for Full Report Cycle including Authoring, Managing, Security and Generation of Reports.
• Generated different types of Reports such as Tabular, Matrix, and Charts.
• Created stored procedures, user-defined functions, complex correlated sub queries for generating different Reports.
• Deployed and configured reports in the Report Server.
• Created Subscription of Reports in different formats such as PDF and Excel to be executed automatically on weekly or monthly basis.
• Used SQL Server Reporting Services to generate reports by passing parameters through URL Developed reports.
• Worked with the QA and Production Team for setting the Configurations for the SSIS packages for Test and Production Deployment.
• Designed and developed SSIS Packages mainly for “Email List Management”, ”StrongMail” and “Mall Network” Projects and for other internal data load processes for data warehouse with SSIS 2005.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Responsible for maintaining scripts, promotion checklist, project documentation and documentation for the ETL Process in Team Foundation Server and Visual Source Safe.
• Worked with Tidal Software for Job Scheduling and automation.
• Secured reports by creating Service Accounts and Security Groups and configuring in the Report Server.
• Performed data conversions from SQL Server to flat file using SSIS.
• Created packages that implemented tasks such as Execute SQL Task and Data Flow Task.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, T-SQL, SSIS 2005, Office SharePoint Server 2007, Win 2003 Advanced Server.

Confidential, Philadelphia, PA

MS SQL Server Developer/SSAS/SSIS Developer

Responsibilities:

• Involved in all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS
• Created SSIS process design architecting the flow of data from MS Access to MSSQL Server 2005.
• Created ETL (.dtsx files) packages using SSIS to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Dynamically altered properties of packages by configuring XML config files (.dtsconfig files).
• Configured packages event logs.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
• Created standard ActiveX template routines for transformation of data.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Created lock hints in DML, DDL scripts for boosting performance.
• Based on the OLAP reporting needs, developed complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created calculated fields with MDX cube to meet additional measures needs that are calculated from existing measures.
• Used SQL Profiler to view indexes performance to eliminate table scan.
• Developed multiple join statements to retrieve data from several tables.
• Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure on levels of reports.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of data effective.
• Involved in project status report updates/creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2000/2005, T-SQL, SSIS 2005, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access, Crystal Reports 9/10.

Confidential, Rochester, NY

MS SQL Server Developer/SSAS/SSIS

Responsibilities:

• Involved in reviewing and gathering requirements from users.
• Prepared user requirements documents based on functional specifications.
• Used Erwin to design and convert logical data model to physical database.
• Expert in developing physical data models and prepared DDL scripts to create database schema and database objects.
• Involved in developing source to target specifications.
• Created functions, views and triggers.
• Developed scripts to load data from Oracle tables and flat files into Enterprise data warehouse.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Scheduled jobs for batch processing by creating SSIS package.
• Provided support to the ASP.Net front-end application developers for queries related to development hierarchies, file upload and validations.
• Involved in performance tuning to optimize SQL queries using query analyzer and SQL Profiler.
• Created indexes, constraints and rules on database objects.
• Involved in monitoring queries which were parsed through Cognos.
• Generated reports for the end users using Crystal Reports.

Environment: DB2, MS SQL Server 2005, SSIS, ERwin, SQL Query Analyzer, SQL Profiler, SQL Developer, Cognos Power Play, Cognos IWR, ASP.Net, JD Edwards ERP data tables on Oracle 8i, Crystal Reports XI.

Confidential

MS SQL Server Developer

Responsibilities:

• Designed and analyzed the SQL Server database and involved in gathering the user requirements.
• Logical and Physical design of database for project on basis of user requirements.
• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Coordinated with the front-end developer to put in the business rules. Created procedure to check some of the rules at the backend at the time of entering data.
• Created tables, stored procedures, views, triggers to facilitate the web application.

Environment: MS SQL Server 2000, T-SQL, Win NT v4, Win 2000, Win 2003, ERwin v4.0, Crystal Report 8.5.