SUMMARY:

• 13 years of professional IT experience in analysis, design, development and testing of Client/Server, Webform, Single Page Applications with Object Oriented Designs, SOA, SaaS and Multi - tenant architecture
• 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005,2008, 2012 & 2014 in Development, Test, and Production Environments with Confidential business domains like healthcare, financial, pharmaceutical and manufacturing.
• Hands on experience in developing web applications in C# .NET 3.0, 3.5, 4.0, ASP .NET, MVC .NET ADO.NET, ADO.Net Entity Framework, LINQ, WCF using in Microsoft Visual Studio .NET IDE
• Exposure to SCRUM and Agile based development
• Good leadership experience in both onshore and offshore
• Expertise in writing, testing and optimizing T-SQL Queries, Dynamic-queries, subqueries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.
• Hands on experience in performance optimization techniques by analyzing Query Execution Plans
• Experience in using recursive CTEs, CTE, temporary tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in ETL processes involving migrations and coordinated processes between multiple databases. Hands on data synchronization exposure using third party tools like RedGate synch.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft C#.NET framework for SSIS packages.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Exposure in analyzing, designing, developing, installing, configuring, and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services.
• Experience in maintaining one to many and many to one relationships while moving data between two databases.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies

TECHNICAL SKILLS:

RDBMS: SQL Server 2014/2012/2008 R2/2005, SQL, PL/SQL, MS Access, MySQL

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Confidential Studio, SQL Server 2005, Query Editor, Reporting Server, SQL Server Agent, MySQL Workbench

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

Reporting tools: Izenda BI tool, SSRS, Qlikview, Crystal Reports

Data Modeling: MS Visio 5.0

BI Tools: MS SQL Business Intelligence, Business Objects

Programming Language: C#.NET with ASP.NET, MVC.NET, VB.NET, Classic ASP, VB6

Microsoft .NET: .Net Framework 4.0/3.5/ 3.0/2.0/1. x, Web Forms, Win Forms, ASP.Net, MVC,ADO.Net, 4.0/3.5/3.0/2.0, Web Services, WCF Services, Web API LINQ, Entity Framework

Web Development: HTML, CSS, XML, XSLT, SOAP, Javascript, JQuery, Ajax, Angular JS

Third party tools /libraries/APIs: Telerik Rad controls, Fusioncharts, redgate data synchronization APIs and database monitoring tools, OpenXML components, Drawloop APIs, Amazon AWS SES services, Salesforce SOAP API

Web Development Tools: Visual studio 2013/2012/2010

Web Servers: IIS 7.5/7.0/6.0

Version control: TFS, VSS, SVN, CVS, GIT

Operating System: Windows 2010/2012 server, Win 7

PROFESSIONAL EXPERIENCE:

Confidential,Mountain view CA

MySQL database developer

• Database development in MySQL using Workbench 6.2 client
• Develop Data layer for the application
• Write data load scripts to pull the data from multiple data sources like SQL Server database, spreadsheets uploaded on a SFTP etc.
• Develop stored procedure to support database operations of application and generate Confidential complex reports
• Write data validation scripts for data integrity and quality check
• Code reviews

Environment: MySQL, SQL Server, Python, Objective C, Mac OSx

Confidential, NYC

SQL database developer with web dev

• Designed database architecture to enable data fetching from multiple data source connections in a multi-tenant environment
• Worked as a sole developer for the customization of MVC.NET Razor based application
• Created Data layer to be used in web forms and web components in ASP.NET, C#.NET for the integration
• Involved in R&D and POC creation for the feasibility check of the BI tools
• Created feasibility analysis reports matching them with the product requirements
• Developed Confidential complex stored procedures, functions to fetch data from different source Confidential
• Partially used Angular JS framework for code behind / server side code
• Responsible for code review and design documents
• Client interaction that included verbal and written communication, status updates and progress reporting

Environment: MS SQL Server 2012, SSIS, C#.NET, ASP.NET Web forms, MVC.NET

Confidential,Tampa, FL

SQL database developer

• Involved in presales activities which includes effort estimation, creating WBS, project plan and BRS document
• Analyzed existing payroll system, assisted the data architect with datamart schema design in Star flex schema
• Developed Confidential complex stored procedures, functions to fetch data from different source Confidential
• Developed SSIS packages to load data from different sources to data warehouse database on an incremental basis
• Designed packages using Control Flow Tasks like foreach loop container, sequential container, execute SQL task and data flow task and transformations like data conversion, derived columns, lookup, conditional split, aggregate, union all, merge join and multi cast transformations
• Created event handlers for the packages using event handler for error handling based on client requirement
• Maintained logging information in SQL table for tracking errors and recording package execution status
• Worked on Qlikview to analyze the payroll datamart
• Assisted team to work on SSIS & SSRS
• Responsible for code review and design documents
• Client interaction that includes verbal and written communication
• Providing day to day support and maintenance for the datamart application

Environment: SQL Server 2012, SSIS, SSRS

Confidential, Redmond, WA

Data Architect/Tech lead

