PROFESSIONAL SUMMARY:

• 7 years of IT experience and expertise in Designing, Development, Implementation and Maintenance of applications. Strong programming knowledge in TSQL, PL/SQL Development(SQL SERVER 2008,2012,2014) and Report Development (SSIS,SSRS), Performance Analysis, Deployment Script Development, Production Support.
• Experience in MS - SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Incremental Loading, Data Cleansing and Data Migration.
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sources.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and Building Referential Integrity Constraints.
• Excellent T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan.
• Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
• Report Service experience with Microsoft Excel Power Pivot.
• Defined Indexes to implement business rules.
• Experience in creating views to facilitate easy viewing implementation.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Involved in migration of DTS Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating several reports such as drill down reports, parameterized reports, and linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Experience in administratingthe reports to assign permissionto the valid users for executing the reports.
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Experience in configuration of report server and report manager scheduling, permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in building Star schema and Snow Flake schema depending on business requirements.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Worked with DBA’S monitored daily jobs for all environments and resolved the bugs if job fails.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/XP, 2003/2008 Server, Windows 7.

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

SQL Server Tools: SQL Server Management Studio(SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Incremental loading

Reporting Tools: SQL Server Reporting Services (SSRS),Tableau

Schema: Star and Snow flake

ETL Tools: SQL Server Integration Services (SSIS).

Data Modelling: Erwin 4.5/4.0/3.5, Data Modeling, Dimensional Data Modeling, Data Modeling, FACT and Dimensions Table Modeling.

Languages: T-SQL, PL/SQL, VBScript, HTML, XML,C# (.NET)

Packages: MS Office 2000/2003/2007

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

MSBI and TSQL Developer

Responsibilities:

• Prepared the Technical and Function specifications based on the project requirements.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Create ad hoc and standard reports using various reporting tools for different functional areas of the company.
• Modified stored procedures to meet current design and used them in SQL Server.
• Developed queries in Data Warehouse in OLTP/OLAP environment.
• Worked on SharePoint, Excel Pivot.
• Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Modified web pages to do database inserts, deletes, modify.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Created report models from OLTP & OLAP.
• Trained 10 business users so that they can create reports from the report model I created.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Involved in Development, Review and testing of the new system by implementing business rules and transformations.
• Worked on SharePoint, Excel Pivot.

Environment: SQL Server 2012, T-SQL, MS Integration, Analysis and Management Studio, Windows 2007 Server, Tableau, SQL Server Management Studio, Business Intelligence Development Studio (SSIS, SSRS), MS-Visual Studio, OLTP, OLAP, XML,C#, MS Excel, Visio, Sharepoint.

Confidential, RI

MSBI and TSQL Developer

Responsibilities:

• Responsible for Dimensional Modeling based on the client requirements.
• Expert in working with BIDS, which includes SSIS, SSRS.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Incremental loading, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Modified web pages to do database inserts, deletes, modify.
• Designed Star Schema for the project.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Created Deletion script for removing data which is older than 13 months from PROD.
• Created Automated Archival Script, which archives all data from PROD to Archive server monthly.
• Migrated all data from Development to UAT and then to PROD.
• Worked with DBA for any issues while going live to PROD.
• Provided hot fix on the PROD Issues.
• Identified Test Case for QA environment, resolve DB performance and did performance tuning for slow running queries.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Worked with new UI Archive website development and backup the DB and Restored in a new Archive server.
• Tested new GUI with multiple test cases for generating different reports and worked on optimization process.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Worked in Production support team to resolve various prod issues for the users.
• Worked with DBA to deploy SP from DEV to UAT and PROD.
• Worked with release team for migration of data.
• Worked for different QC’s for data optimization and better timings for report generation.
• Worked with different error handling techniques(e.g. Begin Try-End Try and Begin Catch-End catch)
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Generated reports client in Tableau.

Environment: SQL Server 2012, T-SQL, MS Integration, Analysis and Management Studio, Windows 2007 Server, Tableau, SQL Server Management Studio, Business Intelligence Development Studio (SSIS, SSRS), MS-Visual Studio, OLTP, OLAP, XML,C#, MS Excel, Visio, QC

Confidential, NJ

MSBI and TSQL Developer

Responsibilities:

• Created SSIS packages to retrieve data from different business sources, retrieve user data from the Flat files on monthly and weekly basis, file Transfer from one location to the other using FTP task.
• Designed database after analysis of the business requirement.
• Worked with an offshore development team, communicating on a daily basis with the team.
• Designed the complete flow of the file processing.
• Designed power shell to monitor the file location for the file existence and copy/move to specific location after looking at a character inside the file.
• Designed the file processing using the queue (first in first out) concept.
• Created complex expressions using the MDX scripting to solve complex designs.
• Implemented the Queue logic by starting SQL Agent jobs( which pointed to deployed SSIS packages on the integration server)
• Deployed SSIS packages with a simple one-click deployment to the integration server.
• Maintained different branches in TFS as development for release 2 and testing for release 1 were together.
• Expertise with Agile & waterfall methodology
• Deployed different database instances for development, QA, UAT and production from TFS.
• Used Update and Merge statements while working on the Incremental loads.
• Worked with different Control flow tasks in creating SSIS packages such as Data Flow Task, For Loop and For Each Loop containers with Execute SQLand Script Tasks.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Drill through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.

Environment:SQL Server 2012/2008R2, SQL Server Management Studio, Business Intelligence Development Studio (SSIS, SSRS), MS-Visual Studio, OLTP, OLAP, XML, MS Excel, C#

Confidential

SQL Server Developer

Responsibilities:

• Performed validation and quality control checks of SQL programs.
• Wrote T-SQL queries and T-SQL stored procedures in SQL SERVER 2000.
• Added / Changed Tables, columns, triggers, and T-SQL code. Using Indexes, Views, Trigger and Store Procedures for updating and cleaning the existing data and also the new data which was to be added.
• Configured complex SQL queries to meet customer requirements as needed.
• Provided data verification and tuned queries to define the requirements.
• Developed custom reports for contact management information system.
• Scheduled jobs, database backup, and database restore.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Created complex reports using cascading prompts, decode objects etc.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones

Environment: SQL Server 2000, Windows NT, Access 2000, Query Analyzer, Enterprise Manager, Erwin, Data Transformation Services (DTS).