SUMMARY

• Around Eight (8) Years of experience in the IT industry as a MS SQL Developer, OLAP environments and IBM message broker based applications.
• Developed automation scripts to do end - to-end testing.
• Made tremendous changes to the obfuscation process and the automation scheduler to work in an efficient way.
• Key participant in all phases of the SDLC ranging from requirement analysis design, development and testing.
• Expert in data migration experience, data quality assessment, data cleansing, loading and validation.
• Experience in error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures
• Skilled in sorting the data, defining subtotals for the reports
• Proficient in the use of T-SQL for developing complex stored procedures, triggers and functions
• Extensively worked and on all phases of testing (unit, system, integration, Regression, Product).
• Well versed with Operating systems Linux, Windows and UNIX like OS.
• Experience in using SQL Stored Procedures
• Expert in working with trace files and execution logs
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries
• Creating and managing roles for security in reports.
• Proficient in creating DTS packages for transferred data modifications.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills as well as flexible to learn advancements in the IT industry.
• Effective management on multiple projects in order to meet deadlines.

TECHNICAL SKILLS

Database: SQL Server 2000, 2005, 2008, Oracle 10i

Operating Systems: Windows XP/2000/2003

Programming Languages: SQL, PL/SQL, C, C++, C Sharp, UNIX

Reporting Tools: SSRS, Crystal Report

ETL Tools: SSIS, DTS, SQL Loader

Application Servers: Internet Information Server (IIS) 5.0, 6.0

PROFESSIONAL EXPERIENCE

Confidential, Moorestown, NJ

Oracle Database Administrator

Responsibilities:

• Working on Database Load Performance, Database Mirroring for environments which includes data for more than 2 set of environments of 1 TB.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Setting up scripting for managing databases when the system agents go offline.
• Working on Database Clustering and managing load between different databases across multiple environments.

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, Microsoft Visio, SFTP, Microsoft Reporting Services.

Confidential, New York, NY

Application Developer/Technical Lead

Responsibilities:

• Developed and configured applications for Data Obfuscation in Investment Banking.
• Delivered close to 100 applications in single calendar year (2014).
• Project Management for the entire project which includes giving weekly status reports to the client, interacting with the EDO3 Product Team, EDO3 Environment Management Team.
• Co-ordination with EDO Infrastructure team to resolve issue related to tasks, logs, UI with EDO3 Automation Process.
• Preparing high level numbers, status for all the Product Lines and delivering them to the end-client on a monthly basis.
• End-to-end responsibility of the project including deliverables, issues, status, co-ordination with different teams across the globe.
• Migration of all applications from US, UK, SNG from EDO2 to EDO3 Version.
• Fixing Issues such as Database Connectivity, Enabling/Disabling Constraints/ Triggers to perform successful anonymization on EDO3.
• Coordinating with Control-M team to build various functionalities to the automation process in EDO3.
• Used Control-M jobs for end-to-end data automation process and data validation.
• Created INC and RFC groups for the team to keep records of the different requests.
• Responsible for data load on the destination using the process of data anonymization.
• Data Obfuscation for Investment Banking applications.
• Performed testing for different validation purposes.
• Transfer obfuscated data using EDO2 and EDO3.
• Work with offshore team on Control- M training and obfuscation process on a daily basis.
• Generated snapshot report at the end of data obfuscation for each application for the purpose of validation of the different tables in the schema.
• Worked on different SQL queries to check the record count in source and destination, before and after Data Obfuscation.
• Administration of Sybase and Oracle environments.
• Create, modify and test the snapshot reports for auto validation.
• Worked on numerous NTPA and Asset Servicing Applications.

Environment: MS SQL Server 2008, RapidSQL, EDO2, EDO3,Unix, SQL Developer, MS Outlook, MS SharePoint, MS Excel, Windows 7.

Confidential, Boston, MA

SSIS/SQL Developer

Responsibilities:

