SUMMARY

• 17 years of IT consulting experience in planning, development, and implementation of result oriented large - scale data warehouse/business intelligence and analytics solutions for customer focused complex business problems to drive corporate growth and return on investment.
• Deep knowledge and experience with data analytics solutions, ETL architecture, OLAP, adaptive warehouse solutions, enterprise data strategy, data quality, data governance and master data management across diverse industry domains.
• Hands-on experience with emerging cloud technologies (Talend, Looker, AWS Infrastructure, Redshift), traditional data warehouse toolsets (Informatica, Business Objects, Kalido), visualization tools (Tableau) and programming languages (Python, UNIX, PL/SQL).
• Well-rounded and deep technology background with infrastructure design/management, software development life cycle. Valued for spearheading modernization, process improvement and using innovative architectural techniques for data management solutions.
• Natural abilities for collaboration, consensus building, crisis management, problem-solving and negotiating with business stakeholders and team members.

Professional Experience:

Self- Employed

Confidential

Responsibilities:

• Conduct product research, customer and market trend analysis to form product strategy. Collaboratively work with suppliers/manufacturers and external regulatory agencies to establish steady product supply.
• Develop brand and messaging to attract and retain customers.
• Form digital marketing strategy, perform financial planning and capital management.

Excella Consulting

Confidential

Responsibilities:

• Design the data model to implement executive dashboard involving open/ongoing/closed Audit, Evaluations and Investigations.
• Design the data model for a new Financial / Early fraud detection EDW for Medicaid and Medicare data.
• Provide guidance on data architecture to integrate transactional Medicare / Medicaid data to support Field Offices in initiating audits and / or ongoing evaluations and investigations.
• Used Agile engineering techniques for solution development.
• Reduced a script with over 1000sql statements to under 10 steps using the available modern toolset.

Tools: Talend, Looker, AWS based Infrastructure

Confidential

Responsibilities:

• Creation of information requirements, principals, context diagrams and data models, the roadmap and directions dat powered management’s key initiatives.
• Led the design of enterprise wide solution for Touch-Point optimization across four brands of therapeutic classes. Identified and integrated interactions with customers from different channels to align with the sales data. dis, done manually used to take 45-60 days. EDW reduced the reporting time to 4 days with high accuracy.
• Identified bottlenecks in data loads, scheduling and batch processes to reduce the data load window to a mere 6 hours from 3 days (Data load consisting 1.4billion records).
• Creation and oversight of data quality standards, data modeling and integration, data profiling and release management.
• Oversight of the development team, offshore personnel and training full time employees.
• Iterative implementation of the warehouse solution, along with enhancements across UK, Germany and Japan with a start to finish time of less than 90 days per country.
• Understand data and align entities, perform gap analysis for varied sources, data grains across the global solution.
• Requirement gathering and creation of reports and visualization using Tableau.
• Change management (across countries) during the maintenance phase.

Toolset: Informatica, Kalido DIW, Netezza, Oracle, Tableau and Business Objects, UNIX.

Confidential

Responsibilities:

• Design data warehouse solution to align sales data for trend analysis across regions, territories and determine key accounts, key customers.
• Enable data generation for third party vendors to better generate and manage Call Plans for sales representatives across regions of poor sales performance. dis provides a direct value to stakeholders in from of data enabled decision making and increased ROI.
• Design solution to align sales representatives across territories to sales and provide as of transaction date reports for incentive compensation.
• Led the team of eight people to provide an integrated solution for sales reporting across unique customers and align them with geographic hierarchy.
• Oversight and configuration of Rackspace data servers for optimum efficiency.
• Built MDM solution to collect customer data across data vendors and involve data stewards to has ‘One true view’ of customers.
• Requirement gathering from Business for published and dynamic reports. Develop Business Objects Universe for the same.

Toolset: Microsoft SQL Server, Kalido DIW, Kalido MDM, Business Objects.

Confidential, Buffalo, New York.

Responsibilities:

• Design an EDW based on the requirements documented by project management team.
• Engage with stakeholders to align long term vision with short term project wins using Adaptive Data warehouse methodology provide by Kalido.Design the ODS, staging area, suspense management of error records to improve accuracy of reports.
• Provide technical design overview for the data warehouse setup and implementation.
• Engage in data analysis, quality analysis, testing and deployment of solution to an error free production environment.
• Work as a translating conduit between the business stake holders and technical team and define technical requirements from business requirements.

Toolset: Informatica, Oracle, Kalido DIW, Kalido MDM, Cognos, UNIX.