Data AnalyticsBusiness AnalysisSQL DevelopmentIT Software Asset Management (SAM)

Completely involved in Database Development and design for Insurance domain project/product.Created SQL code to generate SQL queries for stored procedures.Azure SQL database development

👉🏾 Worked with First America India, Hyderabad 👉🏾 Worked on Calico - an application used for title insurance to manage OCR scanned images from county offices in the USA from the database side. 👉🏾 Provided production support to fix real-time data related issues.👉🏾 Reduced the turnaround time to fix production issues within 15 minutes.

👉🏾 Worked on building a data warehouse system by consuming transactional data from databases containing large volumes of realtime OLTP data.👉🏾 Design ETL (Dimensional Model) for data loads using Redshit database running on AWS.👉🏾 Create dashboards and data visualization screens for senior management, including CEO and Board of Directors.

👉🏾 Worked on EHS related application that involved database code refactoring and redesign of the database.👉🏾 Fine tune database code for best performance by implementing SQL best practices.

👉🏾 Worked on Bing search engine as Program Manager at Microsoft (India) in the following domains:Finance, Events, Attractions and Weather👉🏾 Created data intensive reports for the senior management on periodic basis.

Major clients companies include:👉🏾 Microsoft, Seattle, WAWorked with BI center of Excellence on a very large Data Warehouse project with database size upto half a Terra byte.Technology: BI, EDW, MDM, Datamarts, Databases, METaL👉🏾 Intel Corporation, Beaverton, OregonTechnology: SQL Server, Databases👉🏾 Towers Perrin, Philadelphia, PATechnology: Web, Dot Net👉🏾 Georgia Pacific, Atlanta, GATechnology: Database, Datamarts, DW

Worked on Data Warehouse application.Client companie(s): Citigroup, NYC, NY👉🏾BI Reporting system - an Enterprise DW platform to provide web portal interface for different financial products for Citigroup, running on multiple SQL servers.👉🏾 Manage multiple vendors companies and off- shore teams to integrate multiple applications into main stream Data Warehouse/Data-mart system.👉🏾 People and Vendor Management

Clients companies:👉🏾 Avaya Communications Inc., Baskingridge, NJ, Market Research department - web portal integration👉🏾 King Financial Services Inc., Old Bridge, NJ👉🏾 Designed and developed data intensive web portal for handling stock market back office clearing process.

Worked on Web technologies based, Web based applications, database applications.Client companies: 👉🏾 Prudential Investments, NJ👉🏾 Prudential Insurance, NJ

👉🏾 Designed and developed software development applications for client/server, Web portal and database for client companies:👉🏾 Prudential Asset Management Company, Scranton, PA👉🏾 Merrill Lynch, NJ

👉🏾 Organized corporate training sessions in the area of client/server technologies using RDBMS products like Sybase, Oracle, Visual Basic and Power Builder.👉🏾 Involved in assisting design and development of software development projects.👉🏾 Worked on Unix operating system and Shell Scripting to perform system administration tasks.

Head of IT operations from infrastructure development and technology management.👉🏾 IT operations for Account and Finance, Human Resources, Materials Management, Marketing and Production departments to perform the following 👉🏾 Accounting system maintenance and Finance Control👉🏾 Voucher and Invoice management👉🏾 Pay roll management 👉🏾 Materials managements and Bill of Materials👉🏾 Work Order System with MRP👉🏾 Market campaign and market Schedule… Show more Head of IT operations from infrastructure development and technology management.👉🏾 IT operations for Account and Finance, Human Resources, Materials Management, Marketing and Production departments to perform the following 👉🏾 Accounting system maintenance and Finance Control👉🏾 Voucher and Invoice management👉🏾 Pay roll management 👉🏾 Materials managements and Bill of Materials👉🏾 Work Order System with MRP👉🏾 Market campaign and market Schedule releases👉🏾 Re-engineered shock absorber and struts testing machine using desktop computer integration. Show less

Projects Worked:1) Ergonomics and Work Study laboratory for the Production Engineering department.2) Setting up CAD/CAM laboratory for the Production Engineering department.3) Robotics System implementation for Nuclear Fuel Complex and ECIL. Design and develop software algorithms to control Robotic controlled machine to sort and stack radioactive pallets for hazardous work environment.Taught programming language and CAD/CAM courses to undergraduate and post graduate… Show more Projects Worked:1) Ergonomics and Work Study laboratory for the Production Engineering department.2) Setting up CAD/CAM laboratory for the Production Engineering department.3) Robotics System implementation for Nuclear Fuel Complex and ECIL. Design and develop software algorithms to control Robotic controlled machine to sort and stack radioactive pallets for hazardous work environment.Taught programming language and CAD/CAM courses to undergraduate and post graduate students Show less