SUMMARY

• Over 8 years of IT industry experience with Microsoft SQL Server 2000/2005/2008/2014 , 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/2012/2014 ) & 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.
• 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, Error Handlers etc.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional rquirements.
• Excellent analytical/Communication Skills, Team Play and very much result Oriented.

TECHNICAL SKILLS

Operating System: Windows NT 4.0, Windows 2008 Enterprise/Advanced Server, Windows 2003 Enterprise/Datacenter Server, XP Professional and Windows 2000, UNIX.

Databases: MS SQL Server 2005/2008/2012/2014 , MS Access, My SQL

Programming Languages: T-SQL, C, C++, Shell Scripting, SQL, TCL, TK, PERL, XML, C#, VB.NET, MDX

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook.

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSAS, SSRS. Index Analyzer, SQL Client Utility.

Reporting Tools: Reporting Service (SSRS) 2005/2008/2012/2014 .

ETL Tools: DTS, SSIS.

MS Tools: Management Studio, Visual Studio.

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Costa Mesa, CA

Senior SQL Server/BI Developer

Responsibilities:

• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including Sharepoint/Moss2007 integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy LookUp, For Each Loop, MultiCast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develop and unit test SSIS load processes for performance check.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005).
• Involved in migration and the Conversion of Reports from legacy systems to new systems.
• 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.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.

Environment: SQL Server 2005/2008/2012/2014 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008, Oracle.

Confidential, Milwaukee, WI

Senior SQL Server/BI Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including Sharepoint/Moss2007 integration.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy LookUp, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develop and unit test SSIS load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005).
• Involved in migration and Conversion of Reports from SSRS .
• 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.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2008, Oracle.

Confidential, Dallas, Texas

Senior SQL Server/BI Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including Sharepoint/Moss2007 integration.
• Generated the Reports with all the subcategory Information to Business users.
• Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet Reporting needs.
• Developed and Deployed different types of Reports like List, Drilled Down, Matrix, and Chart and Sub Reports etc.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Deployed and Scheduled the Reports in Report Manager. 7
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House and for OLTP side.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS .
• 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 a 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 reports according to client’s need.

Environment: SQL Server 2005/2008/2008 R2/2012 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, SharePoint, MOSS 2007

Confidential, Dallas, Texas

ETL Developer

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Constructed OLTP and OLAP Databases.
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on a weekly basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition of the models.
• Managed indexes, statistics and tuned queries by using the execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Designed SSAS cube to hold summary data for Targit dashboards.
• Developed Cube with Star Schema.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005/2000, DTS, T-SQL, XML, Flat File, SQL Server Reporting Services, Visio, IIS, Windows XP/2000

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of the Database and Restored the Database from Disaster Recovery.
• Worked on replication server and managed.
• Fine tuning of database objects and server.
• Worked on DTS Package, DTS Import/Export of Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Environment: SQL Server 2000/7.0, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS, Oracle 8i, MS-ACCESS
• Worked on making on the enterprise-wide use of XML applications, content management systems, taxonomies, and search engine optimization.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.