• Developed SSIS Packages for running the different claims.
• Generated automated passwords for sending email to the different clients.
• Responsible for auto- generation of different user ids for the users.
• Write Stored Procedures, Views and Functions to support reports.
• Created SSIS package for finding dentists in the Mid- Atlantic area.
• Ran the Commercial Extracts for sending it to the client ‘Healthation’.
• Used T-SQL for automating backend processes.
• Developed and tested user friendly navigator by utilizing JavaScript and VB.NET.
• Developed COM components in VB to implement business rules and data access objects.
• Performed testing tasks for different validation purposes.
• Generated the extract validation report for checking the reason for the errors occurred in the different tables.
• Send notifications and data via email to the different users.
• Worked with project sponsors and team leaders to prioritize existing and new issues based on the size of the impact on process efficiency, data quality, the Project timeline, and the organization’s ability to affect change.
• Testing the emails sent to the different users using the application.
• Responsible for dealing with the end users for any production support issues.
• Provide technical support to end users.
• Strong in SQL, scripting, and understanding of how web access to SQL needs be configured.

Environment: MS SQL Server 2008, MS Visual Studio 2010, MS Outlook, MS SharePoint, MS Excel, SQL Server Profiler, Windows XP, C- Sharp

Confidential, Minneapolis, MN

SSIS/ SQL Developer

Responsibilities:

• Developed scripts for building stored procedures in SQL
• Modified procedures to check them back into TFS
• Responsible for the creation of the applications by using vb.net and enhancement of the projects for .net applications
• Responsible for the automation and the development of the business environment
• Managed XML scripts to build codes for SSIS packages
• Data analysis and reconciliation
• Write Stored Procedures, Views and Functions to support reports
• Develop and customize reports to support the hedge fund of funds business
• Worked to improve the performance and migrate the existing database application
• Used .NET to develop the codes and migrate to production
• Developed advanced workflow - based on event notification applications using the SSRS to notify subscribers via email
• Administration of Microsoft SQL Server Database environment
• Delivered package enhancements for the promotion to UAT.
• Performing testing tasks with a minimum of oversight and direction.
• Responsible for transferring the data using SSIS packages.
• Worked in support of a custom .NET development environment.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Worked with the production and data warehouse teams.
• Created indexes, constraints and rules on database objects.
• Knowledge of data warehousing concepts.

Environment: MS SQL Server 2005, MS SQL Server 2008, C-Sharp, MS Visual Studio 2005, Unix, Oracle, MS Visual Studio 2008, Windows XP, MS Outlook, MS Excel, SQL Profiler.

Confidential, Hartford, CT

SSIS/ SQL Developer/SQL DBA

Responsibilities:

• Worked on the database to build the reports using SSRS 2008.
• Created the data sources to get the required data.
• Generated data sets from the stored procedures created using SQL Server 2008 R2.
• Built stored procedures for the balanced and control reports required for product design.
• Strong in SQL, scripting, and understanding of how web access to SQL needs be configured.
• Analyzed Requirements, Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new system.
• Send notifications and data via e-mail; asSSRSdata sets; and for SharePoint and other web front ends
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports
• Worked as a data architect for the BI environment.
• Created Packages that dealt with text files containing dynamic number of columns.
• Designed and Implemented row-level access control for users to access detail reports.
• Designed and implemented datasets and layouts for various reports with SSRS.
• Retrieved data from cubes and generated OLAP reports with SSRS and SSAS.
• Maintained data integrity by performing validation checks.
• Developed complex stored procedures for ETL.
• Loaded data from heterogeneous sources using various tasks and transformations in SSIS.
• Created jobs to automate and schedule data loading, backup, reporting with SQL Server agent.
• Worked with 64 bit Windows OS.

Environment: SQL Server 2008, C-Sharp, SSAS 2008, SSRS 2008, MS Outlook 2010, Unix, Oracle, ASP.NET, MS Excel, Windows XP.

Confidential, Howell, NJ

SSIS/ SQL Developer

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Involved in development and implementation of SSIS application solutions for various business units across the organization.
• Responsible for transferring the data using SSIS packages.
• Responsible for data migration in SQL Server.
• Worked on data quality assessment, data cleansing, loading and validation.
• Created report models for Report Builder and managed reports using Report Manager.
• Involved in creating Technical specification Document (TSD) for the project.
• Designed and implemented complex ETL packages.
• Implemented the calculations to aggregate physical measures.
• Designed and developed the database infrastructure.
• Created ER Diagrams (physical and logical) and mapping the data into database objects.
• Normalized the database into small tables by applying Normalization, defined Check constraint and applied Business Rules.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), C-Sharp, Unix, Oracle, MS SQL Reporting Services 2005, ASP.NET, MS Excel, Windows XP.