• Helped with pre-sales by analyzing RFP, understanding the proposed system, providing effort estimations and providing technical write up for the sales proposals
• Helped in creating functional requirement specifications document by detailing down the system level requirements, creating wireframes and providing functional insights to the team
• Designed database to support high data volume and with high system availability
• Created data migration strategies to enable the seamless system upgrade
• Developed Data migration scripts considering the high volume data movement from the legacy system to the new system
• Designed multi-tiered system architecture and created detailed design specifications document
• Implemented Indexing and Security Confidential
• Used skin and themes for the design of web pages
• Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using connected architecture which requires the strong OOPS concepts
• Used WCF and .NET web services to communicate between DAL and other business components.
• Used .NET localization to enable multi-lingual support
• Used APIs for sending SMS through application, Geo tracking, send bulk emails etc.
• Worked on integration with Facebook, LinkedIn, Gmail to retrieve contacts info, friends list.
• Involved in writing complex queries using T-SQL programming. Created stored procedures, user defined functions and views in SQL server.
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation
• Usage of EDMX, LINQ to SQL for invoking database objects like stored procedures, functions.
• Implemented code behind in C#.NET
• Used caching, CSS compression and other best practices to improve the page load time of the application
• Created deployment packages and hosted application on IIS 7.5
• Created SOPs for the release and deployment procedures
• Responsible for day to maintenance and support of the application
• Involved in code reviews and code refactoring

Environment: SQL Server 2012, C# .NET 4.0, ASP.Net, WCF Web service, WPF win forms, Windows services, Telerik controls, XML, XSL, ADO.NET, Javascript, JQuery

Confidential, NYC

.NET web and database developer

• Involved in presales activities includes effort estimation, creating WBS, project schedule and plan
• Created multi-tiered architecture in .NET 4.0 and helped technical writer with creating detailed designed document
• Defined database schema and designed data flow architecture
• Worked with database developer in creating data migration from the Oracle based legacy system
• Define scope of requirements & participate in requirement specification reviews
• Developed screens using ASP.Net server controls & did form field validations server side validations using ASP.Net validation controls
• Designed & developed web user interface using ASP.NET, C#, HTML, JavaScript, server controls such as Data Grid, Data List, Validation controls
• Client side validations are done using JavaScript
• Implemented application logic under the Microsoft .NET framework using C#, ASP.NET to use .NET features powered with CLR
• Worked on .Net 4.0 framework and used SQL Server 2008 database as backend
• Created large number of XML documents to represent the Charts data
• Responsible for writing Stored Procedures to perform database activities in the SQL Server
• Integrated PayPal payment gateway
• Deployed application on IIS 7.0, was responsible for application and IIS level configurations
• Involved in day to day client communication and status reviews

Environment: C# .Net 4.0, ASP.Net, SQL Server 2008, Adobe Flash Action Scripting, XML, XSLT, CSS, ADO.NET, web service, Javascript, JQuery

Confidential, Boston, MA

Technical Lead/senior .NET Web and DB developer, support engineer

• Designed SOA based system architecture, with the ability to serve multiple clients from the same application
• Designed database schema with multi- tenant architecture
• Created data archiving application to limit the database size on the servers placed at factory floor
• Developed data synchronization console app for daily synchronization between cloud server and onsite servers
• Helped DBA to define the Log Shipping based failover technique in SQL Server
• Defined policies and procedures for interfacing with third party printers like HAPA, PTS installed at factory floor.
• Used entity data model XMLs to create the Entity layer
• Developed WCF web services as a part of business logic layered and exposed web methods to be accessible for the UI layer
• Webform and module development using C#.NET 3.5 and SQL Server 2008
• Used XSLT to parse the HTML for generating the web page controls on the fly
• Developed user controls for code reusability
• Developed console application using Red Gate API for synchronizing the data between multiple servers placed at different geographical locations.
• Wrote algorithms to access verification and validation information form Vision cameras
• Supported Confidential tests and validations e.g. FAT, IOQ, SAT conducted at the client end
• Change control Confidential and documentation for the incremental builds
• Defining product road map for forth coming release, planning product version

Environment: C# .Net 3.5, ASP.Net, SQL Server 2008, WCF, MS Reporting, Red Gate tools

Confidential, FL

Web Developer

• Supported the product conversion from .NET version 1.1 to 2.0
• Helped the system architect for the SaaS based multi-tenant architecture design
• Converted product from a customized application to a SaaS based portal
• Implemented the architecture to connect to Catalog Servers and place order information to the legacy platforms
• Involved in data tier design and development
• Developed UI Confidential module to provide ability to change the UI of application with style sheets using Themes and Skins of .NET 2.0 on the fly
• Implement master page and template page based UI architecture leveraging the newly introduced feature in .NET 2.0.
• Designed the database tables and created SQL Server stored procedure to interact with database
• Integrated many third-party gateways and web services including shipment providers, catalog providers, order placement services & payment gateways and designed the model to provide ability to add more as plug-in in C#
• Worked as a deployment engineer for product release and version controlling across multiple servers and client installations

Environment: Microsoft C#& ASP.NET 2.0 with ADO.Net using SQL Server 2000 as backend

Confidential

Software developer - Desktop

• Designed architecture for the desktop application
• Development in Visual Basic 6 and SQL Server 2000 using PL/SQL procedures and functions
• Used client server technology to support multiple client installations within the local area network
• Designed database using SQL Server 2000
• Developed major modules, COM components of the application
• Reports development using Crystal Reports version 7.0
• Database server configuration and client installation on multiple Confidential

Environment: MS VB 6.0, SQL Server 2000, Crystal Reports 7.0

Confidential

Software developer - Desktop

• Development in Visual Basic 6 and using PL/SQL procedures and functions
• Used client server architecture to support multiple client installations within the local area network
• Designed database using SQL Server 2000
• Developed major modules and COM components of the application using VB 6.0 and SQL Server 2000
• Reports development using Crystal Reports version 5.0
• Database server configuration and client installation on multiple Confidential
• Worked as a support engineer for providing onsite support

Environment: MS VB 6.0, SQL Server 2000, Crystal Reports 5.0