SUMMARY:

Over 7+ years of experience in Microsoft SQL Server and extensive experience in Microsoft Business Intelligence Tools – SSIS, SSRS, SSAS, etc.

• Experience in MS SQL Server 2008R2/2008/2005/2000, SSIS/SSRS/SSAS, Database Migration, Physical/Logical Data Modeling,Performance-Tuning, Troubleshooting, Data-Warehousing and Normalization/ Demoralization techniques.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Experience with T_SQL (DDL and DML) in constructing tables, user defined functions, views, complex stored procedures, relational database models, data dictionaries, data integrityand appropriate triggers to facilitate efficient data manipulation and consistent data storage.
• Efficient in writing complex T-SQL queries using Joins.
• Experience in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Experience in creating SSIS packages and migrating DTS packages from SQL server 2000 to SQL server 2005/2008.
• Extensive ETL experience using DTS/SSIS for data extraction, transformation and loading from OLTP systems to ODS and OLAP systems.
• Experience in Extraction of data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP and Bulk Insert utilities.
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Expert in scheduling jobs for SSIS Packages and sending Alerts using SQL Mail.
• Adept in designing Stylish Report layout and have extensive experience in generating Drill down and Drill through as well as Slice and Dice reports with Drop down menu option, sorting the data, Sub reports defining subtotals in SSRS 2005/2008/2008R2.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading parameters, matrix dynamic reports and other features of reporting services.
• Experience in creating dashboards, scorecards and building reports using performance point server and Silverlight.
• Experience in integrating the SSRS reports into web applications using report viewer control and URL methods and creating data driven subscriptions to different users using Report Manager.
• Experience with Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2008/2005.
• Experience in Cube designing in BIDS (SSAS) and to edit various properties including the measure groups and measures, cube dimensions and dimension relationships.
• Experience in calculating measures and dimension members using multi-dimensional expression (MDX), creating data source views, named queries, mathematical formulas and user-defined functions in SSAS, and deploying of analysis services projects.
• Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, Database consistency checkusing DBCC utilities and Database Engine Tuning Advisor.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

MS SQL server 7.0/2000/2005/2008, Oracle, Teradata, MS Access

Languages

Transact- SQL, SQL,HTML, XHTML, C

ETL Tools

SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica.

OLAP/Reporting Tools

SQLServer Analysis Service (SSAS), SQL Server Reporting Service (SSRS), Crystal Reports, Business Objects.

SQL Server Tools

SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

Data Modeling Tools

Erwin tool, Microsoft Visio 2000/2003

Operating Systems

Windows NT/98/2000/XP/Vista/2003, MS-DOS

Other Tools

Microsoft Visual Source Safe, Microsoft Office, MS Visio.

EDUCATION & CERTIFICATIONS

• Bachelor of Computer Science
• Microsoft Certified in Business Intelligence-Implementation & Maintenance using MS SQL server 2005(MCTS 70-445).

PROFESSIONAL EXPERIENCE

Confidential is a global banking company and one of the world\'s largest corporations. Confidential
has a long-demonstrated commitment to the institutional marketplace, including corporations, brokerage, public funds, Taft-Hartley plans, foundations and endowments.

Responsibilities:

• Developed and created new database objects including tables, views, triggers, stored procedures, user defined functions, complex SQL Queries, clustered and non-clustered indexes to implement the business logic.
• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and also created SQL scripts for tuning and scheduling.
• Wrote queries using Dynamic SQL to reduce complexity of the queries and improve performance
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in different environments.
• Maintain existing ETL processes and trouble shoot issues as they arise.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server and Flat files.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Used various Transformations in SSIS Dataflow, Control Flow using For Loop Containers and Fuzzy Lookups, etc.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Created package configurations for dynamic connection string to enhance the ease of package deployment.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• DevelopedDrill Down, Drill through, Cross tab reports, Parameterized Reports andReport Modelsfor generatingAd-Hocreports as per the client requirements.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Defined Key Performance Indicator metrics to create scorecards.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Defined Schemas, i.e. relationships between Measure groups and Dimensions in SSAS.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Optimized queriesby using Execution Plan for better tuning of the database.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point Server, XML, MS Visual Source Safe.

Confidential is a worldwide developer, manufacturer and marketer of medical devices whose products are used in a range of interventional medical specialties, including interventional cardiology, peripheral interventions, neuro modulation, neurovascular intervention, electrophysiology, cardiac surgery, vascular surgery, endoscopy, oncology, urology and gynecology.

Project Description: Manufacturing Execution System (MES) will record every piece of data they produce in their plants. We have 4 plants which produce Pace makers. MES Reporting is all about generating reports from the MES System for their product builders in order to provide good vision about their plants.

Responsibilities:

