SUMMARY:

• Microsoft Certified Professional with 11+ years of IT industry experience in Design, Development, Adminstration, Testing, Analysis and implementing application software and most importantly, optimizing software solutions catering to the business requirements using .NET technologies and Cortana Analytics Suite.
• Develop scripts & automation tools used to build, integrate and deploy software releases to multiple environments.
• Implemented Azure Automation, Log Analytics and provisioned SQL Servers, Azure SQL.
• Knowledge on Machine learning concepts.
• Have experience working with Cortana Analytics Suite - ADF, HDInsight and Storage.
• Developed custom web app to Query, Add and Update Azure Data Catalog with RESP API's.
• POC on provisioning HD Insights and
• Worked on POC's with Data Lake Analytics, Data Factory, Azure SQL Server, Azure Blob Storage, Service Bus.
• Hands-on in developing cloud based applications using Microsoft Azure - PaaS platform.
• Knowledge in configuring Azure API Management, Traffic Manager and Resource Manager
• Have knowledge on Azure Logic Apps.
• Developed U-SQL jobs to process data in pipeline.
• Good understanding on Machine learning concepts.
• Developed and Implemented RESTFul API’s.
• Developed consumer and producer classes for Kafka broker to push messages to and from Azure Data lake, Blob Storage and Azure SQL db.
• 4 years of hands on experience designing and developing Universe, Dashboards & Adhoc reports using Tableau, SAP BI and SSRS.
• Hands on experience working with .net clients from Oracle, SQL, Azure SDK and DB2.
• Have experience implementing Service Oriented Architecture (SOA) with WCF and XML Web Services using SOAP, WSDL.
• Experience with Microsoft BI- SSIS, SSRS with SSMS 2005.
• Experience in SQL Server 2000/2005/2008 (TSQL) and Oracle 9i/10g (PL/SQL) programming, Postgre SQL.
• Experience in using AJAX controls in ASP.NET Sites/applications and interacting asynchronously with ASMX Web Services.
• Involved in Database design, Development, Performance Tuning, Query optimization and Report Generation. Developed Stored Procedures, Functions, Triggers, DTS packages and Integration Services packages.
• Used N-tier architecture for presentation layer, Business and Data Access Layers and were coded using C#.Net.
• Executed projects with Waterfall methodology and Agile methodologies.
• Experience working with Onsite-Offshore model.
• Exposure to different domains like Healthcare, Manufacturing and Retail.
• Extensive Experience in design and modeling of applications with UML and Object Oriented Analysis & Design. Good experience with SDLC.

TECHNICAL SKILLS:

Operating System: Windows 8/7/XP Professional, Windows 2000/2003/2008 Server, Vista, Unix.

.Net Technologies: ASP.NET, Azure SDK, AJAX, Anthem Controls, Infragistics, WCF, LINQ, Telerik Controls.

Cloud Computing: Azure Data Lake Analytics, Azure Blob Storage, Azure SQL DB, U-SQL, Azure Data Factory, Logic Apps, Hive, Azure HD Insights.

Languages/ Script: C, C++, VB6, VB.NET, C#.NET, PHP, SQL, PLSQL, MDX, Powershell

Web Technologies: HTML, DHTML, XML, JSON, SOAP and CSS.

Databases: SQL Server, Oracle 9i/10g/11g, CUBES (SSAS).

Version Control Tools: GIT Extensions, IBM Rational Clear case, Visual Studio.Net Tools / Visual Interdev, Visual Source Safe, MKS Integrity Client.

IDE: Visual Studio 2013, Dream Viewer, Fiddler 2, SQL Management Studio, Toad, PLSQL Developer, Azure Storage Explorer.

Reporting Tools: Tableau, SAP BI 4.0, SAP IDT, SAP UDT,SAP Webi Reports, Crystal Reports, MS Reporting and SSRS

Scripting Languages: JavaScript, VBScript, Java Script, PHP, PowerShell

Domain Knowledge: Auto, Manufacturing, Retail, Health care.

PROFESSIONAL EXPERIENCE:

Confidential, TX

Automation Lead

Responsibilities:

• Developed runbooks to set up environments using ARM templates
• Implemented custom deployment framework to use the pattern across the Organization for SQL db migration.
• Developed Powershell scripts for provisioning and executing Elastic job services.
• Powershell scripts to run Elastic jobs using Shard Maps
• Implemented Split Merge services to split the database to Multi-Tenant databases in Azure.
• Implemented Elastic Job services to replace SQL Agent for Job Execution.
• Setup alerts in Log analytics to send alerts on Runbook in Automation.

Confidential

Tech Lead

Responsibilities:

