SUMMARY

• Around 7 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2000/2005/2008 / R2, 2012 for both OLTP & Data warehousing applications in various business domains.
• Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• Strong T-SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Involved in relational data modeling and multi-dimensional modeling using De-normalizations, Fact tables, Dimension tables, Star schema for OLAP systems.
• Experience in SQL Server DTS and SSIS package design, development, and deployment using SQL 2008/2005 in Control flow, Data flow, Error Handling and Event handling in different heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Extensive experience in SSRS and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down and Sub reports.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Worked on SQL BI solution integration with Microsoft Share Point Server (MOSS).
• Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Worked on OLAP Data warehouses, Modeling, Design, cube development including KPIs, Data mining, working with changing dimensions.
• Experience in OLAP cube partitions, aggregations, optimization as well as refreshing cube data.
• Experience in developing web applications using ASP.Net, ADO.Net.
• Worked very closely with Customers and End users, collect requirements and training or resolve any business process related issues.
• Expert at understanding Business and transforming requirements into SSIS packages.
• Self-Motivated with Excellent communication skills with a strong focus on Client oriented service and ability to work excellently as an individual and also as part of a team with minimum amount of supervision.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008R 2/2005/2000/7.0 , ORACLE, MS Access

Database Tools: MS SQL Server 2012/2008R2/2005/2000, MS-Access, SSIS, DTS, SSAS, BIDS And Erwin

Development skills: SQL, SSIS/SSRS/SSAS, Oracle

Languages: VB Script, T-SQL, HTML, XML, ASP, Java Script, Vulcan, VBA Macro, C, C++

Operating Systems: Windows 98/NT/2000/XP, 2003,2007 Servers, UNIX.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, Visual studio, TTP, SCM, SERVICE NOW.

PROFESSIONAL EXPERIENCE

Confidential, Mendota Heights, MN

Database Developer

Responsibilities:

• Wrote complex T-SQL queries, User Defined Functions, Stored Procedures and Triggers in SQL Server 2008R2/2008/2005 followed by analysis and testing of those database objects before deployment to the production server.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, CTE’s Views and Cursors
• Used SQL Server Integration Services (SSIS/2008/,2005) as an ETL Tool and created complex packages for the extraction of data from disparate sources (SQL Server, Flat Files, Excel Source files, XML Files) and loaded the data into target tables by performing data validation and cleansing using various transformations
• Well versed with different components of SSIS (Control Flow, Data Flow and Connection Manager) while extensively using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks.
• Created SSIS packages to load the data from XML parsed tables to the PDS server tables and created complex SSIS packages to send the data through SFTP to STIBO(ORACLE) for item enrichment.
• Created Master SSIS packages in order to execute a set of packages on a timely basis and deployed those packages using Manifest Files and Import/Export Wizard so that the packages were available for use to other team members
• Undertaking various tasks like Active-X Script, Script Task, FTP Task, File System Task, Execute Process Task, Send Mail Task, Bulk Insert Task etc.
• Deal with huge data for claims, member and providers, provided production support for SSIS jobs during weekends
• Data pull from ORACLE to SQL databases using SSIS packages.
• Creating Ad Hoc, parameterized reports, Multi-valued parameter reports, linked reports, Drilldown and Drill through reports using SQL SSRS 2008/2005
• Worked with report manager for deploying the reports across all the environments
• Deployed and uploaded the SSRS reports to SFTP for the end users and involved in enhancements and modifications
• Wrote stored procedures, functions and packagesfor moving the data from staging area to ODS.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Executed testing on new and existing programs for thepurposes of correcting errors and general debugging.
• Assisted in the definition,development, and documentation of database’s business requirements, objectives, deliverables, andspecifications on a project-by-project basis in collaboration with internal users and departments.

Environment: SQL Server 2000/2005/2008 / 2012, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, TTP, SCM (source code management), SNOW, SSRS 2005/2008/2012 , SSRS

Confidential, Minneapolis, MN

MS SQL Server/ BI Developer

Responsibilities:

• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Extensively worked in analyzing Stored Procedures on Legacy Environment, produce documentation and re-create them on New environment
• Created more than 1000 stored procedures using Common Table Expression (CTE) and various types of UDF functions
• Generated multiple Enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrixes, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional, Split, Derived columns etc.
• Identified duplicate data by using an Aggregate transformation that group’s data by contract id. An email task was used to point other team members and managers to the files with the unacceptable data and also state the data issues.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Involved in creating the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• While developing reports from Cubes also used the KPI's for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views.

Environment: SQL Server 2000/2005/2008 / 2012, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, ASP.NETC#.NET, SSRS 2005/2008/2012 , VBA and VB Script.

Confidential, Wayne, PA

MS SQL Server/ BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db, and SQL 2008).
• Extract and Transform data into Staging Servers named as WHS Staging Server for historical data and T-Staging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Experience in end-user reporting definition, development and platform support using SQL Server Reporting Services (SSRS) and Performance Point.
• Generated SSRS report form SSAS OLAP Cube.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Used Visual Source Safe tool for Version Control.
• Tuned SQL query for better performance using SQL Profiler.
• Documented all work, so user can easily understand the flow of process.

Environment: SQL Server 2000/2005/2008 , Enterprise Manager, Management Studio, SQL Profiler, SQLQuery Analyzer, MS SQL Server DTS, SSIS, ASP.NET,C#.NET, SSRS 2005/2008/2012 , VBA, VB Script and UNIX.

Confidential, Birmingham AL

MS SQL Server Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SQL Server Reports using SSRS 2008.Identified the data source and defined them to build the data source views.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• 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.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Used Lookup Transformation to get the data from reference data sets
• Migrating SQL Server 2005 databases into SQL Server 2008.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Used MDX to define KPI’s, calculated members in the cubes.
• Created partitions of the Analysis Services cube to improve performance.
• Conducted Data Analysis and did Data Modeling and Created the ER diagrams using Logical Schema and Star Schema.
• Generated ad-hoc reports using MS-Excel and Crystal Reports.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Environment: SQL Server 2005/2008, SSIS, VBScript, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), MS SQL Server Analysis Services(SSAS).

Confidential, Oklahoma City, OK

SQL Server/ BI Developer

Responsibilities:

• Worked on Performance point server and created management reports.
• Created complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• 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.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Created complex SSIS packages using proper control and data flow elements.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP Database using of SQL Server 2008 Integration Services (SSIS)
• Scheduled SSIS Packages, using SQL Server Agent.
• Have deployed packages on different servers by configuring it.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL Performance Monitor, SQL Profiler.
• Wrote complex reports for Batch process using SSRS and worked with building the portal to access all the reports.
• Developed Sub Reports, Matrix Reports, tabular and parametric Reports, Charts, and Drill Down reports, using SQL Server Reporting Services (SSRS).
• Converted existing Excel templates into SSRS reports to migrate the reporting model to SQL Server Reporting Services. Also made sure that the SSRS reports were consistent with the previous Excel layouts to avoid any issues while uploading the monthly reports to the Gran Central database.
• Developed Sub-reports and Dashboards using Gauges and Charts to add more detail to the report.
• Built complex Ad Hoc, Standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.
• Created Data driven Subscriptions to automate the process of storing copies of hundreds of Parameterized monthly reports to the server.
• Responsible for logical and physical data modeling, database design, star schema, data Analysis, programming, documentation and implementation.

Environment: Microsoft SQL Server 2008/2005, Windows XP, Transact SQL, PL/SQL, SSIS, SSRS, OLAP, ErwinQuery Analyzer, SQL profiler, SQL Query Manager, MS Visual Source safe and Source Offsite, Performance Monitor, Query Optimizer