PROFESSIONAL SUMMARY:

• About 9+ of experience in IT, as MS SQL Server 2008/20 Database and ETL Developer.
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing applications and Software Development Lifecycle (SDLC).
• Expert in designing and implementing Database using various RDMSs like SQL SERVER, MS Access and DB2.
• In - depth knowledge in various RDBMS concepts like Database, Tables, Table Normalization, User Defined Data Types, Views, Indexes, Stored Procedures, User Defined Functions, Triggers, CTE (Common Table Expression) etc.
• Excellent knowledge in ETL (Extract - Transform - Load) using SQL Server Integration Services 2012\2008/2005 (SSIS), DTS, Bulk Insert.
• Expertise in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Expert in Data Migration. Formulated data from legacy systems.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using SSIS.
• Data migration (import & export - BCP) from Text to SQL Server.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle, DB2 etc.).
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Experience in designing and developing reports on SSRS (SQL Server Reporting Services).
• Knowledge of Scheduling and Deploying reports on Report manger.
• Worked on Parameterized, Chart, Graph, Linked, Dashboard, Drill-down and Drill-through reports in SSRS.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Worked very closely with Project Manager to understand the requirement of reporting solutions to be built
• Developed C#.NET scripts for SSIS packages.
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Knowledge of SQL Server solutions including Log shipping, database mirroring, Replication and clustering.
• Expert in Data Extraction, transforming and Loading using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy (BCP).
• Experience in SQL Server DTS and SSIS package design, construction and deployment from heterogeneous sources like Excel, CSV, Oracle, flat file by using multiple transformations.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Scheduling and Deployment of SSIS Packages.
• In-depth knowledge in Tuning SQL Queries and improving query performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

TECHNICAL SKILLS:

Programming Languages: Visual Basic 6.0, C, C++, Core JAVA, C#.net, SQL/PL-SQL, T-SQL, HTML, XML, Python.

RDMS and Database Tools & Technology: MS SQL Server 2005/2008\2012, Oracle 9i/10g, MS-Access, Query Analyzer, Management Studio, SQL Server Business Intelligence Development Studio, DB2.

Operating Systems: UNIX, MS DOS, Windows 95/98/NT/2000/XP/Vista/7

Utility & Tools: Microsoft Visual Studio2008 R2\2012, TFS, SubVersion, SQL Profiler, MS Office/Outlook Express, Squirrel.

PROFESSIONAL EXPERIENCE:

Sr. SQL Server / ETL Developer

Confidential, New Jersey

Responsibilities:

• Work Closely with Business Analysts to understand new requirements and t enhance the existing system.
• Responsible to configure the environments to Pull and Push data from/to various source systems like Loan Hub, Lease Hub, Finance Risk unit, HR etc.
• Create and configure Data-driven System for Consolidator and to Insert and maintain all data and tables.
• Worked on Stored Procedure with Dynamic SQL to load data into intermediate SQL table from various source system by dropping command file.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, SQL Profiler, Data base Engine tuning Advisor (DTA) and execution plans.
• Used Team Foundation Server (TFS) as configuration management tools for maintaining the code.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check
• Work on Schema compare between PROD, UAT and DEV environment by using Visual Studio to have all environment in Sync.
• Work to setup report deliveries to all desires business users on daily, weekly, monthly, and quarterly bases.
• Developed a whole new data driven system to generate and deliver reports for HR System.

Environment: MS-SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Management studio (SSMS), MS Visual Studio 2017, Bulk Copy Program (BCP), Microsoft Office, Team Foundation Server (TFS), Squirrel tool.

Sr. SQL SERVER\ BI Developer

Confidential

Responsibilities:

• Design/Develop\Schedule reports on daily basis through MS Access database.
• Convert legacy report from MS Access to SQL Server stored Procedure and schedule it through SQL job Agent.
• Developed SSIS Packages to extract\Transform data for universities study and Research purpose.
• Redesigned complicated SSIS packages from scratch after applying necessary transformations.
• Upgrade\Tuned existing SSIS packages for better performance.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2012 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Migrating SSRS Reports from SQL Server 2008 to SQL Server 2012.
• Building ad-hoc reports using SQL Server Reporting Services (SSRS).
• Experienced in creating SQL JOBS and scheduling and set alerts.
• Worked on UDS (Uniform Data System) for Data integrity and report performance.
• Worked on Azara (3rd party system) to Analyze clinical data and fixed major differences.
• Developed Unit Test Cases and document them as per Project standards.

Environment: SSIS 2012, Windows 7, MS ACCESS, SQL SERVER 2012, MSEXCEL.

Confidential

TECH LEAD\ SQL SERVER\ BI Developer

Responsibilities:

• Lead the team of 6 people at offshore.
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Worked with BAs to understand SAP system and Migration requirement.
• Daily Job include Management meeting, interaction with Business User as well as Offshore Coordination
• Design/Develop Plans to implement new changes to System.
• Working on Data Migration Legacy to SAP system which includes designing new SSIS Packages, Update existing packages, Schedule jobs and maintaining existing jobs.
• Develop Conversion for MS Access Code to SQL SERVER \SSIS.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources.
• Data migration (import & export/BCP) from Text to SQL Server.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Coordinating post-implementation events such as testing.
• Environment: SQL Server 2012, SSIS, T-SQL, VSS, VBScript, XHTML, XML.
• Actively involved in Normalization & De-normalization of database.
• Installed and Configured SQL Server 2000 on servers for designing and testing.
• Designed DDL and DML for MS SQL Server 2008.
• Working on Data Migration on Client, Vendor and Financial data from legacy systems.
• Tuning existing SSIS packages for better performance.
• Working on migrated packages to make it compatible with SSIS 2012 from DTS 2000.
• Every day Statue meeting with management and technical discussion with offshore team to resolve their issues and assign task.
• Created the SSIS packages and scheduled them.
• Extracted data from SQL Server using load it into a single data base repository.
• Design and Developing SSIS interfaces.
• Applied data cleansing techniques to ensure consistency amongst data sets.
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Data analysis, problem solving techniques to enable continuous business process improvement

