Summary

• Over 5+ years of IT industry experience with Microsoft SQL Server 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.
• Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008) & features.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Experience in Error handling and debugging coding issues and troubleshoot 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 SQL Optimizing by using SQL Profiler, 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, Import, Export Data, Bulk Insert and BCP utilities.
• Expert Level experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in conversion of packages from legacy systems (DTSàSSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and 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.
• Hand on experience in ASP.NET, Crystal Report, WPF, AJAX and JAVA SCRIPT.
• 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, Linux

Databases:

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

ETL Tools:

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.Net

DB Modeling Tools:

MS Visio

Reporting Tools:

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

PROFESSIONAL EXPERIENCE:

Confidential, (Rockford, IL)
BI Developer (SQL/SSIS/SSRS/SSAS/.Net Developer) (Feb 2011 - Present)

Confidential,manage health care delivery networks, health benefit claims processing, utilization management, and analysis health data.
Responsibilities:-

• Designed and develop SSIS packages to Extract transform and load data from various data sources into SQL server.
• Automating SSIS Execution using Windows Scheduler using DTExec Command.
• Created logging, custom logging and error handling packages.
• Grouping, aggregating, and splitting data using SSIS.
• Scripting using SSIS for data cleansing, encrypting, decrypting sensitive information.
• Creating Various Reports Using SSRS for analysis and managing claim processing.
• Building OLAP Cubes for analyzing Claims data and business process.
• Developing SSIS packages to automate different FTP’s files and emailing to different clients.
• Editing, upgrading and maintaining ASP.Net Website and IIS Server.
• Creating 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.
• Creating several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Developing, maintaining, troubleshooting and updating Reports using Ms Access and VBA macros.

Confidential, (EDEN PRAIRIE, MN) (April 2010 – Feb2011)
Software Engineer (SQL/ SSIS/ SSRS developer)

Confidential,is a leader in the grocery and pharmacy retailing industry, serving a wide range of customers in neighborhoods nationwide, through approximately more than 2500 retail stores. They have both development and production environment.
Responsibilities:-

• Continuously interacted with Business Analysts and end users to gather business requirements.
• Designed and developed a database to house data from various data sources for all reporting needs.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Created SSIS Packages to import and export data from Excel Spreadsheets, People Soft, Text files, CSV files and various direct sources.
• Executed the DTSX Packages by using DTExec Command.
• Created logging, custom logging and error handling packages.
• Identified the Data Source and defined them to build the Data Source Views.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• 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 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.
• 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 and repositories.
• 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.
• Developed GUI front end using Web forms in ASP.NET. Created Modules and Classes in C#.NET and VB.Net
• Created Development and Production support documents.
• Developed Query for generating drill down reports in SSRS 2005/2008.
• Designed and Developed a Dashboard project for tracking Batches performance of

Merchandise application using VB.Net, ASP.Net, AJAX, MS Charting and TSQL.

Environment: MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual Studio 2005/2008, Windows 2003 Server, Oracle 10g, Teradata, DB2

Confidential, (Academic Work) Sep 08- Sep 2010 SQL Server/BI Developer

Responsibilities:

• Developed MDI applications using Window Presentation Foundation (WPF) with integrated special effects into several control elements.
• Designed and developed hundreds of high tech SSIS packages for different ETL projects.
• Developed configure and deployed SSIS packages both programmatically and using GUI.
• Designed and developed OLAP database models, data marts and cubes.
• Developed web application for a sales store, linking the web pages to source database, design and connect reports to web and applications using Crystal Report.
• Developed and managed dynamic ASP.NET web applications with the use of AJAX controls, validation controls, and login controls.
• Developed database applications using multitier concepts with the use of SQL statements query and stored procedures to retrieve, manipulate and update databases using SQL Server and Access databases.
• Created, managed, and manipulated databases using SQL server 2008, Oracle 10g, and Access.
• Design/Build Extract Transform Load procedures in SQL Server 2008 using SSIS 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.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing CUBES using MDX.
• 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.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• 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 packages in SSIS with error handling and worked with different methods of logging in SSIS.
• 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 Oracle using 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.

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, (Riyadh, KSA) Feb 2003– Apr 2008
System administrator

Responsibilities:

• Installation, configuration of MS SQL Server 2005.
• Managing and troubleshooting windows 2000 based LAN-WAN network.
• Configuring and troubleshooting Cisco routers.
• Designing and creation oftablesandstored procedureswith E-R diagrams.
• Installation of service packs and security patches.
• Troubleshooting, installing and setting up PCs and involved in help desk support.
• Extensively involved in designing (Logical and Physical) of customer database.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• 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.

Environment:MS SQL Server 2000 Windows 2000 Server, TSQL, VB.Net, ASP.NET, MS Outlook.

EDUCATIONAL QUALIFICATIONS:

2 Years study in Information Systems and Technology (Database)

2 Years Diploma in Electronic commerce (IT)

B.Sc. (Math)