SUMMARY:

• More than 18 years of experience in Information Technology with focus on business intelligence, big data, ML and related technologies including but not limited to data ware - housing, Cloud Technologies (Azure), ETL, reporting and dashboard systems, data and business analytics, data mining, database management systems, data architecture, data modeling, data integration and data migration by using the latest tools and technologies available
• Experience in leading projects involving complex architecture, cloud, Big Data, Machine learning and Artificial intelligence and associated AI algorithms. Experience in developing ML web services/AI algorithms in Azure ML studio and creating web services.
• Key strengths include knowledge of technical architecture, ability to architect and implement big data and AI solutions, technical leadership, software development, data gathering and analysis, data mining, dealing with big data and related technologies, business and systems analysis, requirements gathering and requirements analysis and AI/ML.
• Hands on experience and extensive knowledge of Business Intelligence technologies (specializing in the Microsoft stack) - SQL Server 2008/2012 Database, Integration Services, PowerBI, Analysis Services, Reporting Services, MicroStrategy.
• Strong communication, presentation, analytical skills, technical leadership, business acumen and ability to provide business intelligence solutions
• Good track record of leading and executing various financially large and technically complex business intelligence projects for some of the most prestigious firms where technologies were pushed to the limits to fulfill business needs

TECHNICAL SKILLS:

Business Intelligence: Microsoft Reporting Services, Analysis Services, PowerBI, MicroStrategy, OLAP Cubes, Excel, PowerPivots, Dashboards etc.

Big Data: Hadoop, Spark, Hive, EMR, HDInsight

AI: Tensorflow, Azure ML Studio

Cloud: Google Cloud Platform - Dataproc, Kubernetes, App Engine, Big Table, Big Query, Cloud SQL, Cloud Spanner and more,Amazon Web Services - EMR, EC2, VPC, RDS, Redshift, S3, Lambda, CloudFront, SL, SNS, Route53 etc,Microsoft Azure - HDInsight, Virtual Machines, SQL PaaS, VNet, Azure IoT etc.

Database: SQL Server, MySQL, Oracle (Extensive knowledge of SQL)

Container: Docker, Kubernetes

Programming Lang: Python

OS: Windows, Linux

General: Enterprise Architecture, Cloud Strategy, Cloud cost optimization, MicroServices

PROFESSIONAL EXPERIENCE

Confidential, MA

Senior Technical Manager/Architect

Responsibilities:

• Built reporting analytics system and was responsible for forming a team of 8-10 people to support mission critical analytics system
• Implement enterprise data warehouse and associated reporting in Microsoft BI stack
• Develop and support the billing systems in BI
• Create a state of the art analytics portal using Microstrategy which was accessible by internal and external users and provides stunning dashboards which can be customized by users to suit their needs
• Create and maintain reports in MicroStrategy which provide insight into all businesses related to Mobility
• Take part in pre-sales or RFP activities related to selling analytics as a product
• Create and implement to re-shape analytics and BI as a product
• Train, Mentor and lead a team of 10 developers and architects
• Lead AI projects which implemented customer segmentation and propensity using neural networks and regression models
• Build and execute strategy to move on-premise systems to Microsoft Azure cloud
• Establish cost saving techniques on the cloud through efficient practices and architecture
• Implement complex cloud architecture, networking, identity management etc.

Technology: Microsoft SQL Server (DB, SSIS, SSAS), PowerBI, Microsoft Azure, Hadoop, Spark, MicroStrategy, Python, Tensorflow, Windows, Linux

Confidential, Boca Raton, FL

Senior Business Intelligence Architect

Responsibilities:

• Designing and architect solutions as it relates to business intelligence/reporting system for all products
• Design, Create and review database models during development of new systems
• Administer database servers that belong to our project
• Design and Develop data-warehouse (develop the data model, data mapping extract transform and load data from OLTP systems, data refresh etc.)
• Support and troubleshoot the business intelligence product
• Data migration from legacy database system as it relates to migration to a new platform
• Perform data analysis and mining on the data to troubleshoot any problems in the reports, dashboards or KPI
• Use Microsoft reporting services and crystal reports to develop new dashboards and reports
• Evaluate new tools and technologies related to Business Intelligence
• Review and evaluate external vendors who may partner with the company related to our data products
• Develop, as may be necessary, T-SQL scripts, stored procedures, triggers, functions etc.
• Train and mentor teams on aspects related to data-warehouse, reports, dashboards, KPI and data integration
• Use Excel (Power-Pivot) or Microsoft analysis services to analyze multi-dimensional data models
• Develop data feeds to make data accessible across the organization
• Gather and analyze user requirements to align the technical solution according to the user needs