• Developed and created new database objects including tables, views, indexes, triggers, stored procedures and functions, also updated statistics using Query analyzer and Enterprise Manager on the existing servers.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Created the automated process for the activities such as database backup processes and SSIS packages run sequentially using SQL Server Agent job
• Created report models for ad-hoc reports using SSRS.
• Developed reports from OLAP cubes using ProClarity and SSRS.
• Designed and developed Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reports, dynamic sortingusing various features like Charts, graphs, pie, filtersetc.
• Created Drill-through, Drill-down, Parameterized, Cross Tab and Sub-Reports using Report Designer and Report Builder based on the requirements.
• Formatted the reports using Global variables, Expressions and Functions using SSRS.
• Designed and developed Dashboards and Scorecards according to business requirement using SSRS.
• Created complex reports like weather reports, map reports etc.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources like SQL Server to MS Access, Oracle10g, text files and Excel files using SSIS/DTS.
• Responsible for developing, monitoring and deploying SSIS packages.
• Experienced in implementing Slowly Changing Dimension wizard and Check Sum Transformation to load data into slowly changing dimensions in data warehouse.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data and Unnecessary Data like removing empty rows.
• Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Generated periodic reports based on the statistical analysis of the data using SSRS.
• Experienced with writing MDX which multi dimensional queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
• Developed backup/restore and recovery procedures, performing weekly backup databases by using SQL Server 2005 and restoring these databases in different server.

Environment: SQL Server 2008/2005 Enterprise Edition, SSRS, SSIS, Windows 2000/2003 Enterprise Server, XML, MS Excel, MS Access, MS Visio 2003, and Visual source safe (VSS), Crystal Reports 8.0.

Confidential, Chicago, Illinois April 08 - May 09
SQL Server BI Developer (SSAS/SSIS)

Confidential is an international financial services company headquartered in Chicago, Illinois, USA. It is a leading provider of investment management, asset and fund administration, fiduciary and banking solutions for corporations, institutions and affluent individuals worldwide.

Responsibilities:

• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS).
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Experienced with writing MDX which multi dimensional queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
• Defined Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security Roles in SSAS.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPIs) in SQL Server 2005 Analysis Services (SSAS) using ProClarity and published via Windows Share Point Services.
• Created Partitions, Calculated Members, Schemas, and File Groups for Fact Tables and Cubes.
• Designed and developed various reports on SSAS Cubes as the data source.
• Generated specifications for analysis reports by using SQL Server Reporting Services (SSRS) 2005.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options inSSAS.
• Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
• Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS.
• Involved in migration of DTS Packages (2000) to SSIS and troubleshoot migration issues.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Designed dynamic DTS Packages for Landing-Pad to transfer data between servers, load data into database, and archived data file from different DBMS.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Created complex stored procedures, views, functions, triggers and sub queries, T-SQL scripts, dynamic SQL, Clustered and Non-clustered Indexes.
• Experience with Data migration utilities (Import and Export, BCP, Bulk Insert) from text to SQL Server.
• Designed SSRS reports with sub reports, expressions and queries, and preparing Ad-Hoc reports through report builders.

Environment: MS SQL Server 2000/2005, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, PERL, VB, Visual studio2005, Erwin, Windows Server 2003.

Confidential, Boston, MA Oct ’ 07 - March 08
SQL BI Developer /Admin

It’s an investment advisory firm that provides investment strategies to high-wealth individuals, trust and pension funds, and endowments. The company’s data repository resides on a server that communicates with the external investment company using SQL Server 2000 Data Transformation Services. My responsibilities were to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which includes assisting in administration of various databases in both development and production environment.

Responsibilities:

• Upgraded to SQL server 2005 version from SQL server 2000.
• Analyzed business, functional, and technical requirements to make sure project met expectations.
• Used SQL Statements to Present Query responses like creating tables, relationships, stored procedures, functions triggers, views and indexes for enforcing business rules.
• Developed ad-hoc SQL queries to support requests.
• Used multitask data pump in SSIS/ETL.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract datafrom database tables and write the data to text files.
• Developed SSIS packages/DTS to bring data from Oracle, Excel and Flat Files.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore, Index design and analysis.
• Implemented and managed database backup and recovery strategies.
• Generated test data and tested database to meet the functionalities deliverables in the project
• Generated database SQL scripts and deployed databases including installation and configuration.
• Designing and building data load procedures, using MS SQL Server.
• Worked on scheduling jobs and sending Alerts using SQL Mail.
• Created Users and Roles, and managing security and permission of database and error logs.
• Analyzed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Involved in creating Technical Specification Document (TSD) for the project.

Environment:MS SQL Server 2000/2005, T-SQL, SSIS, SSRS, SQL Profiler, SQL Server Enterprise Manager.

Confidential June 05 – Aug 07 
SQL Server Developer/Software Programmer

Confidential is the world\'s most sophisticated banking and insurance software company. Confidential is the chosen outsourcing partner for 10 of the top 15 global banks and 6 of the 10 top global insurance companies. Confidential offers state-of-the-art, comprehensive solutions for core banking, corporate banking, wealth and asset management and insurance.

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, advanced queries, views, indexes, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Developed web based ASP.NET internet applications.

Environment: SQL Server 2000, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, Microsoft Visio 2000.