SUMMARY

• Over 9 years of intensive experience as SSIS/SSRS/SSAS Developer and SQL Developer in financial, insurance, VoIP domains.
• Potential experience in all the stages of software development life cycle (SDLC) including business process analysis, requirements gathering & analysis, high level design, detailed design, development, testing, QA and post implementation support.
• Area of Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Hands on experience in T - SQL queries DDL/DML, creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Adept in RDBMS concepts and constructs along with objects creation such as Databases, Tables, Normalization, UDFs, User Defined Data Types, Indexes, Views, Cursors and Triggers.
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005/2008 with .NET, Import/Export data, Bulk insert and BCP.
• Mainly involved in migration from heterogeneous sources including Excel, Flat file, Oracle, Access, Sybase to MS SQL Server.
• Demonstrated Experienced in creating Jobs, Alerts, SQL Server Agent, and scheduling SSIS Packages.
• Implemented transformations like Aggregate, Lookup, Data conversion, Merge Join etc using SSIS
• Excellent understanding of data warehousing technologies and concepts including star schemas, snowflakes schemas, Slowly Changing Dimensions, ETL processes, dimensional modeling and reporting tools.
• Proven ability in creating and modifying multi dimensional cubes using SQL Server Analysis Services (SSAS).
• Proficient in implementing surrogate key generation strategy in Data warehouses.
• Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experienced in writing parameterized queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting and group the data, Defining Data Source and subtotals for the reports using SSRS 2005/2008.
• Experienced with Drill down reports, Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Adept in installation, upgrade, troubleshooting and configuration of MS SQL Server 2000/2005/2008 databases.
• Organized, dependable and punctual with critical thinking, good interpersonal. Team-oriented, technically creative and motivated. User oriented with a desire to learn client's business requirements.
• Excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000/7.0/6.0
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Business Intelligence Development Studio (BIDS)
• DTS (Data Transformation Services)
• Import/Export Data
• Bulk Insert
• BCP
• SQL Profiler
• SQL Query Analyzer
• Enterprise Manager
• Management Studio
• Replication
• SQL Agent
• Oracle 8/8i/9i/10g/11g
• MS Office
• C
• C++
• C#
• ASP
• PL/SQL
• T-SQL
• HTML
• XML
• ASP.Net
• MS Visio 2003/2007
• Windows NT/2003/XP/VISTA
• Unix
• Linux.

PROFESSIONAL EXPERIENCE

Confidential, CA

MS SQL Server Developer/BI Developer/ ETL Developer

Responsibilities:

• Participated in Software Development Life Cycle and being involved in Agile Methodology, Monitored Daily stand up calls and weekly Sprints discussing on business requirements and implement them using MS Visio 2007 and provided technical documentation.
• Developed flowcharts for complex stored procedures.
• Involved in writing T-SQL queries, Stored Procedures and used them to build packages and handled slowly changing dimensions to maintain the historical data.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, tuning SQL queries, stored procedures, generating GUIDs, writing Common Table Expression to improve the performance.
• Work also included debugging of CF pages and checked database issues related to Store Procedures and UDFs.
• Stored configuration information in SQL Server table for the migration from development server to production server and used various dataflow and control flow transformations for ETL.
• Designed SSIS Packages to transfer data from various heterogeneous sources like CSV Files, Text Files, DAT Files, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Also involved in scheduling Jobs to call the packages for Daily Load using SQL server Agent.
• Responsible for setting up Automated Email Notifications on Success or Failure of ETL Model.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Generated Sub-Reports, Drill down reports, and Parameterized reports using SSRS.
• Created Tabular reports, Matrix reports, List & Chart reports, Cascading Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment

Confidential, Mountain View, CA

BI Developer/ ETL Developer

Responsibilities:

• Involved in planning and designing database based on business requirement using MS Visio 2007 and provided technical documentation
• Involved in creating complex stored procedures, functions, triggers, cursors, tables, views, and other SQL joins and statements for applications.
• Modified database structures as well as configuration and storage allocation to support application enhancement and automated tasks by creating SQL Jobs in SQL Server Agent.
• Work also included creation of ASP pages and applied different Validations, Check code for ACID properties and also involved in development of various Reconciliation Applications.
• Involved in migration of data from SQL Server 2005 to SQL Server 2008 and performed migration using Copy Database Wizard in SQL Server 2008.
• Stored configuration information in SQL Server table for the migration from development server to production server and used various dataflow and control flow transformations for ETL.
• Involved in creating SSIS process design architecting the flow of data from heterogeneous sources (flat file, excel, access) into SQL Server using Business Intelligence Development Studio.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Creating reports for users in different departments in different continents using web-enabled reporting by SQL server reporting services.
• Created sub-reports to present more detailed information about the summary.
• Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005.

Confidential, Milpitas, CA

BI Developer/ ETL Developer

Responsibilities:

• Involved in the logical and physical design of the Data mart using dimensional modeling.
• Used data dictionaries in understanding the meta data and designing the target database
• Involved in designing database objects like Pat index, Materialized views, user defined functions, triggers, stored procedure, constraints, roles and documented all the procedures involved in the database for future reference.
• Experienced in Performance Tuning in SQL Server 2005 using SQL Profiler and Data Loading.
• Implemented the surrogate key generation strategy in the data warehouse.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Involved in creation of Inventory Management Applications using ASP.net and created application logic using C#.
• Created Alerts for successful or unsuccessful completion of the scheduled jobs using Sent Mail Task.
• Also Responsible for SSIS Logging and Error Handling using SQL Server Integration Services.
• Data migration from flat files and from RDBS sources like Oracle and SQL Server to SQL Server.
• Designed the SSIS Dynamic Packages using Configuration File in order to transfer data from OLTP to data mart.
• Used conditional formatting to change the behavior of the report depending upon the requirement.
• Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
• Created ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
• Responsible for the deployment of the reports on the reporting services website.
• 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.

Confidential, South Birmingham, AL

BI Developer/ETL Developer

Responsibilities:

• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Installed and configured SQL Server Reporting Services (SSRS) 2005.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Also involved in creating various charts using SSRS from a different data sources as well as Analysis Services Cubes and deploy on the server
• Served as technical expert guiding choices to implement analytical and reporting solutions for client.
• Extensively involved in designing the SSIS packages to export data of heterogeneous source to SQL Server database.
• Experienced in creating complex SSIS packages using proper control and data flow elements with error handling.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, For Each Loop, Multi Cast and column conversion.
• Enhanced and deployed the SSIS Packages from development server to production server.
• Created OLAP applications with OLAP services in SQL Server and build cubes with many dimensions using both star and snow flake schemas.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.

Confidential, Bloomington, IL

BI Developer/ETL Developer

Responsibilities:

• Performed activities such as database creation, database tuning, performance planning.
• Actively involved in Normalization & De-normalization of database.
• Materialized views, dimensions and stored outlines for optimal performance.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Design, Coding Standards, Periodic Data refresh, database upgrades across the enterprise.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Wrote SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Created Fact tables and dimension tables for data ware housing applications and populated the tables from the OLTP database using SSIS packages.
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
• Effectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).
• Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Experienced in building and maintaining Data marts.

Confidential, Birmingham, IL

ETL Developer/MS SQL Server Developer

Responsibilities:

• Worked with SQL to create Tables, Views, and Triggers and stored Procedures.
• Testing of T-SQL scripts and performance tuning of those scripts as well as documentation.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL in Management Studio.
• Used SQL profiler to capture slow running queries and stored procedures and used Windows Performance Monitor as a tool for performance tuning.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules Responsible for tuning T-SQL procedures, triggers and other database objects
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Assisted team with data validation, statistical analysis and complex reports.
• Performed unit testing and support user acceptance testing.
• Designed and developed SSIS packages for transferring data to flat files and Access files

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in publishing technical documentation to set coding standards and SQL Server Database Dictionary, Database upgrades across the enterprise.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server
• Performed development support, document reviews, test plan, integration of the system.
• Worked on Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzed the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Managed historical data from various heterogeneous data sources (i.e. Excel, Access).