• Implemented Microsoft.Owin for single sign-on and deployed web applications to Azure Web Apps.
• Developed data pipelines using Azure Data Factory.
• Developed Stream Analytics jobs to fetch messages and save in multiple target sources Azure Blob Storage, Azure SQL Server and Power BI.
• Developed Producer and Consumer for Kafka to push and consume messages to Azure Blob Storage, Azure SQL Server, Event Hub and Hana on Iaas.
• Implemented Azure Data Catalog Rest API’s and IBM IGC Data Catalog Rest API’s.
• Data blending implemented on Oracle database and Excel to generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Analyzed the source data and handled efficiently by modifying the data types.
• Designed and developed Data models & Universe using SAP BI 4.0 IDT
• Developed SAP BI 4.x Webi reports.
• Used Tableau to develop complex and interactive reports.
• Involved in Requirement Gathering, Design, Development, Testing & Production Support.
• Involved in designing the application architecture for RPC calls.
• Integrated the application with WebOrb, third party tool to expose Classes and Methods for implementation.
• Created PLSQL scripts for importing and exporting the data.
• Developed Oracle Packages, Stored procedures and Functions for the applications and developed scripts for ad-hoc reporting.
• Integrated with .net libraries with Adobe flex application using WebOrb.
• Developed reports using Microsoft Reporting.
• Exported reports as Excel and PDF format
• Developed data access layer using MS Enterprise Library and Scaffold concepts.
• Developed and tuned PLSQL scripts for reporting and in application development.

Environment: MS Visual Studio 2010, Oracle 11g, .Net Framework 4.0, MKS, GIT Extensions, Electric Commander, PL/SQL Developer, Toad for Oracle, SAP BI IDT, Tableau 9.0.

Confidential

Sr Developer

Responsibilities:

• Implemented Telerik Rad Controls in the application.
• Application was developed using C#.NET, ASP.NET 3.5.
• Developed Hierarchical Grids for displaying hierarchy data.
• Developed code to read flat file data to save in database and bind it to grid. Used this feature for uploading n number of employee details.
• Implemented Entity class model, Generics and IEnumerable Lists for building the data layer.
• Developed and implemented User controls to display the user information.
• Implemented OOPS Concepts in developing the application.
• Developed complex Oracle Packages with Stored Procedures and Functions.
• Worked on PL/SQL Scripts for integrating data from Oracle to Main Frames and vice versa.
• Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
• Developed and Tuned the SQL queries, used for importing and exporting data from the Main frames.
• Followed Agile-Scrum methodology for developing the application as per the user requirements.
• Designed and developed PDF reports for RFT and RFT Adjustment reports.

Environment: MS Visual Studio 2008, Oracle 10g/11g, .Net Framework 3.5, Visual Source

Confidential

PL/SQL Developer

Responsibilities:

• Involved in gathering and designing the requirements from clients for product design and enhancements. Designed and documented TDD-Technical Design Document. Followed UML Concepts for designing TDD.
• Followed OOPS concepts and UML for developing the application with C#, ASP.NET.
• Worked as a Technical Team Lead with team size of 8.
• Agile-Scrum methodology is implemented in designing and development of the application to fulfill the client requirements.
• Designed and developed reports using BIDS 2008, includes SSRS, SSMS and SSAS.
• Developed GUI using .net framework 3.5, C#.NET, ADO.NET . Used ADOMD.NET to connect CUBE in Analysis server.
• Created User Controls and integrated with SharePoint Portal.
• Designed, developed and executed complex MDX queries. Implemented complex MDX queries with multiple report parameters and query parameters.
• Implemented Save, View, Edit, Delete functionality for user customized reports. Functionality to add the saved reports as favorites is implemented.
• Developed SSIS packages to get data from different applications.
• Generated multiple reports using SSRS. Implemented formulae, groups, sub-report and drill down option.
• Decisive, action oriented and result oriented software professional. Demonstrated outstanding execution abilities, problem solving skills & analytical abilities alongside technical and functional expertise.
• Designed and developed add-on component LogUtilityManager to log the exceptions in to a text file. A new text files to be generated for each day.
• Developed add-on application for Report Statistics using C#.net and Reporting services database.
• Performed manual testing and data validation of the application with PIVOT Tables.

Environment: MS Visual Studio 2008, SQL 2008, SSRS, SSMS, SSAS, .Net Framework 3.5IBM Rational Clear Case 7.0, SharePoint 2008.

Confidential

Technical Team Lead

Responsibilities:

