SUMMARY

• Over 8 years of IT experience as a MS SQL Server 2005/2008/2008 R2/2012 Developer and Business Intelligence with main focus on T - SQL, SSIS, SSRS and understanding of SSAS.
• Extensive programming experience as Database & Report Developer in Microsoft SQL Server 2005/2008/2012 using T-SQL and Business Intelligence Data Tools and various platforms.
• Good experience in Design, Development, Implementation and Testing of Database systems using MS SQL Server 2005/2008/2012 DDL, DML, DRL and DCL commands for various Data Warehouse and business applications.
• Worked with databases like SQL Server 2005/2008/2012 and Expertise in MS Office 2010.
• Experience in writing Complex T-SQL Queries, Dynamic Queries, Sub-queries, Complex Joins.
• Extensive experience in Database design using SQL, T-SQL in Stored Procedures, Views, Functions, Constraints (Primary Key, Foreign Key), Triggers, Indexes and Batch Scripts.
• Have used TFS 2010 to support agile development practices to produce quality software.
• Experience in Performance Tuning and Query Optimization and reviewed various stored procedures with options, Function and T-SQL code and
• Experience in buildingDataIntegration,Workflow Solutions and Extract, Transform and Load (ETL) solutions fordatawarehousing usingSQLServerIntegration Service (SSIS).
• Good noledge in Data Warehousing methodologies and ETL Process.
• Expert in Extraction, Transformation, and Loading (ETL) data from various data sources using SSIS. Created packages to extract data from Oracle, Flat file and load into MSSQL.
• In SSIS I have worked with Lookups, Fuzzy Lookup, Web Services, and Container and used that in Reporting Service (SSRS).
• Developed reports on SSRS on SQL Server ( 2005/2008/2012 )
• Used SSRS and created Table Report, adding calculated Values, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
• Created reports that has been defined by Business Objects and generated Crystal reports.
• Expertise with job scheduling using SQL Server Agent to perform updates on completion of jobs inserted.
• Build, Deployed and Published the Reports to Report Manager Website. Have worked with XML and Web Services.
• Programming noledge in .NET and to connect the .NET front end with Microsoft SQL Server Management Studio and Retrieve data.
• Has a working experience in creating DB Instances/Schema's of SQL Server 2008/2012 using Amazon Web services.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Experienced in all stages of software lifecycle - Requirements gathering, Design, Development and Deployment.
• Strong ability to share noledge with others and collaborate as part of a team to achieve positive outcomes with good communication skills.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2005/2008/2008 r2/2012

Languages: T-SQL, PL SQL

Tools: Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio and MS Visio.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Report Manager, Report Builder, MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential, Bethlehem, PA

MS Business Intelligent Developer

Responsibilities:

• Developed SSIS packages fordataintegrationfrom manydatasources such as Flat file, Oracle, Access orSQLServer 2012 intoSQLServer and deployed them using configuration tools.
• Formulated and implemented ETL process design according to business requirements and system specifications including source to target mappings,datadictionaries and transformations.
• Created highly complex SSIS packages using variousDatatransformations such as conditional splitting, derived column, Fuzzy Lookup, For Each Loop, Multi Cast, Merge, Error handling.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Created SSRS Report Model Projects in Visual studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Utilize SSRS for creating interactive reports such as sub drill through, drill down, grouping report, parameterized reports, Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports.
• Extensive understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Apply SSAS to deploy cubes with fact tables and dimensions tables. Upload and share cube information into Share Pointintegrationas well as output the cube into Excel using Power Pivot.
• Involved in designing OLAP cubes with star schema, writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Share point.
• Deployed designed dashboards & reports on MS SharePoint site using Performance Point Server Dashboard viewer Web Part for web based to access for multiple end users.
• Performed daily tasks including backup and restore by using tools likeSQLServer Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.

Environment: MSSQLServer2012,SQLServerReportingService(SSRS),SQLServerIntegration Service (SSIS),SQLServer Analysis Services (SSAS), C#, ASP.NET, Visual Studio 2012, T-SQL, MS Share Point, Access.

Confidential, Sacramento, CA

SR.SQLBI DEVELOPER SSIS/SSAS/SSRS

Responsibilities:

• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly Patients Health Record.
• Created Tabular reports, Matrix reports, List reports and Sub-reports using SSRS.
• Created facts, dimensions and star schema representation for the data warehouse using Ralph-Kimball Methodologies.
• Created Stored Procedures, Views, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results. Involved in database designing using Normalization.
• Developed complex stored procedure using T-SQLto generate ad hoc reports using SSRS
• Create the complex queries, joins and sub queries using cluster/non-cluster indexes on tables, Optimized indexes to improve queries and analyzed database performance withSQLProfiler
• Place the huge table/non-clustered index on the separate filegroupto improve the performance.
• Traced complex stored procedures,SQLqueries and monitored usingSQLProfiler, Index Tuning Wizard.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis andDataIntegrity Validation.
• Involved in development and debugging of complex batch T-SQLProcedures and functions
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Created SSIS Packages templates using based on the platform to extractdatafrom MS Excel, Text Files, Flat Files of shared location to staging then to partitioned tables. Migrateddatafrom differentdatasources toSQLServer.
• Experience in creating and deploying SSIS packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, andDataConversion Transformations from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extractdatafrom staging tables to Datamart tables with Incremental loads, for processing fact and dimension tables with complex transforms for SCD Type 1dataand maintain the history of records using Type 2 changes.
• Managed the Metadata associated with the ETL processes used to populate theDataWarehouse using SSIS packages.
• Created the ETL templates, workloads and scheduled the jobs to run automatically to process and loaddatain Main server the samedatais replicated into the Mart server for the reporting purpose.
• Created SSIS packages and scheduled the jobs to run automatically to process the cube, load data.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored, deployed, scheduling jobs, alerting and maintaining SSIS packages.
• Developed Cubes usingSQLAnalysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions anddatasource view.
• Created complex SSAS cubes with multiple fact measures groups, calculated measures are defined using MDX and multiple dimension hierarchies based on the OLAP reporting needs.
• Generated multiple Enterprise reports (SSRS) fromSQLServer Database (OLTP) andSQL Server Analysis Services Database (OLAP) and included various reporting features such asgroup by, drilldowns, drill through, sub-reports, Parameterized Reports
• Involved in dimensional modeling (Star &Snowflake) and creating theDataSource Views (DSV), Cubes using the identified Fact and dimension tables.
• Involved in Development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Identified variousdatasources, formulateddatadictionaries, design and developdatamodels (physical/logicaldatamodels) based on the given specs and requirements.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
• Experience in Report Builder in SSRS 2008 and 2008 R2. Involved in creating, structuring, formatting using Report Designer and Report Builder.
• Scheduled and subscribed Reports based on a particular Day and sent them through Email in required format (Excel, PDF)
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.

Environment: MSSQL Server 2008 R2/2012, Visual Studio 2008/2010. Business Intelligence Development Studio (BIDS) 2008 R2/2012, MS Office 2007/2010, MS Visio, Toad

Confidential, Birmingham, AL

MSBIDeveloper

Responsibilities:

• Developed SSIS packages fordataintegrationfrom manydatasources such as Flat file, Oracle, Access orSQLServer 2012 intoSQLServer and deployed them using configuration tools.
• Formulated and implemented ETL process design according to business requirements and system specifications including source to target mappings,datadictionaries and transformations.
• Created highly complex SSIS packages using variousDatatransformations such as conditional splitting, derived column, Fuzzy Lookup, For Each Loop, Multi Cast, Merge, Error handling.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Created SSRS Report Model Projects in Visual studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Utilize SSRS for creating interactive reports such as sub drill through, drill down, grouping report, parameterized reports, Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports.
• Extensive understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Apply SSAS to deploy cubes with fact tables and dimensions tables. Upload and share cube information into Share Pointintegrationas well as output the cube into Excel using Power Pivot.
• Involved in designing OLAP cubes with star schema, writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Share point.
• Deployed designed dashboards & reports on MS SharePoint site using Performance Point Server Dashboard viewer Web Part for web based to access for multiple end users.
• Performed daily tasks including backup and restore by using tools likeSQLServer Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.

Environment: MSSQLServer 2012,SQLServer Reporting Service (SSRS),SQLServerIntegration Service (SSIS),SQLServer Analysis Services (SSAS), C#, ASP.NET, Visual Studio 2010 & T-SQL

Confidential, NY

SQL Server/SSRS/SSIS Developer

Responsibilities:

• Collected and managed data information including its branches, employees, subsidiaries, partners and stock holders.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Experience in Creating SSIS packages to integrate the data coming from various data sources.
• Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for a data warehousing and Data Migrations projects using Integration services (SSIS) on SQL Server 2005.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Responsible for the design of the SSIS packages for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database.
• Validated business rules and data mapping rules and Performed data modeling, data integration modeling and design.
• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Used various data flow and control flow controls for the ETL.
• Develop and support reports built with Microsoft Reporting Services on SQL Server 2005.
• Responsible for the reports deployment through SSRS on the Reports Server. Returned the stored procedure and the UDF for the reports.
• For successful or unsuccessful completion of scheduled Jobs.
• Set up database backup and recovery strategies.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.

Environment: MS SQL Server 2000/2005, SSIS, SSRS, Windows server 2003, Unix, Microsoft Visual Studio 2005, VB.Net, ASP.NET, MS Access, MS Excel, Adobe Photoshop, IIS 6.0, Crystal Reports, XML, DTD, Microsoft Visio, Oracle 9i/10g.

Confidential

SQL Developer (SQL, JAVASCRIPT, ASP.NET, SSRS)

Responsibilities:

• Performed the analysis and feasibility requirements.
• Created Stored Procedures, and other SQL queries for application using T-SQL
• Designed and developed interactive dashboards that enabled analysts to check various analytical systems.
• Experience with creating complex SSIS Package using proper control and data flow elements with error handling.
• ConfiguredXMLconfigfiles (. dtsconfig files) to change properties of packages dynamically.
• Developed web pages with client side scripting using JavaScript.
• Involved in database design.
• Performed Unit, System Testing and created several Test Cases to validate the data from reports.

Environment: Microsoft SQL Server 2005 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Report Manager, T-SQL, Microsoft VisualStudio-2005.