SUMMARY:
Around 8 years of experience in various Information Technology as involving Database Programming, SSIS/SSRS/SSAS/Qlikview, Data modeling, Data analysis, Data design, development and implementation of Data Warehouse solutions, testing & administration of SQL Server 7/2000/2005/2008

• Worked extensively on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC).
• Experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS), DTS Import/Export Utility, BCP and DTS packages
• Experience in Online Analysis Processing (OLAP), created SQL Server Analysis Services (SSAS) cubes,.
• .Expert in providing logging, error handling by using event handler and break points for SSIS packages.
• Followed the Microsoft recommended best strategies in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services (SSIS).
• Expert level skills in Data Mapping, Table Normalization, Optimization and Performance Tuning.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Migrated organization orders, adjustments, objectives and data in various formats like text based files; excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints.
• Experience in handling Performance Tuning of SSIS using Horizontal Partitioning.
• Administered QlikView 10 server environments.
• Experience in designing and developing data warehouse, data mart solutions.
• Worked extensively on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Expert skills in handling different Data warehousing methodologies such as Bill Inmon (Top Down design) and Ralph Kimball (Bottom-up design).
• Developed Scorecards with advance set of dashboards using different Business Intelligence tools such as ProClarity and Performance Point Server.
• Experience in developing reports using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Drill Through, Parameterized, Ad hoc and Cascaded Parameterized
• Expert in writing Stored Procedures, Functions, ad hoc queries, UDF ,Common Table Expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency using SQL Server Management Studio.
• Good experience in creating Jobs using SQL Server agent, partitions and scheduling DTS and SSIS packages.
• Excellent team player, interfacing across business and technical groups and ability to work independently and highly motivated. Exceptional ability to quickly master new concepts and applications.

EDUCATION:

Bachelor’s Degree in Commerce. 
Diploma in Computers.
Diploma in Hardware and Networking

TECHNICAL SKILLS

Databases

MS SQL Server 2008/2005, Teradata V2R6/V2R5, DB2

Database Tools

