SUMMARY

• Around 11 Years of experience in the Information Technology.
• As part of my assignments, I have been working in Data Analysis, Development, Application Maintenance, Functional Studies, and Quality Reviews. Possesses excellent analytical, communication, presentation and team work skills.
• Build new tool (Dashboard) for users to easily pull data from different sources,
• Provide different access levels for different types of information as there may be multiple business roles and uses.
• As part of UW 2.0 phase I process, application data gets submitted into USE (Underwriting Score Engine) via Salesforce by Application Coordinator or via eApp process.
• USE collects evidence data and calculates risk class and underwriting path based on the application and evidence collected.
• USE results along with the evidence (e.g. MIB, MVR, RX, etc.) collected are required to be imaged into individual documents and then linked to the corresponding Siebel activities.
• As responsibility he collaborates with client business partners during requirement gathering phase to document the functional requirements and non - functional requirements such as performance, scalability and maintainability.
• Creates detail technical design document and provide architecture design solution for complex business requirements.
• Develops complex ETL packages to reduce manual data processing in SSIS technology. Develops database objects such as stored procedure, user defined functions and views to fulfil business requirement in SQL server 2016 environment.

TECHNICAL SKILLS

• SQL SERVER INTEGRATION SERVICE (SSIS) 2008, 2012,2014
• SQL SERVER REPORTING SERVICE (SSRS) 2012,2014
• SQL Server 2005, 2008, 2012,2016
• Microsoft .NET Framework 4.0
• Programing Language: C#, VB
• Microsoft Office VBA
• Tableau 10.5

Confidential, Deerfield Beach, FL

Responsibilities:

• Confidential plays Onsite Tech lead role and as responsibility he collaborates with client business partners during requirement gathering phase to document the functional requirements and non - functional requirements such as performance, scalability and maintainability.
• He creates detail technical design document and provide architecture design solution for complex business requirements.
• He develops complex ETL packages to reduce manual data processing in SSIS technology. Develops database objects such as stored procedure, user defined functions and views to fulfil business requirement in SQL server 2016 environment.
• He develops complex reports in SSRS and Tableau environment.

Confidential, Research Triangle Park, NC

Responsibilities:

• Confidential plays Onsite Tech lead role and as responsibility he coordinates with client to understand business logic and based on discussion prepared high level design document.
• He prepared work task list with estimated time.
• He is working with business analyst and profiling the data.
• He implements the SSIS packages, write complex SQL, Stored Procedure and analysis script.
• He has prepared UTCL and completed the unit testing.
• He has prepared the batch script to run SSIS package and worked for job scheduling on CAWL automation tool.

Confidential, Boston, Massachusetts

Tech lead

Responsibilities:

• Confidential plays Onsite Tech lead role and as responsibility he coordinates with client to understand business logic and based on discussion prepared high level design document.
• He prepared work task list with estimated time.
• He is working with Data Modeller to finalize the Stage table schema.
• He prepared the ETL Design. He implemented the SSIS Packages, Stored Procedure, and Functions as a part of development.
• He prepares SQL script to transact with database.
• He prepared an automation tool (SSIS and VB.NET) to prepare dummy data for system. He is used to do unit testing and integration.

Confidential, Boston, Massachusetts

Responsibilities:

• Confidential plays Onsite Tech lead role and as responsibility he coordinates with client to understand business logic and based on discussion prepared high level design document.
• He prepared work task list with estimated time.
• He prepared process flow diagram to help design mapping sequential in workflow.
• He provides technical assistance for .NET technology.
• He helps to update design for process improvement.
• He is used to do unit testing and integration.

Confidential, Boston, Massachusetts

Responsibilities:

• Confidential plays Onsite Tech lead role and as responsibility he coordinates with client to understand business logic and based on discussion prepared high level design document.
• He used to prepare SQL for data pulling.
• He prepared XSD to use XML generation process at target in Informatica.
• He prepared Stored Procedure, Functions to enhance the application performance.
• He prepared process flow diagram to help design mapping sequential in workflow.
• He is used to do unit testing and integration.

Confidential, Boston, Massachusetts

Responsibilities:

• Confidential plays Onsite Tech lead role and as responsibility he coordinates with client to understand business logic and based on discussion prepared high level design document.
• He used to prepare SQL for data pulling.
• He prepared an automation tool in SSIS to extract data.
• He prepared Stored Procedure, Functions to enhance the application performance.
• He prepared process flow diagram to help design mapping sequential in workflow.
• He is used to do unit testing and integration.

Confidential, Boston, Massachusetts

Responsibilities:

• Confidential worked as a lead developer and as responsibility he prepared SSIS package and Stored procedure.
• He used to design report and write code in .NET framework to generate the report through crystal report assembly.
• He created deployable module and used to do unit testing and Integration testing.

Confidential, Boston, Massachusetts

Responsibilities:

• Confidential worked as a lead developer and as responsibility he prepared SSIS package and Stored procedure.
• He used to design report and write code in VBA to generate the report.
• He created deployable module and used to do unit testing and Integration testing.