SUMMARY

• Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments wif various business domains like Healthcare, Financial, Telecom, Pharmaceutical, Human Resources, Sales and Call Center
• Expertise in writing T - SQL Queries using joins, Sub queries and Cursors in MS SQL Server 2000/2005.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in creating SSIS packages using Active X scripts and wif Error Handling.
• Expertise in enhancing and deploying teh SSIS Packages from development server to production server.
• Experience in deploying created reports in various sources like Web browser, XML and VBA Excel.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Expertise in report writing according to teh business requirement in SSRS.
• Expert in creating SQL Server Reports using SSRS 2008 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.
• Experience in administrating teh created reports and assigning permission to teh valid users for executing teh reports.
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Expert in creating teh MDX cubes and dimensions.(SSAS)
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including teh measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Experience in Logical modeling using teh Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces wif BIDS.
• Monitored and Tuned MS SQL Server databases wif tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in enhancing and deploying teh SSIS Packages from development server to production server.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Knowledge on integration of BI suite of products wif Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Excellent skills in designing Logical and Physical Modeling using ERWIN.
• Strong analytical, administration and problem solving skills dedicated to maintain teh high quality standards. Good communication skills, ability to work independently.

TECHNICAL SKILLS

Database Tools: SQL Enterprises Manager, SQL Profiler, Query Analyzer SQL Server setup, Security Manager, Service Manager, SQL Server,Analysis Services (SSAS).

ETL Tools: Data Transformation Services (DTS), SQL Server 2008/2005/2000 Integration Services (SSIS), Import Export Data, Bulk Insert, BCP.

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

Programming Language: T-SQL, PL/SQL, C, C++,C#, Assembly, HTML, Java,Script, XML, .NET 2.0, Visual Basic 6.0, Visual FoxPro 5.0.

Web Tools: MS-Front Page, MS-Outlook Express.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9/10, MS Access, MS Excel.

Databases: SQL Server 7.0 / 2000/ 2005 , Oracle 8i /9i/10g/11g, MS Access.

Operating Systems: Windows 9x/NT/XP/Vista, MS-DOS, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Chapel Hill, NC

Senior SQL Server SSRS/SSIS Developer

Responsibilities:

• Run teh test cases written for integration and functional testing after teh deployment of teh databases.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Created ETL packages using SSIS to extract data from relational database and tan transform and load into teh data mart.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
• Created store procedures, views, and tables and generated TSQL script for application.
• Used Visual Team Foundation server for version control, source control and reporting.
• Write Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
• Fix any bugs arising out of SIT, UAT and any other test process.
• Involved in code review, writing Unit test case, and creating a platform to run and validate these Test cases.
• Master deployment tools. Utilize team tools for change management. Advocate for architecture and design concepts that can enhance performance and reduce maintenance costs.
• Mentor or act as subject matter expert in assigned technologies (e.g.: Octopus, Azure, etc.).
• Co-ordinate wif other Teams and integrate different applications on to common platform.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, Visual Studio Team Foundation, Visual Studio 2010, T-SQL, SSRS, SSIS, BIDS, MS Word, MS Excel, MS Access.

Confidential, Louisville, KY

Sr. SQL Server SSRS/SSIS Developer

Responsibilities:

• Data Warehouse application development, support and maintain activities using Microsoft SQL server, SSIS, PL/SQL, Oracle database technologies.
• Working wif teh functional analyst and users to understand needs and develop new functionalities and tools. Modeling, designing, developing, tuning, and testing teh back end structures to meet all requirements.
• Do front end analysis prior to development or execution, as well as several phases of system testing.
• Analyze, program and test data warehouse code owned by applications team using Oracle 11g, SQL server and .NET Technologies.
• Support teh existing data warehouse platform and application, maintaining its availability and scalability.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
• Hot fix for SQL Server Patch.
• Extensive work experience as a SQL Server Developer and in depth proficient experience in OLTP, Operational Data Source (ODS), and Dimension Modeling, Data warehouse, OLAP and Database technologies
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement in SSRS.
• Migrated data from Oracle to SQL Server data warehouse and to generate teh reports using SSRS for different SSAS Cubes. Created several MDX queries according to business requirements.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Environment: Microsoft SQL Server 2005, Visual Studio 2005, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, Data Warehousing, ETL, Data Marts, Business Analysis, MS Access, RDBMS, Business Intelligence, Oracle 10g / 11g, PL/SQL, .NET.