MS SQL Server 2008/2000/2005, MS-Access, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, OLAP(Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Development skills

T-SQL, PL/SQL,SSIS/SSRS/SSAS, Pro-clarity

Languages

VB.net, VB Script, T-SQL, SSAS, OLAP, HTML, XML, ASP.NET, Java Script, C, C++ and MDX.

ETL Tools

DTS, SSIS (SQL Server Integration Services),

Reporting Packages

SQL Server Reporting Services, QlikView, Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel.

Tools/Methodologies

MS Visio, Erwin, MS Project, Rational Rose, SQL Profiler, SQL*Loader, Front page.

Employment History:
Confidential, Jacksonville, FL Nov 2011 to Present
Sr. SQL BI Developer

Responsibilities:

• Worked as part of a team for Gathering and analyzing Business Requirements
• Participated actively in designing the system database structure
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server 2008
• Mentoring of all developers on best practices in RDBMS and Data Warehouse development and performance enhancements.
• Designed SSIS packages to migrate the data from PDX files to the Staging Area in SQL server 2008
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Used Analysis Services (SSAS) including designing dimensions and facts\measures tables modeling and design based on star and snowflake OLAP schemas, creating and processing cubes, partitions (ROLAP, HOLAP or MOLAP), translations, perspectives, defining attribute relationships, attribute hierarchies, calculations and KPIs .
• Migrated and recreated existing dimensions and cubes using star schema SQL Server 2008 to achieve the efficiency of SQL Server Analysis Server(SSAS
• Worked with QlikView Enterprise Management Console(QEMC)
• Scheduled tasks in QlikView publisher
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Generated Reports using Data Source Views in Report Builder 2.0
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Performed performance tuning of stored procedures using SQL Server Profiler
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: SQL Server 2008/2005, T-SQL/PL-SQL, Windows XP/2003, Visual Studio 2008/2005, TFS2008/2005, Report Builder 2.0, Reporting Tools, , SSIS, SSRS, SSAS, QlikView, MS-Visio, Share-Point Designer, MOSS-2007, Microsoft-Office

Confidential, Grand Rapids, MI Jan 2010 to Oct 2011
Sr. BI Developer 

Responsibilities:

• Design core and presentation layer models - concept, logical, extended logical and physical
• Full SDLC development of an address cleansing, name cleansing and enterprise individual/customer identification system utilizing Quality Stage for cleansing and standardization.
• Created SSIS Packages using, Fuzzy Lookup, Derived Columns, Condition Split, 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 and MS Access to data warehouse.
• Used SSIS to implement Slowly Changing Dimension to maintain historical data in Data Warehouse
• Created SSIS packages to move data from Oracle to SQL Server and also from other sources such as Text and Excel files
• Created SSIS packages to process cubes and schedule the processing as per requirements
• Built various SSIS packages having different tasks and transformations for various business areas and Scheduled SSIS packages
• Deployed packages to different environments (test environment, production environment).
• Migrated reports from SQL Server 2005 Version to SQL Server 2008 Version.
• Involved in database modification process and data re-modeling process for CRM and Product Data Mart
• Developed Calculated measures, set attribute relationships and perspectives
• Created Partitions in Cubes on time dimension for optimizing the performance
• Designed Hierarchies by setting name column and key column as there was no strong hierarchies defined
• Involved in Designing, Developing, and Testing of Universe and Reports.
• Creating and Editing Web-intelligence (WEBI) and Desktop Intelligence DSKI) Documents as per business requirements.
• Responsible for working on production, development, support Report server.
• Understanding business process of the customer and then analyzing deeply the requirements of reports.
• Publishing the reports to all environment, including production and responsible for testing.
• Implementing Row level security, Report level security and granting rights to users
• Scheduling Objects, tasks and triggers based on different events.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Enabled dynamic report linking by passing Variables (prompts) between reports
• Experience in designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Hands-on experience of estimating projects using Function Point and Task Based.
• Expertise in creating, organizing, publishing and scheduling reports using Center Management Console.
• Experienced with OLAP functionalities like Scope of Analysis, Drill Analysis and Slice & Dice.Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.

Environment: SQL Server 2008/2005, Oracle-10g, T-SQL/PL-SQL, Windows XP/2003, Visual Studio 2008/2005, TFS2008/2005, Report Builder 2.0, Erwin, SSIS, SSRS, SSAS, MS-Visio, Share-Point Designer, MOSS-2007, Microsoft-Office 2003/2007

Confidential, Minneapolis, MN Nov 2007 to Dec 2009
BI/ ETL Developer

Responsibilities:

• Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.
• Created functional requirement specifications and supporting documents for business systems.
• Interface Based ETL Architecture (SSIS package), involved in data consolidation and integration activities for the data coming from various heterogeneous sources into global stage area, data marts and enterprise data warehouse.
• Designed the control processes for process and financial reconciliation for audit, error and data quality management.
• Designed UAT environment and test scripts.
• Designed an enterprise-level job automation and scheduling solution, setup best and standard practices for DB/ETL.
• Worked with SSIS Execute SQL task, script task, data flow tasks, look up, conditional split, script component, row count, union all, multicast, derived column transformations and written T-SQL and Visual Basic (VB) scripts
• Designed Data archiving strategy.
• Created and reviewed Logical & Physical Data Models
• Created Data-driven Packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP
• Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
• Created reports using SSRS from various sources like SQL Server 2005/2008 and Cubes from Analysis Services
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Designed various Cubes as per the requirements for various clients using SSAS.
• Created 15+ dimensions, SSAS cubes, developed custom MDX scripts for business logic
• Developed drill through capability at row level, documented bugs in SSAS to Microsoft
• Designed complete business logic for the project
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Experience in database design process and data modeling process for Billing Method using MS Visio.
• Wrote more than 50 stored procedures.
• Provided production support for the users, Client DBAs.
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data-sources.
• Creating custom SQL queries using T- SQL.
• Optimized queries to improve the performance and Maintaining the database consistency with DBCC at regular intervals

Environment: SQL Server 2008/2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Oracle, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Integration services , SQL Server Reporting services, SQL Server Analysis Services, Visio, Share-Point, Microsoft-Office 2003/2007, MS-Excel 2003/2007.

Confidential, Northville, MI Mar 2006 to Nov 2007
SQL Server/ SSIS/ SSRS Consultant

Responsibilities:

• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements. Determining system impacts, as well as scalability and capacity analysis. Database planning resulting from database requirements. Designed capacity, security, performance, backup and recovery planning.
• Monitors performance, space utilization, and physical integrity. Install new releases of Database software ensures all servers have a standard Database configuration.
• Worked as part of a team for gathering and analyzing Business Requirements
• Participated actively in designing the system database structure
• Designed Data-Mart for Prescription using Relational Model and wrote SSIS Packages to extract data from the old PDX system and load it into the new data mart of SQL Server 2008
• Designed SSIS packages to migrate the data from PDX files to the Staging Area in SQL server 2005
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2005.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages
• Installed and administered Microsoft SQL Server 2005, SQL Server Integration Services 2005, SQL Server Reporting Services 2005, Team Foundation Server 2005
• Built Reports in SSRS for errors generated in SSIS Packages.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS
• Generated Reports using Data Source Views in Report Builder 2.0
• Developed Reports Using SSRS on statistical data during migration of data.
• Created Drill Down, Drill through, linked and sub reports using SSRS 2005.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Performed performance tuning of stored procedures using SQL Server Profiler
• Used Query Analyzer, Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server
• Used UML for Design and Documentation
• Saved the SSIS Packages and Reports in SourceSafe

Environment: SQL Server 2005, T-SQL, Windows XP/2003, Visual Studio 2008/2005, Report Builder 2.0, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, Share-Point.

Confidential, Dearborn, MI Apr 2005 to Feb 2006
BI Consultant

Responsibilities:

• Created Sales Data mart and loaded data from DB2 Database and DB2 source files to Sql server 2005 database tables using SSIS
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Maintaining the documents and packages in Team Foundation Server as a version control
• Documenting each and every process from creation to deployment of packages.
• Created new Documentation, schema designing, creating new ERD’s using Visio
• Performed the Unit, Integration, system testing, User Acceptance Testing and written Test Cases and Test Scripts
• Involved in designing of Star, Snowflake schemas and dimensional data models.
• Designed/implemented the information access and delivery effort for the data warehouse.
• Extensively Worked on SQL Server Reporting Services (SSRS) for Sales Summary Reports
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Environment: MS SQL Server 2005, Business Intelligence Development Studio (SSIS/SSRS/SSAS), SSMS, Team Foundation Server, DB2 Database, Visual Studio 2005, Windows XP.

Confidential Aug 2004 to Feb 2005
SQL Server Developer

Responsibilities:

• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Worked on Client/Server tools like MS SQL Server 2000 Enterprise Manager and Query Analyzer to Administer SQL Server
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
• Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Experience in writing stored procedures, functions, triggers and calling them in the packages.
• Experience in star schema over 1 year by building relationships between Fact Table and Dimension tables.
• Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2000.
• Participated in maintaining and modifying tables and constraints for Premium Database using MS SQL Server
• Configured Database Mail, created operators , jobs and alerts for automating databases.
• Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc
• Designed DTS package, with DTS Import/Export wizard for transferring data
• Data migration (Import & Export – BCP) from text to SQL Server