PROFESSIONAL SUMMARY:

• Over 8 + years of experience in IT Industry wif rich experience in Design, Development and Implementation on SQL Server 2005/2008/2012/2014, SSIS, SSRS, ETL, ASP.NET, C#, VB.NET, ADO.NET, CSS, JavaScript.
• Experience in all stages of Software Development Life Cycle (SDLC) including Requirements, Analysis and Design, Implementation, Integration, Testing, Deployment and Post Development Maintenance in Waterfall & Agile Methodologies.
• Experienced wif MS SQL Server 2005/2008/2012/2014, Oracle and proficient in writing Queries, Views, Stored Procedures, Cursors, Triggers and User Defined Functions
• Expertise in Object oriented programming (OOPs) concepts.
• Experienced in creating SSIS packages and deployment.
• Experienced in creating reports using SSRS and Crystal Reports.
• Experienced wif Access and proficient in writing Queries to store and retrieve data.
• Experience in creating web based applications using technologies like ASP.NET, JavaScript, JQuery, XML, HTML, CSS and AJAX.
• Expert in High Level Design of ETL/ SSIS Package for integrating data from heterogeneous sources (Excel, CSV, flat file, Text Format Data) using SSIS Packages.
• Excellent working experience in design and development of several reports using Crystal Reports and MS SQL Server Reporting Services 2008 (SSRS) from OLTP and OLAP data sources.
• Working in Erwin tool for data modeling.
• Strong Database Objects development - Tables, Views, Triggers, Stored procedures, Cursors using SQL Server 2008/2005.
• Excellent knowledge in Enterprise Manager, T-SQL, SQL Profiler, Query Analyzer and Execution plan.
• Database/Data migration from Database to Database and SQL batches.
• Experience in Oracle to SQL Server Migration using SSIS tool.
• Experience in creating Windows Services and windows based applications using C#.NET & VB.NET
• Extensive experience in Fraud applications - AML (Anti Money Laundering) Concepts and Data Validity Filters.
• Experience in using teh Actimize Risk Case Manager Tool and Actimize Modeler.
• 4.5 years of experience in Banking and Financial Domain.
• Good exposure on Anti Money Laundering and Know you're customer policies.
• Experienced in creating jobs and scheduling them.
• Good Experience in using teh Actimize Visual Modeller 4.9 and Actimize Risk Case Manger 5.1
• Experience in creating Databases objects on MS SQL Server 2005/2008.
• Experience in Version Control Tool like TFS and SVN.
• Good Experience in Designing object oriented applications using MS Visio.
• Experience in design and development of Multi-tier and Client-Server applications.
• Experience in Setup and Deployment of Projects.
• Experience in requirement review and estimation, project schedule management.
• Experience in task allocation among various resources in teh team and professional interaction wif teh client regularly.
• Worked extensively wif Agile Methodologies (SCRUM) and Waterfall Methodologies
• Flexible, Result-oriented and easily adaptable to teh environment to meet teh goals of teh team and teh organization.

TECHNICAL SKILLS:

Databases: SQL Server 2005/2008/2012/2014, Teradata, Oracle, T-SQL, Erwin

Languages: C#.Net, VB.NET, ASP.Net, SQL, PL/SQL, Core Java, JavaScript, VB Script, MVC, WCF

Data Warehouse ETL: SSIS.

Reporting Tools: SSRS, Micro strategy.

Operating Systems: Windows 2000/XP/2003

Methodologies: Waterfall, Agile

Tools / Utilities: Actimize Risk Case Manager 5.1, Actimize Modeler 4.9, Team Foundation Server, Tortoise SVN, Autosys, HP Quality Center, Red Gate, Blade Logic.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. SQL developer

Tools: Visual Studio 2010, SQL Server Management Studio 2012/2014, Business Intelligence Development Studio, SVN, Actimize Modeler, Actimize Risk Case Manager, Blade Logic, Repliweb, Tectia.

Responsibilities

• Understand business/user requirements and translate them to technical specification.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from AML DB Source, Excel Spreadsheet to SQL Server 2012/2014.
• Create Entity Relationship (ER) Diagrams to teh proposed database
• Create database objects such as tables,views, stored procedures, Triggers etc.
• Maintain referential integrity, domain integrity and column integrity by using teh available options such as constraints etc.
• Identify columns for Primary Keys in all teh tables at teh design time and create them.
• Create functions to provide custom functionality as per teh requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Endure that teh code is written keeping in mind any security issues such as SQL Injection.
• Experience in single & multi parameterized reports and created interactive sorting reports.
• Handled multiple data sources and data sets in a single report.
• Design and Develop RDLs using SSRS to show teh reports to Agents.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Involved in logical and physical database design discussions wif DBA team.
• Written SQL Stored Procedures, functions and Triggers for SQL Server.
• Provide configuration management and version control of application code and database.
• Designed CSS aiming for a rich presentation of UI.
• Extensive experience on Team Foundation Server application for teh task to coordinate teh work flow.
• Provide suggestions for improvements to Application systems.
• Providing clarification to business users and technical support team.
• Providing Technical Hand Off to support team and teh necessary documentation.
• Correct system errors/fixes/changes implementation as per user-defined requirements as business practices change.
• Used JavaScript for client side validations.
• Designed Master Pages wif Menu Controls.
• Involved in application code deployment to production servers.
• Coding to implement teh specification. Unit Test teh component developed. Build deployment guides. Support UAT and Production deployment.
• Fix any bugs arising out of SIT, UAT and any other test process. Schedule, Identify Project Milestones and Track Progress against these milestones.
• Ensure Adherence to established Quality Standards. Status reporting, customer interface and coordinating wif teh offshore development team.
• Customer Relationship Management Managing Customer Expectation and Ensuring Customer Satisfaction.

Confidential

Tools: Visual Studio 2010, SQL Server Management Studio 2012, Business Intelligence Development Studio, SVN, Actimize Modeler, Actimize Risk Case Manager, Blade Logic, Repliweb, Tectia.

Responsibilities

• Created SSIS Packages using SSIS Designer to export heterogeneous data from AML DB Source, Excel Spreadsheet to SQL Server 2012.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Develop and maintain data-centric web applications using .NET including ASP.NET, C#.Net, Web services.
• Understand business requirements and translate them to technical specification.
• Proposed and implemented Windows shared file reading which is more efficient in large file processing.
• Extensive experience deliveringOLAPsolutions by developingCorporate Dashboard Reports usingSQL Server Reporting Services (SSRS).
• Analyzed teh bottlenecks in teh stored procedures, SQL queries and tuned them for improving teh performance of teh application, creating new stored procedures & SQL scripts as part of teh enhancements.
• Correct system errors/fixes/changes implementation as per user-defined requirements as business practices change.
• Extensive experience on Team Foundation Server application for teh task to coordinate teh work flow.
• Prepared Unit Test Cases and Design Documents.
• Performed unit testing to verify if teh requirements are met.
• Providing clarification to business users and technical support team
• Providing Technical Hand Off to support team and teh necessary documentation.
• Used Agile and Scrum development cycles.
• Created Generic controls to serve teh purpose as filters for report generation which helped in reducing teh effort to create new user controls each time a new filter TEMPhas to be created.
• Coding to implement teh specification. Unit Test teh component developed. Build deployment. Support UAT and Production deployment.
• Fix any bugs arising out of SIT, UAT and any other test process. Schedule, Identify Project Milestones and Track Progress against these milestones.
• Ensure Adherence to established Quality Standards. Status reporting, customer interface and coordinating wif teh offshore development team.
• Customer Relationship Management Managing Customer Expectation and Ensuring Customer Satisfaction.

Confidential

Tools: Visual Studio 2010, SQL Server Management Studio 2008, Business Intelligence Development Studio, SVN, Actimize Modeler, Actimize Risk Case Manager, Blade Logic, Repliweb, Tectia.

Responsibilities

• Understand business requirements and translate them to technical specification.
• Architect and design teh application components.
• Developed stored procedures, functions and database triggers. Executed SSIS packages to populate data from teh various data sources.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from AML DB Source, Excel Spreadsheet to SQL Server 2008.
• Coding to implement teh specification. Unit Test teh component developed. Build deployment. Support UAT and Production deployment.
• Prepared Unit Test Cases and Design Documents.
• Performed unit testing to verify if teh requirements are met.
• Providing clarification to business users and technical support team
• Providing Technical Hand Off to support team and teh necessary documentation.
• Used Agile and Scrum development cycles.
• Fix any bugs arising out of SIT, UAT and any other test process. Schedule, Identify Project Milestones and Track Progress against these milestones.
• Ensure Adherence to established Quality Standards. Status reporting, customer interface and coordinating wif teh offshore development team.
• Customer Relationship Management Managing Customer Expectation and Ensuring Customer Satisfaction.

Confidential

Tools: Visual Studio 2010, SQL Server Management Studio 2008, Business Intelligence Development Studio, SVN, Actimize Modeler, Actimize Risk Case Manager, Blade Logic, Repliweb, Tectia.

Responsibilities

• Understand business requirements and translate them to technical specification.
• Architect and design teh application components.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from AML DB Source, Excel Spreadsheet to SQL Server 2008.
• Creating and developing database object such as tables, indexing columns and setting constraints.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Creating multiple views for SSRS report.
• Writing SQL stored procedures, user define functions, triggers and cursors.
• Extensive knowledge in performance tuning.
• Coding to implement teh specification. Unit Test teh component developed. Build deployment. Support UAT and Production deployment.
• Prepared Unit Test Cases and Design Documents.
• Performed unit testing to verify if teh requirements are met.
• Providing clarification to business users and technical support team
• Providing Technical Hand Off to support team and teh necessary documentation.
• Used Agile and Scrum development cycles.
• Fix any bugs arising out of SIT, UAT and any other test process. Schedule, Identify Project Milestones and Track Progress against these milestones.
• Ensure Adherence to established Quality Standards. Status reporting, customer interface and coordinating wif teh offshore development team.
• Customer Relationship Management Managing Customer Expectation and Ensuring Customer Satisfaction.

Confidential

Tools: Visual Studio 2010, SQL Server Management Studio 2008, Business Intelligence Development Studio, SVN, Actimize Modeler, Actimize Risk Case Manager, Blade Logic, Repliweb, Tectia.

Responsibilities

• Creating and developing database object such as tables, indexing columns and setting constraints.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Creating multiple views for SSRS report.
• Writing SQL stored procedures, user define functions, triggers and cursors.
• Extensive knowledge in performance tuning.
• Understand business requirements and translate them to technical specification.
• Architect and design teh application components.
• Prepared Unit Test Cases and Design Documents.
• Performed unit testing to verify if teh requirements are met.
• Providing clarification to business users and technical support team
• Providing Technical Hand Off to support team and teh necessary documentation.
• Used Agile and Scrum development cycles.
• Coding to implement teh specification. Unit Test teh component developed. Build deployment. Support UAT and Production deployment.
• Fix any bugs arising out of SIT, UAT and any other test process. Schedule, Identify Project Milestones and Track Progress against these milestones.
• Ensure Adherence to established Quality Standards. Status reporting, customer interface and coordinating wif teh offshore development team.
• Customer Relationship Management Managing Customer Expectation and Ensuring Customer Satisfaction.

Confidential

.Net/SQL Developer

Technologies: Asp.Net wif VB.Net as Code Behind, Microsoft Visual Studio 2008, MS-SQL Server 2008, Tortoise SVN, Windows Server 2003, HP Quality Centre

Responsibilities:

• Gather teh requirements from Client and analyzed them to match teh new version.
• Created teh SSIS packages for extracting data from OLTP to OLAP.
• Design database schema using SQL Server 2008.
• Creating and developing database object such as tables, indexing columns and setting constraints.
• Writing complex SQL queries using merge statement, multiple joins, sub queries and recursive queries.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time
• Analyzed teh bottlenecks in teh stored procedures, SQL queries and tuned them for improving teh performance of teh application, creating new stored procedures & SQL scripts as part of teh enhancements.
• Design and develop teh modules in web application using ASP.Net wif VB.Net as code behind.
• Used LINQ for querying teh collection objects.
• Used JavaScript for client side validation.
• Merge new business requirements, maintaining current business passiveness
• Performed Unit Testing
• Tracked teh Issues and maintained in HP Quality center.
• Created Main Menus, Context Menus, Toolbars, User controls and other UI elements.
• Created stored procedures and functions in SQL server.
• Performing QA Releases and providing UAT Support
• Performing Production Releases and Deployments
• Providing clarification to business users and technical support team
• Reviewing teh code.

Confidential

.Net/SQL Developer

Technologies: Asp.Net wif VB.Net as Code Behind, Microsoft Visual Studio 2008, MS-SQL Server 2008, Tortoise SVN, Windows Server 2003, HP Quality Centre

Responsibilities:

• Assess teh business requirements & transactions - To compile, evaluate, assess and build a Proof of Concept (POC), impact assessment & strategy.
• Created teh SSIS packages for extracting data from OLTP to OLAP.
• Design database schema using SQL Server 2008.
• Creating and developing database object such as tables, indexing columns and setting constraints.
• Writing complex SQL queries using merge statement, multiple joins, sub queries and recursive queries.
• Designed, developed and successfully completed and demonstrated teh proof-of-concept for which I got Best Innovation Award.
• Design and development of Web forms using ASP.Net wif C#, .Net as Code behind.
• Created Master Page and ASCX Web User Controls for reused codes.
• Used Object Oriented Programming skills in encapsulating teh business functions and data.
• Implemented Data Caching Technique.
• Implemented teh SQL Server Session state.
• Used JQuery and Json to communicate wif Business layer objects.
• Created Database objects like Stored Procedures, triggers and functions in SQL Server.
• Involved in Code Reviews
• Unit testing. Involved in Client Meetings.