PROFESSIONAL SUMMARY:

• Around 5 years of experience in software design and development
• Expertise in SQL Server 2005/2008/2012 Reporting Services (SSRS), SQL Server 2005/2008/2012 Integration Services (SSIS) and in SQL Server 2005/2008/2012 in Business Intelligence (BI).
• Hands on experience in Oracle and Netezza.
• Experience in developing n - tier Architecture Distributed Applications.
• Experience in using Visual Studio 2003/2005/2008/2010/2012 Technologies such as SSRS, SSIS, SSAS, C#.
• Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experience in performance improvement of SQL-objects.
• Experience of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2012/2014.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), SQL Server Integration Services (SSIS) (2005/2008 R2/2012/2014).
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, Loading data from Oracle, Netezza, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Good understanding of Confidential industry.
• Experience in developing applications using Visual basic for application (VBA) in MS-Excel.
• Experienced in Standards and procedures development, good command in working with Tracking Tools such as HP ALM, QC.
• Have used industry’s best practices extensively for Creating Design Document, giving Estimations, Preparing of Status reports, creating Prototype of application.
• Capable of delivering highly challenging tasks in the stipulated time frame.
• Highly flexible to work across any module in the application.
• Have done Root Cause Analysis on issues of unstable features of the products, performed major bug-fixes to make the project stable and reliable.
• Have done Verification of change requests and defects, documenting, tracking and communicating releases, new Development and unresolved problems, explaining system bugs to testers.

TECHNICAL SKILLS:

Programming Languages: VBA, C#

Tools: SQL Server data Tools for Visual Studio 2010/2013/2015 , Oracle- SQL Developer, SQL Server Management Studio, Oracle-SQL developer, SSIS, MS-Excel, SSRS, MS access, .Net

Web servers: Internet Information Server (IIS) 5.1, 6.0 and 7.0

Testing: Unit Testing

Source Control Tools: TFS, SVN

Operating systems: Windows OS 2007, 2003, XP

PROFESSIONAL EXPERIENCE:

Confidential, Monterey Park, CA

Team Lead\SQL\BI developer

Responsibilities:

• Involved in the complete life cycle (SDLC) of the project, including (design, development, and implementation, testing, support, and production maintenance).
• Create\Review impact analysis, tech docs, design documents, with Team.
• Review impact analysis, tech docs, design documents, with Client.
• Review and analyze access based applications, SSIS packages, Portals, reports etc.
• Design of .Net utility to remediate outbound files from Care1st so as to minimize the impact on existing code.
• Design\creation of master tables, log tables and scheduling tables to support the Utility for remediation of Files
• Understanding the existing system and mapping it to the future sources and applications.
• Code enhancement and development programs and/or required fixes to production problems using functional and technical programming standards.
• Understanding data models and writing stored procedures, triggers, views, PL\SQL packages.
• Developing SSIS packages for comparison of files, data transformations with several Control Flow Tasks, Data Flow Tasks and Transformations (Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, Sequence Container, Execute SQL Task, Send Mail Task, and Precedence Constraint) to achieve business requirements.
• Data migration to current servers with the upgraded transformations coming from third party and modifying older objects in accord with the third party DB objects.
• Creating Databases, developing complex SQL queries, Stored Procedures, Views, and UDFs.
• Analyzing and converting access based applications to SSIS packages.
• Responsible for investigating the minor issues, defects, system outages, determining problem root cause, formulating corrective action recommendations & implementing them in ongoing application.
• Utilize configuration management tools, design tools, debugging tools, and any other environment
• Specific tools necessary to create, test, and implement an application
• Produce Deployment run Books and other Upgrade process and login control runbooks.
• Involved in daily status meetings with client and offshore meetings.
• Provide maintenance, including production support, enhancement and development work
• Interact with the Enterprise Architecture and Enterprise Platform teams to ensure that solutions are built in adherence with the defined enterprise standards

Environment: Microsoft SQL server-2012,Oracle 11, SSIS (SSDT 2008), SSRS, VDI,UNIX,MS- Excel, MS- Access, Visual Basics for application, Visual studio 2013, SVN, TFS.

Confidential, Washington, DC

SQL\BI developer

Responsibilities:

• Involved in the complete life cycle (SDLC) of the project, including (design, development, and implementation, testing, support, and production maintenance).
• Perform analysis, design, coding, component and assembly testing of all application code owned by the Application Team
• Work with the Functional Architect and Technical Architecture Specialist on an as-needed basis to ensure that design and code meets customer requirements
• Code enhancement and development programs and/or required fixes to production problems using functional and technical programming standards.
• Understanding data models and writing stored procedures, triggers, views.
• Performance tuning of stored procedures\Views according to the query plans, and DB usage of the objects
• Designing and developing multiple reports such as Ad-hoc, Drill Down, Drill Through, Sub-Reports, Linked Reports, including stylish Graphs and Charts in SSRS
• Developing SSIS packages for comparison of files, data transformations with several Control Flow Tasks, Data Flow Tasks and Transformations (Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, Sequence Container, Execute SQL Task, Send Mail Task, and Precedence Constraint) to achieve business requirements.
• Data migration to current servers with the upgraded transformations coming from third party and modifying older objects in accord with the third party DB objects.
• Creating Databases, developing complex SQL queries, Stored Procedures, Views, and UDFs.
• Application support for Investran client applications such as Investran accounting, Report Wizard, CRM, Import Export console
• Responsible for investigating the minor issues, defects, system outages, determining problem root cause, formulating corrective action recommendations & implementing them in ongoing application.
• Creating wrapper batch Scripts for DB objects.
• Utilize configuration management tools, design tools, debugging tools, and any other environment
• Specific tools necessary to create, test, and implement an application
• Produce Deployment run Books and other Upgrade process and login control runbooks.
• Involved in daily status meetings with client and offshore meetings.
• Provide maintenance, including production support, enhancement and development work
• Interact with the Enterprise Architecture and Enterprise Platform teams to ensure that solutions are built in adherence with the defined enterprise standards

Environment: Microsoft SQL server-2012, SSIS (SSDT 2013), SSRS(SSDT 2015), VDI,UNIX,MS- Excel, Visual Basics for application, Visual studio 2013, TFS, IIS.

Confidential

SQL\Web developer

Responsibilities:

• Define site objectives by analyzing user requirements; envisioning system features and functionality
• Design and develop user interfaces to internet/intranet applications by setting expectations and features priorities throughout development life cycle; determining design methodologies and tool sets; completing programming using languages and software products; designing and conducting tests
• Develop n-tier web, Windows and mobile applications
• Develop, maintain and enhance systems based on business requirements using approved technologies and coding standards
• Recommend system solutions by comparing advantages and disadvantages of custom development and purchase alternatives
• Integrate applications by designing database architecture and server scripting; studying and establishing connectivity with network systems, search engines, and information servers
• Complete applications development by coordinating requirements, schedules, and activities; contributing to team meetings; troubleshooting development and production problems across multiple environments and operating platforms
• Communicate with business analysts to gather accurate specifications for new enhancements and applications
• Monitor and ensure optimal performance for e-commerce websites, if needed
• Stay current on best practices in IT technology, IT processes and application development
• Work with team members on multi-person projects. Conduct code reviews and share knowledge
• Ensure that resulting systems are scalable, responsive, available, secure, maintainable, and easy to administer
• Ensure a smooth roll-out of any new systems

Environment: C#, VB.NET, ASP.net, MVC, Web Services, HTML, CSS, HTML, CSS, Java script, Ajax, jQuery, SQL Server, Oracle, Microsoft Visio,Oracle-SQL Developer.

Confidential

SQL\Web developer

Responsibilities:

• Involved in the complete life cycle (SDLC) of the project, including (design, development, and implementation, testing, support, and production maintenance).
• Developing short duration requests, CR changes, addition of modules to the existing web application, version changes for a web application.
• Designed and developed web user interface using ASP.NET, ASP.NET MVC, C#, HTML, JavaScript.
• Developed screens using ASP.NET server controls; use form field validations server side validations using ASP.NET validation controls.
• Designed and developed the WebForms extensively using ASP.NET
• Used basic Script Task for renaming the file names, storing Row Count Values into User Variables.
• Designed SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from and to various RDBMS and Non-RDBMS sources and destinations.
• Involved in oracle to netezza data copy for monthly feeds using Unix box.
• Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, and Precedence Constraint) to achieve business requirements.
• Scheduled jobs in Microsoft SQL server for packages and monthly runs.
• Developed SSIS components using C#, FTP\SFTP using SSIS and C#.
• Designed and developed multiple reports such as Ad-hoc, Drill Down, Drill Through, Sub-Reports, Linked Reports, including stylish Graphs and Charts.
• Developed complex SQL queries, Stored Procedures, Views, Functions and Triggers for getting the transactions that occur on monthly basis.
• Developed packages for data transformations and ETL using tools like Microsoft integration services (SSIS).
• Developed a major project using SSIS which contained more than 20 SSIS packages in a single project.
• Used different techniques of performance tuning in SSIS as well as error handling.
• Scheduled jobs in Microsoft SQL server for packages and monthly runs.
• File modifications, calculations and formatting using Visual basic for applications (VBA).
• Developed complex SQL queries, Stored Procedures, Views, Functions and Triggers for getting the transactions that occur on monthly basis.
• Involved in deployment of application on IIS sever, building unit test cases and unit testing, integration testing
• Reviewing the changes and checking-in code in tortoise SVN.
• Coordinating with QA team and bug fixing.
• Involved in defect management process changes using QC.
• Managed builds and wrote Ant build scripts for Java based applications, created scripts to automate the build process for ODM support.
• Actively participated in s for business continuity plan, Information security.

Environment: ASP .NET 4.0, C#, HTML, JQuery, CSS, JavaScript, ADO.net, web services, Microsoft SQL server 2008\2012, Visual studio 2010, tortoise SVN, TFS, IBM Netezza, Oracle 10g, UNIX, SSIS, SSRS, Visual basic for applications(VBA), MS-Excel.

Confidential

Web Developer

Responsibilities:

• Involved in all the phases of the Software Development Life Cycle (SDLC).
• Involved in adding new module to the project - Adding authentication portal for third party users and developing 4 step authentication portal using ASP.net.
• Performed functional requirement analysis and was involved in system design based on n-tier architecture.
• Involved in the development of Business Logic Layer and Data Access Layer in C#.
• Created classes and modules in C# using Visual Studio.
• Created WCF web services for implementing business logic.
• Developed the Front End using ASP.NET and Code behind using C#, .NET.
• Used Dataset, Data Reader and Data Adapter to develop a Data Access Layer using ADO.NET.
• Involved in Database design, Views and Stored Procedures in SQL Server.
• Created .NET Crystal Reports for statistical analysis of usage of the system, which can be accessed as web report as well as in PDF format using acrobat reader.
• Used Custom Validations controls with JavaScript for client side validations.
• Involved in writing SQL queries, stored procedures and triggers for the back end of web application.
• Involved in developing protection layers for the web application.
• Involved in deployment of application on IIS sever.
• Involved in building unit test cases and unit testing.
• Involved in integration testing
• Reviewing the changes and checking-in code in TFS.
• Coordinating with QA team and bug fixing.
• Involved in promoting and deploying code on UAT and other environment.
• Preparing SRS, use case and other documents.
• Track project milestones and deliverables while identifying and resolving issues and conflict within project.
• Query Optimization in SQL Server using Execution Plan.

Environment: ASP .NET 4.0, C#, HTML, SQL Server 2008, JQuery, CSS, JavaScript, Visual studio 2010, TFS, T-SQL, Crystal Reports, IIS 6.0.