SUMMARY

• Over 8 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.
• 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 requirements.
• Very Good Knowledge on Scripting Languages like Tcl,Perl,Unix Scripting
• 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, New York, NY

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, New York, NY

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, 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.
• 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 2005 to 2008.
• 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, King of Prussia, PA

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 2005 to 2008.
• 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

SQL Server Developer/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.