EXPERIENCE SUMMARY:

• 7 years of IT experience in the Design, Analysis, Development, Modeling, Implementation and testing of various applications, Decision Support Systems & Data Warehousing applications.
• Over 7 years of experience in database technologie like SQL Server, T - SQL etc.
• Experience in SQL Server, DML, DDL commands, Procedures, Views, Functions, Triggers and other database objects
• Having extensive programming skills in Visual Studio tool, Informatica, SSIS, SSRS, MS SQL Server, PostgreSQL 9.4
• Experience in working on multiple Projects at one time.
• Vast experience in work environment with a mix of onsite-offshore Global Delivery model.
• Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.
• Experience in reviewing and monitoring project progress, planning & managing dependencies and risks, resource planning, budget tracking and forecasting.
• Having experience in Lean, agile scrum Methodologies using JIRA.
• Good Hands on experience with Asp.net, C#, Visual Studio Programming and PDL (Parameter Definition Language), Standard environment on large scale implementation.
• Designed scalable architectures addressing parallelism, data integration, ETL, data repositories and analytics, making use of Informatica Powercenter suite and SSIS
• Good Hands on experience with Database such as PL\SQL, PostgreSQL worked with various utilities to load/unload large volume Data.
• Hands on experience in end-to-end of Data warehousing ETL routines, which includes writing custom scripts, stress testing, data mining and data quality process.
• Possess Strong Communication, Analytical, Project Planning, Problem Solving Techniques combined with a variety of Functional skills. Methodologies, as well as a sound understanding of financial accounting.

TECHNICAL SKILLS:

Database Tools: SQL, T - SQL, PL-SQL, PostgreSQL 9.4

ETL TOOLS: Informtica 9.5.1,9.6.1, SSIS

CASE TOOLS: ER-Win, MS Office, HP Quality Center, Git, BitBuket, Jenkins

Languages: C, C++, Asp.net, C#, VB, Java

Industry Solutions: Finance, Mortgage, Manufacturing

Database: SQL Server 2005/2008/2012

Scheduling Tool: Mainframe

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Consultant/ ETL

Responsibilities:

• Technical experience in designing (Mapping specifications, HLD, DLD), Development
• Understanding of the System Development Life Cycle (SDLC).
• Created Procedures, Sequences, Views, Fuctions etc using Oracle/DB2/SQL Server/MySQL/PostgreSQL databases.
• Monitor performance, availability, capacity, error-handling and dependencies while working on various advanced Computer Systems and tools viz. Informatica Powercenter/SSIS and Mainframe systems.
• Actively participate on System Design & Implementation reviews.
• Responsible for operational support of Production system
• Interact with All teams like Business Analyst, Development Team, Testing team, Configuration Management Team and Project Management.
• Collaborate with business partners, other functional groups within Sunlife and outside vendors to ensure the successful delivery of solutions.
• Develop/Modify subject area graphs based on business requirements using various Informatica Components like Expression, Joiner, Lookup, Union, Sorter, Router, Filter etc.
• Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Develop and execute T/SQL queries to ensure the application is getting valid data from the database.
• Used Clear Quest for defect tracking and also to generate tickets.
• Involved in writing Stored Procedures, Packages, functions and triggers in T/SQL.
• Provide 24*7 extended supports during the production rollout.
• Ability to handle multiple tasks, initiative and adaptable. Proactive team player with capability of handling responsibilities independently as well.

Environment: SQL Server 2012/2014, T/SQL, PostgreSQL 9.4, HP Quality Center, Git, Dimensions, Jenkins

SQL Server Developer

Confidential

Responsibilities:

• Participate in requirement meetings with Business Analysts to understand analytical content needs, assist in documenting these requirements, resolving ambiguities, conflicts, and ensuring requirements are complete.
• Involved in designing, implementing and maintained warehouse load graphs.
• Provided development for initial load programs to migrate production databases from DB2/SQL Server to Oracle data warehouse
• Increased Responsiveness and providing high availability. Managed offshore and onshore teams making sure the SLA’s are achieved by use standardized documentation and ticketing systems.
• Configured graph parameters, sandbox parameters, environment variables and EME Repository environment for Production/Development and performance tuning, code review for load graph process.
• Trained at understanding process requirements and providing use cases for business, functional & technical requirements
• Gained experience in interacting with users for requirement gathering; preparing functional specifications and low-level design documents
• Abilities in providing third level incident escalation support to the Technical Support Group for customization problems
• Developing and executing unit/basic/functional test cases and framework
• Participating and contributing in software improvements (products, processes, methods & tools), design inspection and code review
• Responsible for designing / developing database design in SQL Server 2008/2012
• Handled all the database related issues right from requirement phase till implementation phase; prepared LLD and HLD for the data flow through the system
• Analyzed end to end of whole of the project; BRD provided by the BSA onsite helped to get the overview of the business involved
• Extensively used the Powercenter/SSIS components like Joiner, Expression, Router, Sorter, Lookup, Input, Output and Join With DB etc.

Environment: SQL Server 2008/2012, T-SQL, PostgreSQL 9.4, HP Quality Center, Git, Dimensions

Confidential

Software Engineer - SQL Server, SSIS, SSRS, Asp.net, C#.net

Responsibilities:

• Participate in requirement meetings with the production team.
• The aim was to automatize the manual process currently in place on the manufacturing floor.
• Involved in designing, implementing and maintained various web/windows tools help to reduce the manual process involvement.
• Designed and deployed SQL Server 2005/2008 database by studying the business requirements from the functional design document and from the business users. Designing Data model documents/ data mapping documents.
• Support for different databases including the ERP solution.
• Increased Responsiveness and providing high availability. Making sure the SLA’s are achieved by use standardized documentation.
• Created data mart with loading data from ERP to custom database for daily/weekly night jobs
• Created design/development for various data reports in RAMCO ERP solution as per business requirements.
• Developed tools for Integration of various custom packages development in Asp.net with RAMCO ERP.
• Designing and developing SQL Archive Windows Service that helped to take the dump of major servers like Beta, FT and Production on nightly basis.
• Dump of database scripts into a single script file using SQL Compare 10 Tool. SQL files were checked out and check in in TFS to do the operation save which maintained its history.
• Designing/Developing the Sales Dashboard that list overall sales of the products of the company. This showed the data of sales by representative wise, product wise, quarter, monthly and yearly basis. It showed the graphical as well as grid view description of data. This tool used Ajax, Telerik web controls, SQL Server 2008 and Asp.Net 4.5, C#

Environment: SQL Server, SSIS,SSRS, Telerik, Javascript, Ajax, Asp.Net, C#.net, VB.net, SQL Compare 10 Tool