Technology: Microsoft SQL Server Database, Reporting Services, Analytics Services, PowerBI, Microsoft Azure

Confidential

Technical Architect/Developer

Responsibilities:

• Create database models relating to systems serving premium card-members
• Developed reports, KPI’s and dashboards that shows insight into premium card-members
• Take part and contribute in the Design reviews, Architecture reviews, code reviews conducted in the department
• Driving requirements from a technical perspective for building of a new application in .Net for servicing of premium card members
• Created prototypes in HTML and JavaScript and drive usability sessions with the Telephone reps to determine impact on Average Handling Time of calls.
• Designed the technical architecture of the solution from among various options available.
• Designed and developed the solution in VB.Net, JavaScript and HTML and adhering to the strict quality standards and within budget and schedule.
• Re-engineered the various web pages related to APRs in the Card member servicing application.
• Developed various enterprise-wide web services in Windows Communication Foundation
• Presented white paper on Windows Communication Foundation Interoperability with WSE 2.0 and WSE 3.0
• Spearheaded the initiative to uplift .Net from 1.1 to 2.0. Provided a business case for doing so highlighting to the top management, the cost saving due to moving to .Net 2.0. This involved analyzing the features of the new platform like AJAX, Asynchronous database operations, improved productivity due to significant enhancements to ASP.Net etc. Also created a comprehensive value model citing the cost-savings every year to the business as a result of the uplift.
• I led the team of developers by providing hands-on help, technical direction and guidance.
• Create sizing, resource management plans, Cost-benefit analysis documents and initiate project discussions
• Created and presented proposals and won several large multi million dollar deals for my company

Technology: .NET, SQL Server, HTML, Java-script

Confidential, New York

Business Intelligence Architect/Developer

Responsibilities:

• Elicited and analyzed reporting requirements for Alternative Investments team of Merrill, with an intent to enhance their reporting capabilities.
• Led the team that devised and Implemented reporting solution for Alternative Investments team
• Created Oracle data-warehouse which was fed with data from online tables through various newly developed stored procedures
• Designed and developed reports in Crystal Reports for enhancing the FA experience of selling Alternative Investment products. These crystal reports had the ability to display complex graphs based on many years worth of data
• Created more than 40 reports in Oracle Discoverer which were heavily used by Portfolio managers to take decisions
• Liaised with various departments and outside vendors to implement new feeds and interfaces to enhance the quantity and quality of data to be reported on
• Improved the performance of existing reports significantly by tuning the database and the related queries

Technology: Oracle 10g, Crystal Reports, Oracle Discoverer, Oracle Business Intelligence (OBIEE)

Confidential, New York

Business Intelligence Developer/Architect

Responsibilities:

• Elicit and analyze user requirements, prepare functional and technical specifications pertaining to reporting needs, design new reports, KPI and dashboards which automated various manual processes significantly enhancing the efficiency of decision making process
• Conduct meetings with users to gather requirements, analyze business needs, co-ordinate with offshore teams and lead the onshore team
• Designed and developed various data-marts in Oracle and SQL Server which significantly improved the quality and performance of reports
• Created cubes and reports with Microsoft Analysis services to deliver real-time analytics to the business
• Create Qs, Batch jobs and stored procedures to replicate tables in different locations
• Maintained the existing repositories of more than 300 reports
• Extensively write Oracle and SQL server stored procedures and Queries for reports to cater to the complicated business requirements of the reporting team
• Conduct appropriate trainings for new inductees into the team
• Executed migration of reporting platforms from Crystal Reports to Microsoft Reporting Services
• Migrated the entire reporting database from Oracle to SQL server 2005
• Acting as single point of contact for any user queries, requests for data or resolving issues regarding data
• Initiated many projects by submitting proposals and winning deals for my company

Technology: Oracle 8i, Crystal Reports, SQL Server 2005, Microsoft Reporting Services, SQL Server Analysis Services, Data-warehouse

Confidential

Senior Developer

Responsibilities:

• Redesigning the entire DB2 database related to Product control file application
• Interpret ER diagrams and convert them into database access module Cobol DB2 programs
• Write CICS programs
• Re-write the COBOL programs accessing the database
• Create project plans, schedules, design documents and test strategy for the project

Technology: CICS, DB2, JCL

Confidential

Developer

Responsibilities:

• Maintain and enhance the materials warehouse, inventory and purchase system of the automobile major
• Programming applications related to Purchase, Inventory, Warehousing
• Writing programs for creating reports and support the decision support system
• Technology - C, Pro C, Unix, Oracle, Developer 2K