• Involved in gathering and preparing the requirements from clients for product design and enhancements.
• Communicated with client for daily updates, reviews and demos. Involved in user programs.
• Coach and help develop team members, help resolve dysfunctional behavior. Familiarize the team with the client needs, specifications, design targets, the development process and design standards support task performance. Acted as a Team Lead for team of size 6.
• Developed supporting applications using IRON SOFT tool.
• Project was developed with Agile- Scrum methodology.
• Developed application using C#, ASP.NET, ADO.NET.
• Implemented OOPS concepts and developed the application with C#, ASP.NET.
• Generated multiple reports using crystal reports & report viewer. Implemented formulae, groups, sub-report, drill down option and bar charts.
• Used Xpath, Xml Node to access files and XML Data Document to synchronize with Datasets.
• Designed Business components and Data Access Layer using C#, ASP.NET and Data Sets.
• Involved in Data base design and created data tables, relationships, stored procedures and functions.
• Developed complex stored procedures using temporary tables and loops using T-SQL.
• Implemented Skins in the application.
• Worked on exporting reports to Excel from Grid views and Ultra web grids.
• Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
• Involved in user s and implementation.
• Implemented XML file as a schema for data source to generate crystal reports.

Environment: MS Visual Studio 2008, SQL 2008, Crystal Reports, .Net Framework 3.5, Visual Source Safe 6.0.

Confidential .

Business Process Automation Team Lead

Responsibilities:

• Co-ordinate the team's day-to-day technical activities, reviews and demos.
• Involved in user programs.
• Involved in gathering and preparing the requirements from clients for product design and enhancements.
• Project was developed with Water Fall methodology
• Developed application using VB.NET, ASP.NET, ADO.NET
• Used login controls and wizards for creating role based login process.
• Multiple step transactions including user registrations and filling application forms were handled using wizard controls.
• Implemented Nested Grid views with multiple template columns for displaying hierarchal data.
• Developed an application using IRON SOFT tool.
• For easy navigation tree view, site map paths were implemented.
• Implemented Ajax for faster Browser response time.
• Implemented Themes for User Interface uniformity throughout the application.
• Involved in designing and development of Database, created data tables, relationships, stored procedures, triggers and functions using T-SQL.
• Designed and developed reports using SSRS.
• Designed and developed Crystal reports. Implemented sub-reports, groups, formulae, drill downs and bar charts.
• Designed and developed inventory reports using Crystal Reports.
• Developed and implemented User Controls for displaying user related data and summary information.
• Implemented Masked Controls for validating the data.
• Implemented codes to extract data from excel and upload in SQL Server.
• Used XML data types for multiple record transactions.
• Used Photo shop for modifying the images and creating logos.
• Developed approval process for multiple level approvals.

Environment: MS Visual Studio 2005, SQL 2005, Crystal Reports, .Net Framework 3.5, Visual Source Safe 6.0.

Confidential .

Senior Developer

Responsibilities:

• Implemented OOPS concepts with C#.NET and ASP.NET.
• Role based login implemented.
• Converted MS Access based application into .NET and SQL Server environment.
• Migrated historical data from MS Access to SQL Server.
• Generated reports using crystal reports using formulae, groups, sub-reports and drill down option.
• Designed Business components and Data Access Layer using C#, ASP.NET and Data Sets
• Integrated Stored Procedures, Functions using SQL Server2005 and T-SQL.
• Used CSS for Designing GUI Applications with the help of HTML Tags.
• Involved in Building workflow-enabled applications on Windows.
• Used ASP.NET and C# for front-end development.
• Written client side validation scripts in JavaScript language.
• Worked on CSS style sheets for layout of the site.
• Developed and used XML for storing the Dynamic table data.
• Developed various Stored Procedures using SQL for retrieving data to the web application.
• Triggers are created for storing the audit log entries.

Environment: MS Visual Studio 2005, SQL Server 2005, Crystal Reports, .Net Framework 3.5, Visual Source Safe 6.0.

Confidential

Developer

Responsibilities:

• Implemented nested grids for viewing the data in hierarchy. Created dynamic hierarchy data grids for displaying the user “Assigned Tasks”, Schedules, Appointments, “Pending Tasks” and Approvals.
• Over 30 reports were created using crystal reports including bills, daily reports, consumption report, and monthly reports. Drill down reports and sub reports for hierarchical data were developed.
• Implemented service oriented architecture (SOA) to achieve loose coupling between modules.
• Project was designed and developed with Waterfall methodology.
• Implemented OOPS concepts using VB.NET and ASP.NET.
• Designed and developed MIS reports includes Day wise service consuming, Doctor wise Service reports, Daily collections & Day end reports, Cross tab reports.
• Generated XML using XML namespace for implementing Web Services and XML data types were used for retrieving data and inserting multiple values into database.
• Created complex stored procedures using temporary tables, global temporary tables, cursors, procedures and functions with PL/ SQL.

Environment: Visual Studio 2003/2005, Oracle-10G, SQL Server 2005, Visual Source Safe 6.0, Crystal Reports, Web Services