Confidential, Alpharetta, GA

MS SQL Server Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services (SSAS) & Reporting Services (SSRS) wif teh help of some XSTL Style sheets.
• Used shell scripts and PERL scripts for automating teh processes.
• Worked on teh data warehouse design and analyzed various approaches for maintaining different dimensions and facts in teh process of building a data warehousing application.
• Planned, defined and designed data flow processes for data migration to teh Data Warehouse using DTS.
• Used Performance Point Server 2007(PPS) application.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports wif drill down, drill through and drop down menu option using SSRS by SSMS.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Build ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
• After installing teh SQL server 2005, migrated teh existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Created SSIS packages for File Transfer from one location to teh other using FTP task and Designed SSIS packages to extract data from flat files and oracle database.
• Integration Services (SSIS) -- Data sources and package connections. Control flow objects and data flow adapters. Debugging, deploying, and configuring SSIS packages. Securing and executing packages. Securing SSAS cubes. Querying cubes.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Business Intelligence Development Studio (BIDS) -- Using BIDS to create, edit, and deploy SSRS, SSAS, AND SSIS projects. Developed deployed and monitored SSIS packages including upgrades DTS to SSIS.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Migrated data from Oracle to SQL Server data warehouse and to generate teh reports using SSRS for different SSAS Cubes. Created several MDX queries according to business requirements.
• Analysis Services (SSAS) -- Creating data sources and data source views (DSVs), named calculations and named queries. Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs), perspectives, measure group partitions, partition aggregations, data mining models. Deploying and processing SSAS objects.
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cubes.

Environment: SQL Server 2000/2005/2008 , ORACLE, Windows Server 2000/2003, SSRS, SSIS SSAS, ASP.NET, C#, VB.NET, ASP.NET, Visual Basic, ASP, MTS, Excel, MS Access, Visio, ERWIN.

Confidential

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Experience in MOLAP (Multi dimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Involved in performance tuning (DB Tuning) and monitoring of T-SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Fine-tuned teh logic in Procedures, Functions and Triggers for optimum performance.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005.
• DB Tuning And optimizing SQL Server by using performance monitor.
• Create packages, procedures, functions and triggers. Handle database performance and DB tuning.
• Created SSIS process design architecting teh flow of data from various sources to target
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.

Environment: SQL Server 2000/2005, SSRS, SSIS, SSAS, VBScript, ASP, .Net, Excel, MS Access, Visual Basic 6.0, and Windows 2000/NT 4.0

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in planning & design.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005.
• Fine-tuned teh logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data.
• Involved in performance tuning (DB Tuning) using indexing (Cluster Index, Non Cluster index) tables.
• SQL Server used for database and ADO used for database interaction

Environment: SQL Server 2000/2005, Windows XP, JSP, Web logic, HTML, Java Script, VB Script.

Confidential

MS SQL Server Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Used DTS, T-SQL, scripts, stored procedures and views to run routine reports.
• Maintained a good client relationship by communicating daily status and weekly status of teh project.
• Managed requests that came from teh client as well as teh development teams.
• Designed and developed teh logical and physical model of teh database using ERWIN.
• Coding for Financial history module in teh application.
• Handling functionalities in screens abiding teh MVC pattern.
• Identifying and creating model classes, factory classes and manager classes.
• Creating controller classes and view adapters interfaces for loading teh Views.
• Creating user controls handling UI functionalities for financial history Screen.
• Creating teh request/response translators to send /receive teh financial history information from AIA service.
• Worked on MS SQL Server tasks such as data loading, batch jobs, DTS, and Indexes.
• Created and automated regular jobs.
• Managed and monitored system utilization.
• Managed backup and disaster recovery of teh team.
• Managed teh security of teh servers (Logins and users).
• Designed stored procedures and triggers for automating tasks.

Environment: MS SQL Server 2000, ASP.Net 2.0, C#, MS Access, Query Analyzer, DTS, SQL Profiler, Import & Export Data.