SUMMARY:

Over 7+ years of IT experience in Analysis, Database Design , development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.

• Strong experience in MS SQL Server 2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS),
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005 and SQL Server 2008
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility and automation with SSIS
• Experience in SQL Server Analysis Server MDX Queries
• Created the datasets based in MDX Queries and implemented performance and analysis reports using SSRS.
• Worked with OLAP and Data warehouse application and worked with star schema, snowflakes schema dimensions and worked with implementing SSAS, and SSRS tosupport largeReporting needs.
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2005
• Experience in creating and managing database objects like Tables, Views, Triggers, Cursors, Stored Procedures, user defined data types and functions
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
• Experienced using in FTP and SFTP servers to upload files
• Migrated data from SQL 2000 to 2005 and solved related issues.
• Experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Good knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them)
• Excellent T-SQL Programming skills. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Good knowledge in implementing Log Shipping, Database Mirroring
• Created complex DTS Packages for Data Migration and Transformation
• Experience in developing and monitoring SSIS Packages
• Extensively worked on system analysis, design, development, testing and implementation ofprojects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and developed data models (physical/logical data models) based on the given specs and requirements.
• Expertise includes FACT & Dimension Tables
• Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 7.0/2000/2005/2008.
• Good Knowledge in Physical and Logical Data Modeling.
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player

Technical Skills:

Windows Server 2000/2003/2008
Windows XP/Vista

Languages

T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML, Java Script

Tools/Utilities

Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Toad, Ervin

Databases

MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access

Data Modeling Tools

Microsoft Visio, UML

Software

MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services

Excel, SQL Server Reporting Services, Crystal Reports, Business Objects

EDUCATION

Bachelor’s in Computer Science

Professional Experience:

Confidential, NJ Oct 2009 - present
Role: Business Intelligence Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) 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, navigation reports (Hyperlink) 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, matrix, 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 models using Framework Manager and deployed packages to the Report Net Servers.
• Created pages in the reports to display depend on Prompt values.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Involved in creating Cubes using SQL Analysis Services (SSAS)

Environment: SQL Server 2008/2005, DTS, SSIS, SSRS, SQL Server OLAP 2005, Reporting Services 2005, T-SQL, MS Access, Windows 2003 Server

Confidential, NY Sep 2008 – Sep 2009
Role: SQL Server Analyst/ BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed source/target analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Used the SSIS ActiveX script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Created package configuration using environment variables.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Used data compression techniques for Back Up.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Performed CDC and Change tracking on OLTP systems.
• Created OLAP cubes & wrote MDX queries for user reports.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows 2003 Server/XP, IIS7, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, ADO.Net, OLE DB, DTS Package, SSIS.

Confidential, FL Apr 2007 – Aug 2008
Role: SQL BI Architect

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification
• Involved in the System study and Database Design using MS SQL Server 2005.
• Created tables, fields and attributes. Defined constraints primary and referential Integrity, defined indexes etc.
• Involved in creating Sequence Diagrams and also involved in creating dynamic models using UML.
• Created different objects: Stored Procedures, triggers to populate data into different tables according to different parameters specified.
• Analyzed the Data quality, Data validating, Data mapping to migrate data to SQL server to over 60 tables.
• Developed various stored procedures used in the application using T-SQL.
• Wrote complex T-SQL queries for data extraction.
• Wrote DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created/modified several Daily running and Month-End Jobs to meet the project specifications.
• Bulk copy operation using BCP and Bulk Insert for transferring data to the SQL server from different database sources.
• Developed web pages in ASP using VB and C++.
• Transferring data between XML document and SQL server using SSIS.
• Created indexes and proper re-indexing for intensive OLTP system to ensure best performance.
• Worked with Analysis Services that supports OLAP to design, create, and manage multidimensional structures that contain data aggregated from other data sources.
• Developed custom reports using Crystal.
• Tuning SQL query for better performance.

Environment: Microsoft SQL Server 2005/2000, T-SQL, XML, Windows 2000 Server, Crystal Report 8.5/10, SQL server Integration Service(SSIS), SQL Server Reporting services(SSRS), ASP.Net, Visual Studio.Net2005

Confidential, Philadelphia
Duration: Oct 2005 – Mar 2007
Role: SQL Server Developer/BI Developer

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2008 databases servers.
• Successfully migrated old data from legacy systems (FoxPro) and external system including DB2 and excel into SQL Server 2005 using SSIS, BCP and ActiveX scripts.
• 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.
• Worked on Multidimensional Expressions (MDX) to query multidimensional data or to create MDX expressions for use within a cube.
• Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Worked with business/functional analysts to determine reports and analytical requirements.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Documented Report Models and Report Templates for other Team Members.
• Created Prototypes of some complex reports and validated from the production.
• Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.
• Categorized reports into batch reports and on demand reports and scheduled it according to that.
• Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
• Involved in checking various Performance issues using RS objects of the reports in SSIS, SSRS, and SSAS and in data integrity issues.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Worked on Database space management, performance monitoring and alert management.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.
• Experienced in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.

Environment: SQL Server 2008/2005, Business Intelligence Tool 2005/2008, Visual Studio 2005/2008, DTS/SSIS, T-SQL, Unix, Shell scripts.

Confidential, India Oct 2004 - Sep 2005
Role: SQL Server Developer

Responsibilities:

• Created new tables, views, indexes and user defined functions.
• Actively designed the database to fasten certain daily jobs and some stored procedures.
• Optimized queries to improve performance by creating indexes.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Wrote T-SQL statements to retrieve data.
• Used SQL Analyzer and Profiler for analyzing the SQL statements and procedures.
• Performed daily database backup & restoration and monitored the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Installed and Configured SQL Server 2000 on development server for designing and testing full text search.
• Access SQL Server using front end applications like .Net

Environment: MS SQL Server 2000, Oracle, Enterprise Manager, T-SQL, DTS, Windows2003, Query Analyzer, SQL Profiler.