Summary

• 7+ years of IT industry experience with Microsoft SQL Server 2000/2005/2008, SSIS/SSRS/SSAS in OLTP and OLAP (Data warehousing) environments.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Hands on experience with Performance Point Server, ProClarity, Business Scorecard Manager (BSM).
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Experience in Error handling and debugging coding issues andtroubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Experience in SQLOptimizing by using SQLProfiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, ErrorHandlers etc.
• Experience in conversion of packages from legacy systems (DTSàSSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Experience inDevelopingandExtending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Modelsand Deploying and Processing SSAS objects.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Integration of SSRS Reports using various web parts intoSharepoint (MOSS 2007) and various delivery mechanisms.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Also having good hands-on experience with C#.Net,VB.Net
• Excellent analytical/Communication Skills, Team Play and very much result Oriented.
• Strong knowledge of Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Good understanding of Normalization /De-normalization and database design methodology.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.

SKILLS:-

Operating Systems

Windows NT/95/98/XP/2000/Server 2003, UNIX 4.0

Databases:

MS SQL Server 2000/2005/2008/2008 R2, Oracle 8i/9i, MS Access

ETL Tools:

DTS (Data transformation services),SQL Server Integration Services(SSIS)

Database Tools:

SQL Profiler, SQL Query Analyzer, Management studio Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe.

Skills and Languages

Transact SQL (T-SQL), PL/SQL, C, C#, VB Script, .Net

DB Modeling Tools

MS Visio, Erwin

Reporting Tools:

SQL Server Reporting Services (SSRS), Crystal reports 8.0/9.0/10.0,MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential (LasVegas,Nevada) (July 2011 – Present 2012)
BI Developer(SSIS,SSRS)

Confidential is a Nevada based company specializing in the design, development, manufacturing, sales and distribution of gaming machines and network system products internationally, as well as online and mobile gaming solutions for regulated markets.

Responsibilities:

• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2000/2005/2008.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Created UserDefinedFunctions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Checkconstraints, Business Rules, Indexes, and Views.
• Worked with Exception handling with @@error and with Try/catch.
• Designed SSIS Package for extracting data from heterogeneous source systems, transform and load into the Staging Data base.
• Created projects to transfer data from MS Excel to SQL Server in SSIS.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS.
• Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL server Database.
• Extensively used Derived column transformation for data conversion.
• Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Worked on data cleansing techniques using look ups, conditional split, and fuzzylookup.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Developed Query for generating drill down and drill through reports in SSRS 05/08.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008.
• Developed ReportModels for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created Development and Production support documents.

ENVIRONMENT: MS SQL Server 2008/2005/2000/7.0, Windows 2003, SSMS, Business Intelligence Development Studio(BIDS) 2008/2005, Erwin, MS Visual Source Safe, MS-Visual Studio,Team Foundation Server.

Confidential (Fort Lauderdale ,Florida) (Jan 2011 – June 2011)
BI Developer(SSIS,SSRS)

Confidential. is a multinational corporation that provides server and desktop virtualization, networking, cloud computing technologies including Xen open source products.

• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexSQL stored proceduresusing Microsoft SQL Server 2008 and 2008 R2.
• Continuously interacted with Business Analysts and end users to gather business requirements.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Knowledge in designing and developing Data Warehouses, Data marts and BusinessIntelligenceusing multi-dimensional models such as Star Schemas and Snow Flake Schema for developingCUBES using MDX.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Extensively involved in designing theSSISpackages to export data ofheterogeneous data(like XML, Excel, CSV, PGP, Flat file) source to staging tables in SQL Server Database.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• CreatedTabular, Charts and graphs as per customer requirements Using SSRS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Worked on Dashboards using SSRS.
• Deployed reports on Microsoft office SharePoint(Moss).

Environment: MS SQL Server 2008/2008 R2, MS SQL SSRS 2008, SSIS 2008

Confidential (San Antonio,TX)(Aug 2010 – Dec 2010)
BI Developer(SSIS,SSRS)

Confidential a global web host known for their high end managed hosting and dedicated services. The company delivers enterprise-level managed services to businesses of all sizes and kinds around the world.

Responsibilities:-

• Created DTSX Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Configured the loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Experience in creating complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Hands on experience in using different transformations likedata Conversions,lookups, derived column transformationsetc, fordata cleansingto remove unnecessary columns, eliminateredundant,inconsistent dataand unnecessary Datalike removingempty rowsusing SSIS.
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Created Tablix reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Created Jobs Performance report that queries sys tables and shows how long each job ran and weekly-average duration using SSRS.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Maintenance and provide support to the users for the deployed reports.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.
• Developed Query for generating drill down reports in SSRS 2005/2008.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created subscription to reports.
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users andrepositories.

Environment: MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual SourceSafe, Windows 2003 serve

Confidential (Mayfield Village, OH) Sep ’09-July2010 
SQL Server/BI Developer

Confidential is an Auto Insurance Company. They have both the development and production environment, my duties focused on maintaining, and optimizing the existing databases; designing and implementing new databases for various projects according to the requirements from clients; monitoring database performance and growth, performance tuning, establishing and administering database security in development, testing, and production environments
.
Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Design/Build Extract Transform Load procedures in SQL Server 2000/2005/2008 using DTS packages to import/export data feeds to/from data warehouse and claim systems.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005/2008.
• Participated in migration from SQL Server 2005 to SQL Server 2008.
• Analyze, tuning and optimizing for SQL Server Applications by using performance monitor.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Experience in tuning of Stored Procedures and query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Expertise includes Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data import, Data export.
• Implemented dimensional data warehouse model using Ralph Kimball and Inmon methodologies.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007 Dashboard Designer.
• Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Designed and developed Reports in SQL Server 2005 Reporting Services (SSRS).
• Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
• 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.
• Creating Tabular, Charts and graphs as per customer requirements Using SSRS.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Creating and running SSIS Packages for Import and Export of Heterogeneous Data.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracleusing SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implement SDLC development and acceptance test environments. Establish security best practices. Implement T-SQL script based SDLC environment promotion automation.
• Involvement in all stages of development process - high-level design, implementation, testing, deployment and support of products adhering to company\'s SDLC
• Database and Log Backups and restoration, backup strategies, scheduling backups.

Environment: SQL Server 2005/2008, ORACLE,MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008

SSIS and SSRS Developer

Confidential is a highly diversified and growing financial services organization spanning the retail, business and corporate markets. The system handles online as well as summarized and intensive search oriented users totaling four hundred and size hovering around 600 Gigabytes. The clients can also view balances, statements and transactions anytime. The project involves creating complex ETL packages for heterogeneous data in the Agency group.

Responsibilities:

• Develop ETL Packages and Reports.
• Create tables,stored procedureswhen required.
• Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver tothe respectiveteams thatrequire the file.
• Served as the primary point of contact for most of the Enterprise Business intelligence design and development.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Involved inrelational database modeling(like designing the tables, algorithmic diagrams for the input data (entity diagrams), index\'s etc.)
• Extensively worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly-basis,file-transfersfrom one location to other.
• UsingFTPandSFTPtasks,Encryptinganddecryptingthe files usingOpen PGPtask etc.,
• Experience in creating complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Hands on experience in using different transformations likedata Conversions,lookups, derived column transformationsetc, fordata cleansingto remove unnecessary columns, eliminateredundant,inconsistent dataand unnecessary Datalike removingempty rowsusing SSIS.
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Create Tablixreports,Tabular/Matrix reports based on requirements.
• Create Dashboards using SSRS.
• Modified different packages where the issues (likeremoving the duplicaterecords or just updating a record and disable the previous records that had different IDs for one person,) rose after the user interference.
• Worked with Team foundation server (TFS) offeringsource control, data collection,reporting, and project tracking.
• Integrated TFS withMicrosoft Excelfor the creation and tracking of project items.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Create databases, tables, and fields for data entry,performingdatabase capacity planning.
• Enhancing anddeploying the SSIS packagesfrom development server to production server andscheduled jobs.
• Supported the production team and other groups outside the team when issues rose in the packages.

Environment: SQL Server 2005/2008, ORACLE,MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008

Confidential,Chantilly, VA Aug ’07– Sep’08
Senior SQL /BIDeveloper

Confidential is a leading provider of health management services, including disease management, clinical decision support and personal health records.My responsibilities involved in designing, implementing, managing and troubleshooting databases for mission-critical business applications.Supported OLAP, data warehouse and data marts by using various tools and methodologies.

Responsibilities:

• Installation, configuration of MS SQL Server 2005/2008.
• Consistency and Integrity.
• SQL serverUpgrade from 2005 to SQL 2008.
• Designing and creation oftablesandstored procedureswith E-R diagrams.
• Merging 2 different versions of databases to one single database and upgrading to SQL 2008.
• Installation of service packs and security patches.
• Designed and architected of OLAP cubes to support business reporting and forecasting processes.
• Designed the Dimensional modeling of the Data warehouse using Erwin.
• Data Warehousing using Data Transformation Services Package (SSIS).
• Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
• Designed OLAP cubes with star schema and multiple partitionsusing SSAS
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchiesand adding the Aggregations to the Cube.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• Extensively involved in designing (Logical and Physical) of customer database.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• 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.
• Wrote and integrated stored procedures to generate the special reportsaccording to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Deployed designed PPS dashboards & reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.
• Worked with OLAP tool ProClarity.
• Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
• Database and log backups and restoration, backup scheduling the backups.Backing up master and system databases and restoring them.
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Eased administrative work through automatic script performing daily/weekly backups.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.

Environment:MS SQL Server 2005/2008, Windows 2003 Server, SQL Query Analyzer, SSIS, TSQL, C#, ASP.NET, MS Outlook.

Confidential, Little Rock, Arkansas Oct’06 – Aug ’07
SSIS,SSAS and SSRS Developer

Confidential is owner and operator of the nation\'s largest wireless network and has more than 11 million wireless customers a key member of the Marketing Technologies and development team which provides Information technology support for Countrywide Marketing by designing, coding and maintaining automation processes.

Responsibilities:

• Performing DTS for data transfer from MS Excel and text file to SQL Server 2000.
• Written DTS Packages to get the data from various heterogeneous databases such as Oracle, Teradata and Sybase to SQL Server 2000.
• Created SQL scripts to load data to SQL server from text files.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s &MDX Queries using SQL Server 2005 Analysis Services
• Usingmulti-dimensional modelssuch as Star Schemas and Snow Flake Schema for developing Cubes Using MDX.
• Used SQL Profiler and Query Analyzer to optimize DTS packagequeries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Involving in creating and maintaining Database Tables, Views and Constraints.
• Created many complex Stored Procedures and Triggers to audit db logins.
• Created many User Defined Functions.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Created logical and physical data modeling for development database using Erwin Tool
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs provided day-to-day administration tasks like space and log management.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Reporting with SQL Server: Experience in developing User reports and management reports using Sql Server Reporting Services SSRS.
• Scheduled DTS Packages and Involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005. Import Export data, Bulk Insert and BCP.
• In depth knowledge in SSRS for report generation to create various types of reports.
• Experience in basic and advanced report creation with thorough knowledge of report serving architecture.
• Highly Capable in Reports Creation using Report Services MS-SSRS.
• Efficient in creating reports with complex formulas and to query the database for Business Intelligence.
• SQL Integration Services: Highly capable in developing and monitoring DTS and SSIS packages for use in regularly scheduled jobs to extract modify or transform data for a variety of purposes.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert,BCP and DTS Packages.
• Created DTS packages to transfer objects from development server to production.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks).
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and Maintained Snapshot Replication across multiple server environments
• Setup and maintained Linked Servers.

Environment:MS SQL Server 2000/2005, Windows 2003/2008, Windows NT 4.0,Visual Basic, ASP, VBScript, JavaScript, Excel, MS Access, Visio, PowerPoint.

EDUCATIONAL QUALIFICATIONS:

Bachelor of Technology in Computer Science