SUMMARY

• 9+ Years of experience as MSBI Developer and Data Analyst in Production, Development and Staging Environments.
• Extensively worked and used SSIS 2005/2008/2012 , SSRS, Crystal Reports 2008, and Business Objects 6.5.
• Worked with RDBMS like SQL Server 2000, 2005, 2008, 2012 and Oracle 10g.
• Fair exposure on SSAS and MDX queries.
• Experience in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler.
• Experience in solving Real Time issues with Query Tuning, Error and Event Handling.
• Experienced in T - SQL programming tasks - Stored Procedures, Functions, Views, Triggers and Cursors using SQL Server 2012/2008/2005.
• 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.
• Expertise in Developing and generating reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Experienced on Various enterprises Job scheduler tools such as TIDAL, Auto-sys for scheduling and managing jobs.
• Experienced in all phases of SDLC such as Analysis, Design, Development, Testing and Implementation of enterprise wide applications and Reporting services.
• Experience on Developing Enterprise applications using .Net Framework (VB.Net, C#, ASP.Net), AJAX and IIS
• Strong Communication & Management skills with Excellent Role playing capabilities.
• Hardworking, enthusiastic and highly committed to the growth and success of the organization.
• Possess good work ethic and high-level of integrity.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012

Data warehousing & Reporting Tools: SSIS 2005/2008/2012 , SSRS, SSAS, Crystal Reports 2008/XI

Microsoft Technology: .Net Framework 2.0/3.5, ASP.Net, AJAX

Programming Languages: C#, VB.Net

Operating System: Windows Server 2000, Windows XP, DOS

Other Tools: TIDAL, Autosys

Functional Domain & Product Knowledge: Capital Market, Wall Street Office (WSO) Accounting System And WSO Reporting

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Associate

Environment: SQL server 2012, SSIS, SSRS, SSAS, Import/Export tools, and Control M Scheduler.

Responsibilities:

• Database Schema Changes: Implement the Database Schema Changes to support the change Request/New features.
• Reporting Changes: Create/Modify new business reports for different clients.
• ETL (Extract Transform Load): Load the Different source files which users get and load it to a master database on which the client reports are generated.
• Modify the design/Framework to support the new enhancement as required.
• Application Changes: to implement the change requests and prepare the release notes for the deployment of these services and applications to production.
• Perform Integration testing of the application in different environments.
• Analyzing and reporting the issues identified in sanity check in Quality center.
• Resolving application specific deployment issues.
• Uses the capabilities as a system analyst to build various systems for client after doing analysis and requirement gathering.
• Involves in discussions regarding scope and approach of new change requests.
• Involves in Business discussions with Business Analysts to analyze the business requirements.
• Coordinate with offshore team to discuss the deliverables on daily basis and also transfers the requirements from the clients to offshore team.
• Reviews the deliverables delivered by offshore team.
• Supports the client for any information on existing systems and their support.

Confidential, Virginia Beach, VA

Senior Associate

Environment: SQL server 2012, SSIS, Import/Export tools, Oracle and TIDAL Scheduler.

Responsibilities:

• Developed and Implement Automation Tool using SQL Server 2012 and SSIS which allows to manage Sequencing and Dependencies among various process outside the TIDAL Job Scheduler and Execute SQL Stored Procedures using configuration Rules in the database.
• Create Procedures, SSIS packages to consolidate data from Staging Database and Flat Files and load into FACETS.
• Design and Implemented complex dynamic SSIS 2012 packages - Pipeline & Staging table QC.
• Write Complex custom script for SSIS ETL Jobs using C# and VB.Net.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks
• Involved in Data Migration using SQL Server 2012 and SSIS.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels.
• Prepared Unit test cases for existing functionality as per the requirement and execute the same.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Operation Team.

Confidential, Boston

Project Lead

Environment: SQL Server 2005 and SQL server 2008, SSIS, Import/Export tools, Wall Street Office (WSO) Reporting and Scheduler, Net Framework 3.5, C#.Net, Asp.Net2.0

Responsibilities:

• Create Procedures, SSIS packages to consolidate data from production Database and Flat Files to BI Database.
• Convert Legacy ETL jobs which are developed in Open source tool to SSIS ETL Jobs in SQL server 2008.
• Design and Implemented complex dynamic SSIS 2008 packages - Pipeline & Staging table QC.
• Write Complex custom script for SSIS ETL Jobs using C# and VB.Net.
• Reports development and Deployed Reports on Report Server using SQL Server 2008 Reporting Services (SSRS).
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, reporting and scorecard / dashboards on SQL Server 2008 using SSIS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of Data Stage Jobs to SSIS packages
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks
• Implemented new T-SQL features in SQL Server 2005 like Partitioning, Advanced Error handling, Common Table Expression (CTE)
• Prepare Unite test cases for existing functionality as per the requirement and execute the same.

Confidential

Consultant

Environment: SQL Server 2005, SSIS, Net Framework 3.5, C#.Net, Asp.Net 2.0, Java Script, AJAX

Responsibilities:

• Interacting with OSC for meeting up daily requirement.
• Worked extensively on ASP.Net & AJAX with hands-on coding in C# for developing Web Pages.
• Database designing and development.
• Involved in writing Stored Procedures and User Defined Functions, Cursors.
• Design and Developed SSIS Jobs to Export and Import Customer and Product Data from various source like Oracle, CSV, Fixed Width Delimited, Excel and Text file.
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Prepared Unit test cases for existing functionality as per the requirement and execute the same.

Confidential

Officer - IT

Environment: SQL Server 2005, Microsoft.Net Framework 3.5, C#.Net, Asp.Net 2.0, Java Script, AJAX

Responsibilities:

• Interacting with Business Users for meeting up daily requirement.
• Requirement Analysis and System Analysis.
• Worked extensively on ASP.Net & AJAX with hands-on coding in C# for developing Web Pages and Integrating into Croda Biz Connect Web application.
• Database designing and development.
• Involved in writing Stored Procedures and User Defined Functions, Cursors.
• Prepared Unit test cases for existing functionality as per the requirement and execute the same.

Confidential

Environment: SQL Server 2005, SSIS, DTS, Business Objects 6.5., Crystal Reports

Responsibilities:

• Administrating Data Load Packages for loading data from Global Max Database to Griffin World view (Bombay, India), everyday.
• Create Procedures, DTS & SSIS ETL packages to consolidate data from Griffin - America, Griffin - Singapore, Griffin - London and Griffin Global ACE data.
• Designed complex dynamic SSIS package to extract data from Global Max Database (Houston, USA) into SQL for Data Analysis and Reporting.
• Create DTS packages for the Metadata extraction of File information of Over 500+ documents for migration.
• Converted Unix Shell Script to T-SQL scripts, C# component, VB.Net ETL scripts and SSIS transformation.
• Converted Legacy ETL packages from Macros, Stored Procedures and DTS to Dynamic SSIS Packages for SQL Server 2005.
• Checking data consistency between Global Max Database and Griffin World View database.
• Development of new Confidential reports, refreshing the existing Report and Customization of reports as per the Requirements.
• Working with Business and Technical users, developed complex dynamic Business Objects and Crystal Reports (Parameterized Matrix Multilevel) Reports.

Confidential

Software Engineer

Environment: SQL Server 2000, Microsoft.Net Framework 1.1, C#.Net, Crystal Report

Responsibilities:

• Requirement Analysis and System Analysis.
• Worked extensively on C# And VB.Net for developing Windows Forms
• Database designing and development.
• Crystal Report Template designing and development.
• Involved in writing Stored Procedures and User Defined Functions, Cursors.
• Prepared Unit test cases for existing functionality as per the requirement and execute the same.