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.
• Has 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 knowledge 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 me has worked with Lookups, Fuzzy Lookup, Web Services, and Container and used dat 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 dat 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 teh Reports to Report Manager Website. Has worked with XML and Web Services.
• Programming knowledge in .NET and to connect teh .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 knowledge 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 teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Apply SSAS to deploy cubes with fact tables and dimensions tables. Upload and share cube information into Share Pointintegrationas well as output teh cube into Excel using Power Pivot.
• Involved in designing OLAP cubes with star schema, writing MDX queries and performance optimization of teh 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 teh data warehouse using Ralph-Kimball Methodologies.
• Created Stored Procedures, Views, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain teh required results. Involved in database designing using Normalization.
• Developed complex stored procedure using T-SQLto generate ad hoc reports using SSRS
• Create teh complex queries, joins and sub queries using cluster/non-cluster indexes on tables, Optimized indexes to improve queries and analyzed database performance withSQLProfiler
• Place teh huge table/non-clustered index on teh separate filegroupto improve teh performance.
• Traced complex stored procedures,SQLqueries and monitored usingSQLProfiler, Index Tuning Wizard.
• Resolved any deadlocks issues with teh 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 has frequent inserts, updates and deletes to reduce teh contention and to improve teh performance.
• Created SSIS Packages templates using based on teh 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 teh present columns for teh 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 teh history of records using Type 2 changes.
• Managed teh Metadata associated with teh ETL processes used to populate theDataWarehouse using SSIS packages.
• Created teh ETL templates, workloads and scheduled teh jobs to run automatically to process and loaddatain Main server teh samedatais replicated into teh Mart server for teh reporting purpose.
• Created SSIS packages and scheduled teh jobs to run automatically to process teh 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 teh 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 teh 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 teh 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 teh report execution time and to limit teh 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 teh 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 teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Apply SSAS to deploy cubes with fact tables and dimensions tables. Upload and share cube information into Share Pointintegrationas well as output teh cube into Excel using Power Pivot.
• Involved in designing OLAP cubes with star schema, writing MDX queries and performance optimization of teh 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 teh 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 teh design of teh SSIS packages for updating teh data mart from OLTP database and validation of teh aggregate data from teh ODS and teh 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 teh ETL.
• Develop and support reports built with Microsoft Reporting Services on SQL Server 2005.
• Responsible for teh reports deployment through SSRS on teh Reports Server. Returned teh stored procedure and teh UDF for teh 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 teh analysis and feasibility requirements.
• Created Stored Procedures, and other SQL queries for application using T-SQL
• Designed and developed interactive dashboards dat 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 teh 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.