SUMMARY

• 8 + years of professional experience on Design, Development and Maintenance of Database using tools of MS SQL Server 2008/2005/2000 as a Developer.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases, creating and using Stored Procedures, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads and Data Cleansing in Data Ware House using SSIS.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Developed stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the Business Users.
• Expert in designing and implementing reports using Crystal Reports, extensive experience in writing SQL queries for Oracle and MS SQL Server databases.
• Experienced in converting Extracts written in Cognos Impromptu and re-write them to SQL to generate reports using SSIS.
• Very good T-SQL Programming skills. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS) and Mining.
• Involved in SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages, Query Optimization and Performance Tuning using SQL Profiler, Index Tuning Wizard and store procedure Debugger.
• Worked on system analysis, design, development, testing and implementation of projects Software Development Life Cycle (SDLC).
• Good team player, Self-motivated and possess ability for critical thinking and analysis and Strong inclination for finishing job before project deadline.
• Used Proclarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft sql Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
• Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Creating Dashboard pages that use Excel Access web parts and Reports.
• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Extensive experience in creating Tables, Views, Indexes, writing Stored Procedures, Triggers using T-SQL (DML and DDL) as well as analyzing and debugging existing complex stored procedures.

PROFESSIONAL EXPERIENCE

Confidential, Marshfield, WI

MS SQL Server Developer/ SSRS/SSIS Developer

Responsibilities:

• Created complex Stored Procedures, modified stored procedures, Tables, Views, used SQL joins and other T-SQL code, documented each Impromptu report in SQL and all rules used by extracts, using layout.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations from Access database, Flat File Source, Microsoft Excel, SQL Server and Netezza Data Provider.
• Rewrote the Extracts written in Cognos Impromptu to SQL because the extract was performed by Impromptu reports and Impromptu is no longer supported.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria and Implemented Impromptu Business Logic to SQL Logic while converting Impromptu to SQL.
• Worked with T-SQL and DDL.
• Created a new process to execute the extracts of Cognos Impromptu reports using SSIS which includes use of Stored Procedures, Views, Tables and Transformations. And also, ensured fields used in the extracts continue to be filled in.
• Actively participated in meeting and checked for the development of the project. Documented the project work and process.
• Developed SSIS packages to produce details and summarized reports on daily basis.
• Cross check the data sources against the new Data Warehouse and non-filled fields used in the extracts from Data Warehouse.
• Tuning Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Designing several ETL process to Load data from Text, Excel Files, SQL Server, Netezza Server. And transferred data (ETL) to Data Warehouse Environment.
• Tested and validated new scripts and compared results against Impromptu extracts with SSIS.
• Used TFS (Team Foundation Server) for project management and source control.

Confidential, Alpharetta, GA

MS SQL Server Developer/ SSRS/SSIS Developer

Responsibilities:

• Gathered reporting requirements from every department, Participated in weekly IT status update meetings, Facilitate Meetings, worked with different business units.
• Designed and developed a database to house data from various data sources for all reporting needs Identified the Data Source and defined them to build the Data Source Views.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed Query for drill down reports in SSRS 2005/2008, created parameterized, drill-down and drill-through, subscription to reports.
• Schedule jobs to transfer reports to MS Excel and scheduled SQL jobs to run SSIS packages on a daily basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SSRS. Designing and implementing reports using crystal reports, and expert in writing SQL queries for Oracle and SQL Server databases.
• Wrote custom T-SQL stored procedures and triggers and provide additional application functionality.
• Build different types of chart reports using SSRS like column chart and Pie charts.
• Responsible in fixing the security issues for packages that were created in SQL Server 2000 DTS, and troubleshooting.
• 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.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Generated Reports using Global Variables, Expressions and Functions for the reports, Created views, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Configured packages event logs and Created ETL SSIS packages both design and code to process data to target databases.
• Responsible for creating reports using crystal reports XI Version using Oracle 11g version, SQL Server databases. Designed and developed cross tab reports, reports with sub reports (linked and unlinked), Crystal reports formulae’s, Grouping parameters, and crystal reports 10.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Performed different types of testing as user acceptance testing, functional testing.
• Worked on Shared Database, Build Physical Data Model, Created Table Structure, and maintained DB standards and naming conventions.
• Responsible for smooth Onshore - Offshore Coordination, User interaction and Production Support.
• Deployed reports to Reporting Services and generated reports to run on daily/weekly/monthly basis using SSRS and email results to business user in required format.

Confidential, NY

MS SQL Server/ SSIS /SSAS/SSRS Developer

Responsibilities:

• Played an important role in understanding custom objects of Payment Net functionalities and implement them in the JPMC Commercial Cards system and related enhancements, Configured all the events that should get triggered, pertaining to the Payment Functionality.
• Installed and configured SQL Server 2008 in test environment with latest service packs and migrated few databases, modified and maintained databases.
• Created ETL packages in SSIS with error handling and conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed DTS packages to extract, transform and load into the database from OLTP database using of SQL Server 2008 Integration Services (SSIS).
• Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2005 to the SQL Server 2008, Performance tuning, and Optimization of procedures and queries.
• Created Complex Stored Procedures, triggers, cursors, tables, Views and other SQL joins and statements for applications by using T-SQL. Worked on Performance point server and created management reports.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2005 Reporting Services.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Developed new and worked on existing T-SQL Stored procedures and triggers, preserve referential integrity.
• Hands on experience in SSAS (SQL Server Analysis Service) with MDX.
• Created Packages in SSIS with error handling.
• Installed and Configured SQL Server 2005 along with Analysis services (SSAS), Integration Services (SSIS) and Reporting services (SSRS).
• Analyzed the requirements and fine tune stored procedures to improve performance.
• Developed Sub Reports, Matrix Reports, Tabular, Charts, Drill down reports using crystal reports, various chart reports and parametric reports, using SQL Server Reporting Services (SSRS). Wrote SQL and PL/SQL Queries on Oracle 8i and SQL Server.
• Created Crystal Reports using crystal reports formulas, Grouping, parameters selection, handle the customer requests from Tables, Stored Procedures and views.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Worked with building the complex Standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.
• Configured and managed database maintenance plans for update statistics, database integrity check, database backup/restore, database mirroring operations.
• Conducted data analysis and did Data Modeling and Created ER Diagrams using Logical Schema and Star Schema.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.

Confidential, Atlanta, GA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed Complex Queries in T-SQL, Stored Procedures, and Views with best execution plan Created User Defined Functions, Triggers, and Indexes.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Used the SSIS to migrate Databases such as Oracle and Access database, flat files to SQL server 2005, Used SQL Server Mail Agent for sending automatic emails when any packages, queries are failed.
• Developed DTS jobs to import data from legacy systems.
• Hands on experience in SSAS (SQL Server Analysis Service) with MDX.
• Responsible for Developing, Monitoring and Deploying SSIS packages used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, triggers, cursors, UDF’s
• Responsible for modifying the stored procedures, rebuilding indexes for improving performance.
• Creating Reports as per user requirements using MS Reporting Services 2000/2005
• Created SSIS Packages to migrate slowly changing dimensions
• Used OLAP Processing Tasks for automatic processing of OLAP Databases.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Worked on ProClarity to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Worked with T-SQL, DDL, DML and DCL.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down and Crosstab Reports.
• Designed and developed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using SSRS.

Confidential

MS SQL Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and managed requests that came from the development team.
• Collected and managed data information including its branches, employees, subsidiaries, partners and stockholders.
• Developed complex T-SQL code for the application and stored procedures and T-SQL code to accomplish various tasks.
• Created the different user defined functions in the application.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria.
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.