SUMMARY

• Over 7 years of IT Experience in Database Design, BI - Development of Microsoft SQL Server 2008/2005 on various development, test and production environments with various business domains like Financial, Insurance and Manufacturing.
• Experience in writing T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments.
• Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2008/2005/2000 .
• Hands-on experience and exposure to different phases of Software Development Life Cycle (SDLC), Agile and Scrum Methodologies.
• Highly proficient in Tuning SQL queries and improving teh query performance.
• Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Database Maintenance Plan design to keep track of teh performance of MS SQL Server, which covers updating database statistics and Re-indexing of clustered and non-clustered indexes in production environment.
• Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• Knowledge of Automation tools and various bug tracking systems Silk Radar, Bug Zilla and Quality Center.
• Used SSIS Import/Export Wizard for performing teh ETL operations.
• Demonstrated expertise in MS SQL Server 2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts.
• Experience in SQL Server Analysis Services (SSAS 2005/ 2008) OLAP Cubes.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Expertise in building and migration of various DTS packages.
• Experience with file transfer protocols, including standard FTP and SFTP
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience using different Version Control Tools like Microsoft Source Safe and CVS.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005/2008 Analysis Services.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting teh data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
• Developed reports using global variables, expressions and functions.
• Created various Complex Formula Reports to query teh database for business Intelligence.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, XML, Java Script, PL/SQL, Oracle 9i/10g/11g, MySql, data warehouse, DB2

Databases: SQL Server 2008/2005/2000 /7.0, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Cognos reporting

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Web technologies: .Net, ASP.Net, Ado.Net, Silver light, Jquery, Ajax, Javascript, css

Data Modeling Tools: Erwin, Visio

Testing: Unit Testing, Performance Testing, Integration Testing, Stress Testing

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows / 98/2000/2003/ XP/Vista

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Microsoft Dynamics Ax, Composite Studio, TFS

PROFESSIONAL EXPERIENCE

Confidential, Grapevine, TX

Sr. SQL BI DEVELOPER

Responsibilities:

• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, Oracle, DB2 etc. to SQL Server
• Created SSIS package to load multilevel XML data into Oracle database.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Created complexStored Procedures, Triggers, Functions, Indexes, Tables, Viewsand otherT-SQL codeandSQL joinsfor applications.
• Created stored procedures to retrieve data from CDC enabled tables to load all deltas into destinations.
• Created SSIS package to loop through multiple shared folders for multiple file servers to get all teh files along with file path and folder names
• Migrated objects from SQL to Oracle using SQL developer.
• Created tables, indexes, views, aliases and constraints in DB2 using iSeries navigator.
• Developed backend SSIS package to transfer data from SQL to DB2 database using WMQ application
• Created SSIS package to transfer data from Share Point 2010 to SQL database using Share point List Adapters.
• Identified teh dimension, fact tables and designed teh data warehouse using star schema.
• Created stored procedures to load data into fact tables and dimensions tables for spot fire reporting dashboard
• Created SSRS report to read blob data for various types of images from a SQL table
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Migrated SSAS 2000 cube to SSAS 2008 to make data available for teh decision makers.
• Created partitions of teh Analysis Services cube to improve performance.
• Created report snapshots to improve teh performance of SSRS.
• Created Event Handlers for teh SSIS package on Error, on Post execute.
• Used named calculations and new named query cubes to calculate values at run time.
• Worked with T-SQL, DDL, DML and DCL
• Used Report Manager to assign roles, permissions and to create report schedules.
• Configured Reporting Services to a scale out deployment to allow concurrent users.
• Developed SQL scripts, ensured optimal performance of teh queries to generate reports from various relational databases like Oracle, DB2.
• Created schema and Virtualized SQL server tables in Composite Studio 6.2 to provide Composite ODBC access through excel to business users for analyzing data.
• Created Data Stage Job to load data from SQL server 2008 to Oracle 11g.
• Created complex SSIS packages using various transformations.
• Used Lookups Transformation to get teh data from reference data sets
• Created permanent tables, temporary tables and table variables
• Dealt with huge amount of data and used SSAS in order to retrieve teh data.

Environment: MS SQL Server 2008, MS SQL Server 2012, Windows Server 2008, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008,MS SQL SERVER 2K8R2, Composite Studio 6.1, IBM Info Sphere Data Stage, Oracle 11g, TFS

Confidential, Addison, TX

SQL BI DEVELOPER (SSIS, SSAS & SSRS)

Responsibilities:

• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Created stored procedures to retrieve data from CDC enabled tables to load all deltas into destinations.
• Created SSIS package to loop through multiple shared folders for multiple file servers to get all teh files along with file path and folder names
• Strong experience in Stored Procedure/TSQL coding, Performance Tuning, and Query Optimization.
• Highly proficient in teh use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2005/2008, MS Access databases and strong knowledge of SDLC principles.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Deployed teh generated reports directly on teh client’s workstation.
• Created many multi valued parameters in teh reports.
• Created many Cascaded parameters in teh reports using MDX and T-SQL.
• Improved Report Performance and performed unit testing.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Used version control Team Foundation Server for teh entire development life cycle.
• Optimized teh performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Used Lookups Transformation to get teh data from reference data sets
• Created permanent tables, temporary tables and table variables
• Dealt with huge amount of data and used SSAS in order to retrieve teh data.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries dat retrieve data from more TEMPthan one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing teh calculations to aggregate physical measures.
• Responsible forScheduling Jobs, Alerting and Maintaining SSIS packages.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries dat retrieve data from more TEMPthan one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing teh calculations to aggregate physical measures.
• Responsible forScheduling Jobs, Alerting and Maintaining SSIS packages.

Environment: MS SQL Server 2008, Windows Server 2008, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008, Composite Studio 6.1, TFS

Confidential, Bowie, MD

SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Installed, Configured, Managed and Monitored SQL Server 2005/2008.
• Creating tables, indexes and designing constraints.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Developed and deployed SSIS packages in Production Server.
• Managed teh entire ETL process involving teh access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Created SQL SSIS and SSRS infrastructure dat pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store teh Configuration, Security and Caching Information for teh Operation of teh Report Server.
• Identified Dimensions and Facts, used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Used Open Query from SQL Server teh SSAS Server to combine data from SSAS cube and DW database.

Environment: SQL Server 2008/2005/2000, SSRS 2008, SSIS 2008, TFS, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe.

Confidential, Skokie, IL

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created SQL Server Reports using SSRS 2008 for teh manager and teh brokers involved.
• Based on teh required reports, identified various data sources and established teh connections using SSIS and constructed data source view.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created parameterized reports for teh brokers and clients.
• Formatted teh report layout for teh requirement of teh end users.
• Deployment of teh developed reports on to teh server for teh end users.
• Deployed teh developed reports and upgraded teh system.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for teh analysis of managers and end users.
• Supported 24/7 for teh production system for post deployment Reports on teh server.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of teh database.
• Calculated members, named sets, and execute other script commands to extend teh capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.

Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows XP

Confidential, Farmington Hills, MI

SQL Server Developer/SSIS Developer/SSAS Developer

Responsibilities:

• Designing Data Model and implementing changes in teh earlier phase of teh project to accommodate business logic and dynamic nature of teh front end application.
• Involve in Business requirement gathering, Technical Design Documents, Business use cases and Data mapping.
• Wrote T-SQL code for creating cursor and handling teh data validations.
• Develop teh Documents for Logging/Error Handling for SSIS Packages.
• Handling teh orphan rows in Dimension and Fact tables.
• Schedule execution of reports in report manager and send them to managers on daily and weekly basis.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2005.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• Install SQL Server Reporting Services (SSRS) and configure teh reporting services configuration.
• Develop teh Slowly Changing Transformation to maintain teh Historical Data.
• Handling teh errors during data moving and Sequencing teh task as per requirements.
• XML result set from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all teh interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.
• Responsible for teh deployment of teh Cube on teh SSAS.
• Automated daily Database backups, restores and integrity checks using Management Studio and creating or updating indexes using SQL Profiler.
• Designed reports in SSRS with teh use of data from SSAS cube (MDX) and DW database.
• Integrate teh SSIS package, converting all existing packages to SQl Server 2008 by adding extra SSIS task.

Environment: SQL Server Reporting Services 2005/2008, SSAS, MS SQL Server 2005/2008,, SSIS, Front Office 8.3 / 10.2 / 10.3, MDX Cubes, Windows XP / NT / 2000/2003, MS Office 2003/2007,.Net

Confidential

SQL/SSIS Developer

Responsibilities:

• Created complex Stored Procedures and Functions to support teh front-end application.
• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Created database triggers to implement business requirements.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Monitored growth of database objects for capacity planning.
• Involved in tuning teh database and T-SQL queries using Explain Plan.
• Optimize SQL queries for improved performance and availability.
• Configured and monitored database application.
• Worked with Quality assurance to develop test plans and test cases to conduct system testing.
• Involved in performance tuning of teh database and T-SQL queries.
• Preparation of project documentation.
• Preparation of test plans for assembly testing & System Integration testing.
• Bug Tracking and Reporting through TFS bug tracking tool.
• Created SSIS packages to merge data from data source populating data.
• Developed DTS Packages to get teh reports, routinely, in teh excel sheets, required by teh managers for analysis.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, Oracle 9i, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.