SUMMARY:

• I have around 22 years of experience in Enterprise Applications, Business Intelligence Systems, Product development, and Consulting.
• I worked on various projects and technologies on Microsoft and UNIX environment. Have worked on various domains such as broker/dealers, time sharing industry, banking, marketing, pharmacy and business process automation.
• Assess and define architecture for cloud/non - cloud based data solutions
• Define solutions for data visualization, data governance
• Architect reporting solutions for businesses to run regulatory reports
• Define data ingestion architecture using Snowflake cloud computing, Microsoft SQL server and Integration Services
• Define architecture of various components such as ETL jobs, applications to proactively maintain data quality in enterprises
• Define enterprise level logging and exception, job management solutions
• Experience in interactive development adopting agile methodology.
• Experience in managing global teams
• Proficient in SQL Server database, SSIS, SSAS, SSRS, PowerBI, SalesForce, Snowflake

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Environment: SSIS, SSAS, SSRS, Azure Cloud Comuting, Power BI, Salesforce, RedGate, dbAMP, Snowflake. Used Jira for Agile management and Confluence for documentation.

Responsibilities:

• Created SQL Data Warehouse in Azure and loaded data using Azure Data Factory.
• Created generic framework to upload files in Azure Blobs.
• Setup FTP server in Azure
• Integrated log analytics with on-prem job management framework
• Participated in overall cloud strategy
• Designed and Developed a process to create EDI-834 files for benefits enrollment, extended SSAS cubes, worked on lots of ETL packages with various data sources, SSRS reports, SQL performance tuning, syncing data in both directions between Salesforce and SQL database.
• Created a framework to perform various file related operations . This is a configurations based system, where you define the steps and schedule the steps to run in certain order to accomplish a task. The framework offers the essential components and tasks to eliminate the need for programming.
• Designed and developed Job Management Framework that allowed business to analyze jobs status in PowerBI dashboard, manage SLAs in Salesforce. This framework monitors all jobs for multiple types of events such as failures, overruns, under runs, late starts, any blocking/deadlock issues. This framework is integrated with Salesforce to manage SLAs of job and case management.
• Created a dynamic reporting framework that takes only a query to be specified and the reports created and sent to vendors in a desired format.

Confidential, Washington

Responsibilities:

• Used complete suite of Business Objects (Universe/Reports/Data Integrator).
• Also managed an extremely effective data team.
• Worked on many MSBI projects from requirements gathering to successful delivery.
• Created functional requirements, high level and low level design documents, modeled data warehouses, created cubes, developed ETL processes and ad hoc as well as dynamic reporting, Balanced Scorecards.
• Worked in presales activities like RFPs, Estimations, Architecture Design Sessions with customers, created POCs.

Environment: Business Objects, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, SQL Server Reporting Services 2008, MOSS 2007

Confidential, FL

Responsibilities:

• Worked on timeshare software application covering full life cycle of timeshare industry.
• This application consolidated data from different resorts and presented it in a format best suited for analysis and reporting capabilities.
• Created star schema, created ETL process using PL/SQL and shell scripts, automated FTP jobs, schedule jobs.
• Created a database library of utilities which contained functionality for generic FILE-IO utility to dump tables into files and upload files into tables, data type checking functions and general validations.

Confidential, FL

Responsibilities:

• Used PowerBuilder 6.5. Heavily used PFC, created dynamic reporting tool.
• Also worked on Image Scanning system, dynamic questionnaire system.
• ASP/VB, Oracle 7.x-8i
• Worked on Agenda Tracking System.
• Did database modelling, created technical design documents, created ASP pages.
• Also have managed a small team for a short time.