SUMMARY

• Over 8+ years of extensive experience in database activities like Data Modeling, Database Design and Development, Coding, Implementation, Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication on Windows and Unix environments.
• Experience in Analysis, Design, Documentation, Development, Testing and Implementation in Client/Server applications using Microsoft SQL Server 2005/2008 and BI Suite for various Business, Finance and Health care domains.
• Expertise in Relational Database Management Systems using SQL Server 2000/2005/2008.
• Proficient in Database Programming and Development using SQL Server and good experience in creating T - SQL (DDL, DML), Triggers, Views, User Defined Functions and Complex Stored Procedures.
• Expertise in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with Import/Export data, Bulk insert and BCP.
• Experience in SQL Server 2005 OLAP database development including KPIs, Data Mining, working with slowly changing dimensions (SCD).
• Expert in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Expert in Microsoft SharePoint Server and IIS web server to produce sites for file sharing, web databases and web publishing.
• Supported team in resolving SQL Reporting services and T-SQL related issues and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Sub reports and formatting them.
• Expert in using different Recovery Models simple, full and bulk-logged depending on availability of database.
• Proficient in creating logical and physical data models using Erwin data modeling tool.
• Managed full life cycle Custom Development for several business applications from inception to completion.
• Ability to quickly learn and adapt to teh rapidly changing Internet economy.
• In-depth knowledge in Object Oriented Concepts and experience in OOAD Technologies, developing Use Cases, Activity diagrams, Sequence Diagrams and Class Diagrams using case tools like Rational Rose.

TECHNICAL SKILLS

• MS SQL Server 2008 2005 2000 7.0
• Microsoft Reporting services
• Windows 2000/2003 Advanced Server
• Windows Exchange Server 2003
• Windows NT 4.0/3.5
• Windows9.x
• Windows XP
• Unix
• Linux
• Red Gate
• MySQL
• MS-Access
• Oracle8.me
• Oracle 9.me
• C
• C++
• C#
• T-SQL
• Java
• HTML
• DHTML
• ASP.Net
• XML
• Java Script
• Perl Script
• MS Visual studio 2005
• Crystal Reports
• ERWIN 7.1
• Microsoft SharePoint
• Microsoft Visio 2003

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

MS Business Intelligence Developer

Responsibilities:

• Created Star schema dimension modeling for teh data mart using Visio and created dimension and fact tables based on teh business requirement.
• Gathered report requirements and determined teh best solution to provide teh results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• DesignedSSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into teh SQL table
• Produced operational reports in SSRS 2008 me.e. drill-down, drill-through, dashboard and matrix reports.
• Developed SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from teh relational database and OLAP as SSAS 2008 source
• Generated monthly and quarterly reports as bar charts for teh management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in teh design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports
• Configured teh report server and generated teh report models for user interactions
• Responded to ad hoc requests and special projects that require immediate attention while at teh same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Tampa, Florida

MS Business Intelligence Developer

Responsibilities:

• Migrating databases from SQL 2005 to SQL 2008 in production and test environments.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced teh database structures and database objects.
• Used conditional formatting to change teh behavior of teh report depending upon teh requirement.
• Debugged and deployed reports in SSRS.
• Generated various Report models on Views (due to security issues) and deployed them on to teh production reporting server and generated various Report models and ad-hoc reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format teh contents of teh report according to teh requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created several SSIS packages in Microsoft SQL Server 2005.
• Transferred data into various formatted files and immediately updated my managers with teh automated email systems.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance.
• Used config files in SSIS to ease teh process of moving teh packages across servers (development to production)
• Used Microsoft SharePoint Server to provide a framework for web application development.
• Optimized queries by looking at Execution Plan for better tuning of teh database.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Confidential, Moosic, PA

MS SQL Server/SSRS/ SSIS Developer

Environment: MS SQL Server 2005/2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Responsibilities:

• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
• Created business process diagrams defining current business processes.
• Generated reports using MS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
• Constructed teh OLAP cube using SSAS and used SSIS to transform teh data into OLAP.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in teh project from planning stage to pushing codes to production.
• Designed ER diagrams and mapped teh data into database objects and performed normalization of teh database in OLTP.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agentusing SSAS.
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Worked as a technical expert in teh design, development, and maintenance of OLAP cubes and databases
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Performed system study and requirements analysis, prepared data flow diagrams, entity relationship diagrams, data diagrams, and table structures to store teh data.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean teh old data and also halped teh front end application developers with their queries.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
• Used business object tools to develop reports and accessed, formatted, and delivered information to large populations of users.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for teh clients as per their requirements using SSRS in MS SQL 2008.

Confidential, Charlotte,NC

MS SQL Server/SSRS/ SSIS Developer

Environment: MS SQL Server 2000, SSIS, SSRS, SSAS, Oracle10g, Visual Studio 2005, VSS 2005, Erwin r7.2, Windows NT/2003, ASP.NET, MS Access.

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 transformations constraints.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form teh 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.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Developed report specifications, created and modified reports using SSRS 2008.
• Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Created OLAP Cubes from teh integrated data and generated reports on those cubes.
• 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 (SQL Server Analysis Service).
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master and static.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Created cube structure for teh 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.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2000.
• Used “SQL Profiler T-SQL Duration” template for tracking execution time of T-SQL Statements.
• Planned a complete backup on teh 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.

Confidential, Chicago, IL

MS SQL Developer/BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Created complex Stored Procedures, triggers, tables, views and SQL joins and statements for applications.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
• Implemented triggers for automating tasks.

Confidential

SQL Server Developer

Responsibilities:

• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing teh physical design for teh database.
• Responsible for drafting documentation for describing teh metadata and writing technical guides.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs.
• Involved in Implementation of database design and administration of SQL based database.
• Optimized queries and stored procedures.
• Wrote T-SQL procedures to generate 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.
• Created Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications
• Responsible for transferring of teh databases and database objects from Development to Production Server using DTS.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures