SUMMARY

• 12+ years of professional experience in SDLC model like software analysis, design, development, testing & implementation for the variety of domains like Government, BFS and new technology
• Extensive experience in Bussiness Intelligent suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes
• Having good experience in application development using .net framework 2.0, 3.5, ASP.NET, Win forms, C#, VB.net and Web Services.
• Having work experience in MSI development and deployment using WIX and Octopus scripting.
• Good experience in Extraction, Transformation and Loading data from MS SQL Server, Oracle, MS Access, Excel and flat files using MS SSIS
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. experience in Web development using JavaScript, VB script, HTML, XML, XSL, XSLT,CSS, DHTML, XHTML.
• Hands on experience in performance tuning of ETL packages and query tuning.
• Export in package deployment, create Job and schedule the job.
• Good experience in writing Complex queries, stored procedures, User defined functions, Indexed views, CTE’s (common table expressions) and triggers using SQL Programming.
• Experience in Performance Tuning and Query Optimization
• Experience in query optimization (SQL tuning) using SQLProfiler, Database Tuning Advisor (DTA) and Execution Plan.
• Familiarity with DBA Activities like Backups, Restores, Security, Usermanagement and Performance Tuning.
• Implemented Report server configuration, Deployed reports, Created data driven subscriptions in Development, Test and production environments.
• Having good experience in Agile, Extreme programming and Sprint planning.
• Self-starter, with strong analytical and troubleshooting skills, ability to work independently or as part of a team.
• Experience with logical and physical data modeling and database design using Erwin.
• Experience with both Agile and Waterfall methodologies, Certified in Project Management
• Having good experience in version control tool like TFS, PVCs and VSS

PROFESSIONAL EXPERIENCE

Confidential, NJ

Application Developer

Environment: SQL server 2008, SSIS, SSRS,Planview, InsperityOrg,Apptio.

Responsibilities:

• Troubleshoot the ETL package and make it up and run for longrunning Job
• Develope and maintance the ETL load data from multiple system load into PDW and server data to sub system for reporting
• Fixing production issue for web application using ASP.net, c#.
• Develop adhoc SSRS report from planview database
• Create ETL data to load data from PDW system to Planview database
• Create and maintain ETL to load data to Apptio reporting
• Reconsile/Validate the data load from PWD and Apptio data
• Create Montly org-chart using Insperit-org app.

Confidential, Orlando, FL

Sql Server Developer

Environment: SSIS, SSRS, C#, SQL server2012, Oracle Pl/SQL.

Responsibilities:

• Generating of Project Weekly Status Reports and submit Project Monthly metrics to Stakeholders.
• Reviewing UAT, SIT Test Plan, Risk, Mitigation documents and oversee the Development, UAT and SIT of the projects within Time.
• Completely automated SSIS and SSRS tasks using SQL Agent jobs.
• Used incremental update using CDC Control Transformations in SSIS updated the tables.
• Used Partition Switch to achieve no downtime for loading data mart tables.
• Used Data Driven subscription to achieve customized report output.
• Created analytical error handling Reports and identified data issues using those reports.
• Restored Development and QA databases from production environment using SQL Agent job.
• Analysis data for business request and provide adhoc report using excel.
• Create versioning the SSIS package in TFS for deployment.
• Involved in design & data mapping for Oracle table to SQL server.
• Analyzing and creating mapping from the multiple source system.
• Created dashboard report using excel power pivot.
• Documented the arte facts in the database objects such as Stored Procedures, User Defined Functions, Views, Synonyms and tables used in all SSIS packages
• Created Backup and restore database from Prod to QA.
• Design and develop SSRS reports and create data driven subscription.

Confidential, Fishers, IN

System Analyst

Environment: SSIS, SSRS, C#, ASP.Net, SQL server.

Responsibilities:

• Converting business requirement into technical document and test case.
• Designed, Developed and Implemented SSIS package.
• Design error handler and transaction control for SSIS Packages.
• Create Mapping document for mainframe column vs cohort column.
• Create Script Task using C# to perform business validations.
• Design Rule engine in stage table and transaction table which validate data based on Source data.
• Analysis the current system and developed new common validation package.
• Create Complex SQL Query, View and stored procedure in SQL server server.
• Analyzing and creating mapping from source and target system.
• Designing and Deployment of Reports for the GRC application in sharepoint.
• Develop and code fix VB.net window application.
• Developed Asp.net, C# coding using MVC framework.
• Create and coordinate the migration request process for QA and prod environments.

Confidential, Irving TX

Report Developer

Environment: Oracle Pl/SQL, Excel, Toad.

Responsibilities:

• Daily report generation using Pl-SQL and validating the data with excel formulas
• Adhoc analysis and create Excel or Pivot report for the business query.
• Design and develop the new report for business needs.
• Performance tuning the long running report PL-SQL.
• Bug fix the crystal report running in Unix environment.

Confidential, Redmond WA

Application Developer

Environment: Excel, SSRS, SSIS, ASP.net, WIX, C#, VB.NET, SQL server, Reporting Services 2005.

Responsibilities:

• Analysis, Design, technical design document, daily scrum meeting.
• Design the SSIS package to load data for the Datamart
• Developed Action script using C# and patch installation for services.
• Deploying daily build on the multiple Virtual Machines and creating Snapshot.
• Created Virtual machine and Snapshot using Hyper-V manager for Testing and deployment environment

Confidential

Environment: Silverlight, XML, XSL,XSLT, Xpath, XHTML, JavaScript, C#, DHTML, Source depot

Responsibilities:

• Lead daily scrum meeting and update the delivery schedule.
• Created complex XPath query inside XSL template for Converting XML content to XHTML to support for multiple browser.
• Ensured quality by conducting code reviews, tracking issues to closure and testing the application.
• Created Localization XML file for error and warning message for all languages.
• Worked on various product support and bug shooting tasks.

Confidential, NJ

Sql/ .Net Developer

Environment: C#, ASP.net, XML, XSL, JavaScript, CSS, DHTML, VB COM, SQL Server 2000, VSS.

Responsibilities:

• Reviewing and analysis the functional and technical document for client.
• Create singleton class object for retrieving the connection object.
• Developed complex dynamic SP and function for search screen.
• Design C# and ASP.NET classes to implement Front controller Design pattern as part of Proof of concept to provide for feasibility.
• Wrote HTTP Handler/Module class for exception handling.
• Used XML and C# classes to implement audit feature in the application.
• Wrote Excel macro for audit Summary report.

Confidential

Sql Developer/ .Net Developer

Environment: ASP.net, VB.net, XML, XSL, SQL Server 2000, Java Script, CSS, PVCS.

Responsibilities:

• Bug fix and code reviews for SQL Server stored procedures.
• Implemented coding using VB.Net for all forms.
• Implemented front end validations using JavaScript

Confidential

Programmer

Environment: C#, ASP, XML, VB COM, SQL Server 2000, VSS, Source Offsite.

Responsibilities:

• Design Entity Relational model for Document library using ER-Diagram.
• Wrote technical design document for Document library, Context switching.
• Wrote Sql Stored Proc, trigger for Document Library module.
• Performance monitoring using sql profiler, creating index for slow running query & query tuning the complex joins inside the SP.
• Wrote XSL/XSLT file for Document Library.
• Wrote C# Class for converting HL7 Input to XML.
• Wrote multiple stored procedures and triggers document library.
• Played Key role during Alpha testing & beta testing phase.

Confidential

Environment: VB.Net,ADO.NET ASP, XML, COM, SQL Server 2000, Visual Source Safe, Source Offsite.

Responsibilities:

• Wrote an ActiveX control in Visual Basic by applying a wrapper for Context switching from i.PM
• Senior Developer on a Health care project. Re-coding functionality from a thick client application to a client application. Working with 4 other developers during design, build, test phases and also mentor junior developers. Write custom code modules using Javascript, ASP, XML, VB.NET, HTML that enhance the fcClient web based application.
• Design complex business VB Component for Theater/Bed Management module.
• Wrote complex Sql Stored Proc, trigger for bed management.
• Wrote complex SP for crystal reports.
• Design unit script to test client side validation.
• Designed windows forms in C#.Net and developed the User Interface design
• Involved in multiplatform integration coding.
• Implemented front end validations using JavaScript.
• Involved in usability design.

Confidential

Environment: VB.Net, ASP, XML, COM, SQ Server 2000, Visual Source Safe, SourceOffsite.

Responsibilities:

• Design entity relational model for import/Export using ER-Diagram.
• Played an extensive role in the consolidating, Normalizing and designing views, triggers and stored procedure.
• Developed excel macro to retry the data from SQL server for import/export summary report.
• Performed peer reviews of deliverables to ensure quality and meet the functional requirements
• Developed the automated tests to verify the business functionality
• Web programming in ASP, Javascript, HTML, DHTML. SQL Server 7.0 backend.
• Development of client websites, enabling online account access to perform financial transactions.
• Design and development of corporate Intranet and Internet sites. Internal Applications using VB 6.
• Developed queries and stored procedures for patient database to retrieve patient data.

Confidential

Environment: VB, ASP, XML, JavaScript, CSS, COM, MTS, SQL Server, Oracle, Visual Source Safe.

Responsibilities:

• Responsible for developing UI Design.
• Wrote 3 Complex Module like CALC, ESPH, ESPP.
• Wrote complex store procedure, views for Demo Screen.
• Wrote Data Access layer using VB com
• Web programming in ASP, VBScript, Javascript, HTML, DHTML. SQL Server backend.
• Developed Oracle Form & Stored procedure using Oracle8.
• Developed Oracle Reports in Oracle8i
• Development of client websites, enabling online account access to perform financial transactions.
• Design and development of corporate Intranet and Internet sites. Internal Applications using VB 6.