Environment: SSIS 2012, Windows 7, MS ACCESS, SQL SERVER 2012.

Confidential

SQL SERVER\ BI Developer

Responsibilities:

• Working as SQL\BI Analyst\Developer for web based application.
• Daily Job includes Database development, Data loading through SSIS and Report creation.
• Working on Data Migration Project which includes designing new SSIS Packages, Update existing packages, Schedule jobs and maintaining existing jobs.
• Tuning existing SSIS packages for better performance.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Worked as an Analyst to figure out performance issues and to provide solutions to resolve them.
• Report creation through SSRS to support Donation Calculation.
• Use event handling to send E-mail on event like on error.
• Developed SSIS Packages to generate the reports in Excel sheets required by the managers for analysis.
• Design/Develop complex queries efficiently as per the given business requirements.
• Using Tortoise SVN for Sub Version and JIRA for issue tracking.
• Worked on Data Migration on Formulated data from legacy systems.
• Worked for Check Processing System - get files through FTP and load data into Relational database via stored procedure.
• Worked on EDW project include package designing and redesigning, C# script, DWH Modeling
• Worked on Automated Report - Created a job which execute stored procedure and then export data into excel file at network location.
• Worked on C# Script to handle non printable characters before loading it to Cubes.

Environment: SSIS 2008 R2, SQL Server 2008, Windows 7, SVN, JIRA, C# .net.

Confidential, Southborough, MA

ETL/ SQL Server/ BI Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements.
• Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move).
• Perform ETL processes using SSIS tool for SQL Server
• Design/Develop complex queries efficiently as per the given business requirements.
• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
• Worked on Table Partitioning to load current and historical data.
• Worked with Business users to understand the Business Logics as per the need.
• Worked with Financial data to calculate Comp.
• Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Implemented changes in Cubes (SSAS) as per the requirement.
• Created a cube in existing system and their respective Facts and Dimensions, Relationship and Partitioning.
• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze performance of System.
• Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins)
• Generated reports using SQL server reporting services (SSRS).
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
• Documentation of all the processes involved in maintaining the database for future reference.
• Perform /coordinated end to end Migration process in TEST /PROD ENV.
• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

Environment: SSIS/SSRS/SSAS, SQL Server 2008, VB.NET Query Analyzer, Windows 7, Team Foundation Server (TFS) NET Framework 2.0.

Confidential, Wayne, NJ

ETL/ BI Developer

Responsibilities:

• Work with BAs, DBAs and other Developers to analyze the system and developed plan accordingly.
• Work with DBAs to migrate databases from SQL Server 2005 to SQL Server 2008.
• Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL in SQL Server 2008
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system (CPODS) to Staging Environment and finally in Data Warehouse.
• Redesigned complicated SSIS packages from scratch after applying necessary transformations.
• Mainly responsible for the maintenance of dataware house and monitor jobs and ensure all packages are running without any interruption to users worldwide.
• Rework on migrated packages to make it compatible with SSIS 2008.
• Changed Stored Procedures, Functions, Views, and Triggers to add new features of SQL Server 2008.
• Experience in query optimization & performance tuning using SQL Profiler, Execution Plan and Performance Monitor.
• Rework on migrated packages to make it compatible with SSIS 2008.
• Deployed and Subscribe Reports using SSRS to generate Daily, Weekly, Monthly Reports.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server Profiler and Index Tuning.
• Documentation of all the processes involved in maintaining the database for future reference.
• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2008/2005, SQL Server Integration Service, Business Intelligence Development Studio T SQL, SQL Server Management Studio, C#.net.

Confidential

ETL-Informatica/ PLSQL Developer

Responsibilities:

• Based on the requirements, created Functional design documents and prepared the Technical design specification documents for ETL Process.
• Designed, developed and maintained Insurance policies and claims transactions Data Mart using Informatica Power Center.
• Analyzed, Designed, Developed, Maintained and tested Confidential Banking and Insurance application.
• Designed and developed to extract data from different sources like, Oracle tables, DB2 tables, and Flat files.
• Designed and developed mappings, enabling the extract, transport and loading the data into target tables.
• Updated centralized repository on daily basis, so as to provide recent data to other applications and to generate accurate reports.
• Created Complex mapping using Expression, Aggregate, and Lookup, Sequence generator, Update Strategy, Stored Procedure and Router transformations.
• Wrote PL/SQL commands as pre and post session tasks.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Designed/developed core Java/MQ Series server-side modules for processing different Insurance types.
• Designed/developed C++ based Confidential customer service application for communicating with Java server-side modules via MQ Series.
• Created various LINUX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using LINUX Shell Scripts.
• Used SQL Loader for data loading from external files into the Oracle database
• Developed Unit Test Cases and document them as per Project standards.
• Test data integrity among various sources, targets and various performance issues.
• Troubleshoot problems by checking sessions and workflow logs.
• Conducted training sessions and knowledge transfer to help internal team members.
• Responsible for Migrating the Informatica Processes from development to Test and production environment, set up security, groups and roles as well as define development standards and reviewing scripts to ensure they comply with guidelines.

Environment: Informatica 6.1/7.1,7.3 C++, Core Java, Mainframe, Flat Files, Shell Scripts, Windows 2000, Oracle, Linux, Power++, COBOL, JCL, SQL/PLSQL, SQL*Loader,Toad.