Oracle Certified Professionals, Micrososft Certified Professionals
16+ years of IT experience in the Data Analysis, Design, Development, Implementation, Testing of Database, Client Server and Web applications using ETL-Data Extraction, Data Transformation, Data Loading and Data Analysis from Financial, Insurance, Manufacturing Pharmaceutical and Military verticals
* As a SQL DBA and Developer in major Health care company, Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation. Followed Scrum methodology with Code first. Developed SQL stored procedures, Involved in Fine Tuning and optimization. Designed Functions, Triggers and Packages and documented for source control. Used SSIS packages extensively. Created package Deployment project to move SSIS packages from different servers. Coordinating with developers to follow company standards. Migrating objects from dbo to other schemas. Fine tuning objects generated by Entity Models. Creating and debugging SQL scripts for data loading
* As a Database Engineer in a major Media client , involved in all aspects of database maintenance and application development. Creating Functions and triggers using T-SQL. Involved in Debugging Stored procedures code and documenting. Collaborating with users and Software developers in Canada, UK, India and Hong Kong. Implementing High availability and log shipping with SQL server 2012, Clusters with 6 nodes and Replication. Mentoring and working with offshore team- Team lead. Documented and delivered functional specification document to the project team. Assisted Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs. Created Data Flow charts using Visio. Developed SSIS
* As a database Developer/DBA in Medical billing company, worked on SSIS Packages to load data from SFTP, FTP, and Amazon S3 file uploading with encryption. Developed and deployed SSIS Packages. Migrating ETL packages from SQL server 2008/2005 to SQL server 2012. Maintaining Transaction Replications and Clustering. Troubleshooting Clustering and database issues. Used RED GATE SQL Compare and RED GATE SQL DATA Compare. Implemented Backup and restore Procedures. Maintaining SQL servers on Amazon Cloud. Involved in Database releases and deploying SQL Schema changes, Stored procedures and database objects in different servers. Data Modeling and Oracle Administration Responsibilities
* As a WEB Engineer in Financial and Health care companies, Participated in all phases including Requirement Analysis; Client Interaction; Design, Coding, Testing and Documentation. Designed and Developed ASP.NET web pages for file uploading to SFTP, FTP and directory services. Worked with MVC, AngularJS, Entity Framework,Bootstrap,HTML5.Created VB scripts to manage Active Directory. Provided Product support for Web applications and desktop applications. Design and develop WCF data services and developed WPF client applications to consume web services. Worked with Chart Director .NET Chart tool for generating Reports and graphs. Used AJAX Technology (telerik r.a.d Components) in developing Medical Transcription Application.• Developed webservices using ASP.NET, C#, SQL Server 2005 that communicates with Delphi applications. Wrote SQL stored procedures.Customization of SplendidCRM, Converting ASP site to ASP.NET website for NetroMedia using SplendidCRM (www.SplendidCRM.com).
Master of Science ( Computer Science)
New York Institute of Technology (NYIT), NY