SUMMARY

• A skilled software professional with over 8 years of experience as a SQL and BI developer in Financial, Sales & Marketing, Insurance, and HealthCare Sectors.
• Expert in installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008 in Windows Environment, BI components (DTS/SSIS, SSRS, SSAS,PPS).
• Expert in database Design, Development for OLTP (Batch Processing, Online Processing), OLAP, Star and Snowflake schema, ETL, MDX, Data warehousing, Data mining and Data Modeling.
• Experienced in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles, creating hierarchies, Creating Cell Level Security in SSAS writing Scopes, MDX expressions and creating Roles and Groups.
• Expertise in merging data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, and Bulk Insert utilities.
• Expertise in Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in migrating DTS Packages to SSIS, Migrating databases from SQL 2000 to SQL 2005, and troubleshoot migration issues, Importing and exporting packages to SQL Server and file system.
• Excellent experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experienced in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages, Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experienced in Configuring and maintaining Report Manager and Report Server for SSRS.
• Deployed and Scheduled the Reports in Report Manager, Ad - hoc reports, data driven subscription reports using Report Builder.
• Expert in developing Dashboards, Parameterized Reports, linked reports and Sub reports.
• Highly Experienced in creating Views, Triggers, Functions, Batch Scripts and stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
• Expert in writing Complex T-SQL queries, dynamic-queries, sub-queries and complex joins, Stored Procedures, Views, Triggers and Complex Queries on SQL Server 7.0/ 2000/2005/2008 .
• Worked on administration tasks involving batch jobs, backup and Recovery, Maintenance tasks, upgrades, creating logins, user mapping, databases/File groups/files/Transaction logs.
• Expert in Object oriented programming concepts.
• Excellent Communication skills.
• Has excelled as team player and equally excelled when worked individually.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• MS SQL Server Reporting Service 2005/2008
• MS SQL Server Analysis Services 2005/2008
• MS SQL Server Integration Services 2005/2008
• DTS
• MS Visio 2003
• MS Access
• FrontPage
• Visual Basic 6.0
• ERWIN
• Windows 9x/NT/2000/XP/Server 2003
• T-SQL
• HTML
• XML
• VBScript.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

MS SQL Server Developer (DBA and SSAS Architect)

Responsibilities:

• Responsible for migrating current DB2 objects in SQL Server.
• Assisting DBA’s in production support.
• Responsible to take actions for daily issues and AdHoc Queries.
• Maintain the OLAP cubes for accurate reporting.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Editing T-Sql queries, Stored procedures, Jobs and other objects in SQL.
• Developed report specifications, created and modified reports using SSRS 2008.
• Responsible to monitor daily and weekly Jobs and respond on failure.
• Maintain and check tuning of OLAP cubes performances.
• Maintain datasources and datasets shared with reporting services.
• Responsible to synchronize environment between test and production environment.

Environment: MS SQL Server 2008/2005, SSAS, SSRS, Visual Studio 2005, SQL Profiler/Analyzer, Management Studio, VB Script, XML.

Confidential, New Jersey

MS SQL Server Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Responsible for developing source to target mappings
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Developed report specifications, created and modified reports using SSRS 2008.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Created OLAP Cubes from the integrated data and generated reports on those cubes.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning on SQL SERVER 2000 & 2005 servers.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
• Planned a complete backup on the database and restored database from disaster recovery.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008, SSIS, SSAS, SSRS, Oracle10g, Visual Studio 2005, VSS 2005, Erwin r7.2, Windows NT/2003, asp.net, MS Access.

Confidential, NY

MS SQL Developer/ BI Developer

Responsibilities:

• Designed ETL (Extract, Transform, Load) strategy to transfer data from source to stage and stage to target tables in the data warehouse tables and OLAP database from heterogeneous databases using SSIS and DTS (Data Transformation Service).
• Used ETL which transfers data from Remote datacenter to local datacenter using SSIS. Cleaning, massaging of the data is done on local db. From local database created cubes in SSAS.
• Used reporting services created several reports based on cube and local db.
• Developed SSIS packages to export data from Excel (Spreadsheets) to SQL Server, automated all the SSIS packages and monitored errors using SQL Job on a daily basis.
• Prepared reports using SSRS (SQL Server Reporting Service) to highlight discrepancies between customer expectations and customer service efforts which involved in scheduling the subscription reports via the subscription report wizard.
• Involved in generating and deploying various reports using global variables, expressions and functions using SSRS.
• Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Involved in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in designing and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained referential integrity using SQL server
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Monitored scheduled jobs and alerts created for SSIS packages and SSRS reports in SQL Server
• Implemented complex business requirement in backend using efficient stored proceduresand flexible functions, and facilitated easy implementation to the front end application.
• Closely interacted with subject matter experts in understanding the business process methodology.

Environment: MS SQL Server 2008/2005/2000 , SSAS, SSIS, SSRS, SQL Profiler/Analyzer, Management Studio, Import/Export Wizard, Excel,, Windows Performance monitor, XML.

Confidential, Franklin Park, NJ

MS SQL Server SSAS/SSRS/SSIS Developer

Responsibilities:

• Installed and upgraded existing SQL Server 2000 database to SQL Server 2005
• Developed physical software models and created three-tier applications.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Created object-oriented UML diagrams.
• Designed data models and Entity relationship diagrams using MS Visio, Erwin.
• Gathered requirements from the end user.
• Wrote user requirement documents based on functional specification.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Created indexes, Constraints and rules on database objects for optimization.
• Performance tuning to optimize SQL queries using query analyzer.
• Add restore users and password to system database.
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Normalize database using Boyce-Codd normal forms.
• Provided and implemented database replication.
• Responsible for database performance tuning.
• Created indexes, Constraints and rules on database objects for optimization.
• Created various Table and Views to ensure the increase performance of application.
• Built complex multi-sectional reports with charts and drill-down capabilities

Environment: MS SQL Server 2000/2005, DTS, MS SQL Server Reporting Services 2005,Crystal Reports, SSIS, Windows XP / NT / 2000, MS Office 2003, Excel 2003,C#.NET, SSMS (SQL Management Studio), ERWIN

Confidential, Erie, PA

MS SQL Server Developer

Responsibilities:

• Created various Table and Views to ensure the increase performance of application.
• Gather real time operation data to create flight, truck dispatcher and sort reports.
• Analyze operation data and provide real time operation updates.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using MS Access.
• Created SQL Server and MS Access reports for the manager and the senior manager involved and formatted the report layout for the requirement of the end users.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Created indexes, Constraints and rules on database objects for optimization.
• Provided system maintenance and update.
• Responsible for database performance tuning. Involved in designing and developing various Web Forms & Class Libraries in .NET & C#.

Environment: MS SQL Server 2000, MS Access, MS Word, MS Excel, UNIX, Windows NT, Windows 2003,C#.Net