PROFESSIONAL SUMMARY:

• Over 7+ years of IT Experience in Analysis, Database Design, development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives.
• Extensive Programming, Installing, Configuring, Managing, Monitoring and Troubleshooting experience in MS SQL Server 2000/2005/2008 and Business Intelligence in SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Strong experience in creating Complex Stored Procedures, Index, Functions, DTS packages, Triggers, Tables, Views and other SQL Joins and statements.
• Expertise in creating Reports with Complex Formulas and to query the database for Business Intelligence using SSRS.
• Proficiency in creating different types of reports such as Table Reports, Cross - Tab, List Reports, Conditional, Pie Chart Reports, Drill-down, Drill through Reports, Group Reports, Sub-Group Reports, Adjacent group Reports, Total Reports, Sub-Total Reports, Grand-Total Reports.
• Experience in developing and modifying Cubes and Dimensions in cubes using SSAS.
• Experience in creating traditional as well as Web-based interactive reports using SQL Server Reporting Services sourcing OLAP cubes and Data warehouse, Data Marts as well as transactional systems.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
• Expertise in SQL Server 2008 Analysis Services (SSAS) to deliver Online Analytical Processing (OLAP) and data mining functionality for business intelligence applications.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects.
• Extensively worked in creating and integrating reports and objects (Attributes, Filters, Metrics, Facts, Prompts, etc.) with the data warehouse.
• Good Knowledge in Physical and Logical Data Modeling.
• Highly motivated and a conceptually strong individual with exceptional analytical and design skills.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000/2003/2008/2012 Windows XP/2007

Languages: T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML

Tools /Utilities: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/08/10, Tableau, Microstrategy, Cognos

Databases: MS SQL Server 7.0/2000/2005/2008/2012, MS Access

Software: MS Excel, MS-Project, MS-Dynamics, Cognos, Microstrategy

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Microsoft BI Developer

Responsibilities:

• Actively involved in gathering and analyzing the user requirements in coordination with Business.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created cubes using Star Schema on SQL Server 2008 to achieve the efficiency of SSAS.
• Created different Parameterized Reports (SSRS 2005/2008) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Environment: SQL Server 2012, SQL Server 2008 R2, experience in SQL Server Replication, Windows 7, MS Access, SSIS, SSRS.

Confidential, Newark, DE

Microsoft BI Developer

Responsibilities:

• Involved in gather user requirements and system specifications.
• Maintained referential integrity and implemented complex business logic.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2005.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated and recreated existing dimensions and cubes using Star Schema on SQL Server 2005 to achieve the efficiency of SSAS.
• Build MDX queries for Analysis Services and Reporting Services.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
• Design, deployment and maintenance of various SSRS in SQL Server 2005.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.

Environment: SQL Server 2008 R2, T-SQL, SQL Server 2008 R2 Management Studio, SQL Agent.

Confidential, Reading, PA

Microsoft ETL Developer

Responsibilities:

• Developed complex T-SQL code for the application.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on VB.net/C# while using Script Component packages.
• Designed and implemented the stored procedures and triggers for automating tasks.
• Developed SQL Server Stored procedures and SSIS packages to extract data from database.
• Implemented constraints on tables.
• Created SSIS Packages to migrate slowly changing dimensions.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Testing of applications for performance, data Integrity
• Worked on Complex data loading (implemented the batch data cleansing and data loading).
• Created DTS package to schedule the jobs for batch processing.
• Created indexes, constraints and rules on database objects.

Environment: SQL Server 2008, MS Access, SSIS, Query Analyzer, SSIS, MS reporting Services, Import & Export Data, Windows XP/ 2003 Server.

Confidential, Union, NJ

SSIS/SSRS Developer

Responsibilities:

• Interfaced with Business users for better understanding the reporting requirements.
• Interfaced with the client as part of the Requirements engineering team to finalize the project scope.
• Migrated SQL Server 2005 DTS packages to SQL Server 2005 SSIS Packages
• Implemented SSIS for data transformation logic process.
• Designing and building data load procedures, using MS SQL Server SSIS
• Developed Stored Procedures, Functions and Database Triggers.
• Developed reports using SQL Server Reporting Services(SSRS)
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Published reports as PDF formats.

Environment: MS SQL Server 2005, Windows 2000/2003, Sybase, Excel, TSQL, Microsoft Visual Studio 2005, SQL Reporting Services, SQL integration services.