Requests
3
3
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Tata Consultancy ServicesProject Manager/Enterprise Data Architect
Apr. 2022United StatesConduct and evaluate different projects technical solutions. Conduct meetings with Stakeholders. Oversee the analyst teams. Work with offshore teams
Inmediata Health GroupLead Data Architect
Mar. 2021 - Mar. 2022RemoteLeading BI Architecture using Data flow of Power BI and azure technologies Leading a team. Changing schema on fly with flexible design using latest Data flow of Power BI to meet variety of products requirements by using reusable objects making development business centric rather than IT base.
Community First Health PlansLead Architect
Jan. 2018 - Aug. 2021San Antonio, TexasMigrating Amaisys to QNXT
CareSourceArchitectect
Jun. 2017 - Jan. 2018Dayton, Ohio AreaDirection and Introduction of Practical use SQL Server 2016 Features, collaboration with Big Data .
Helping Several Team Leads to come up to the speed on Columnstore, SSAS New Features. Define the framework at Enterprice Level
Accion Labs (Change Healthcare)DW BI Solution Architect
Jun. 2016 - May. 2017Nashville, TennesseeEveluating different option and present the best solution for various problems. Manage and oversee on site offshore dev center, design architecture for systems. extracting requirement. Managing several Projects, excellent communication skills with all levels of management. Also help to explore new opportunities for businesses.
UnitedHealth GroupSr, DW Architect/Analyst
Nov. 2013 - May. 2016Problems
1. Daily data load taking much longer time to load, thus blocking other system to run slow.
2. Every year needed to automated system to make updates on procedure codes and other codes and new changes to be implemented without IT development efforts.
3. Current Architecture was not Scalable taking longer time to reload and truncate method
4. Downstream Customers wanted to extract the data was taking longer time even after new architecture due to large data set. Solution/Achievements 1. Re-architecture of the Data Warehouse using Star Schema with Incremental load.
2. Created Configuration tables to implement such changes in excel later will be converted into application interface.
3. Redesigned using partition and also different server to load the data and then switch to main database server in production.
4. Proposed the tabular model after implanting the data warehouse to use query on large set of data.
AT&TLead Data Analyst/DW Architect - MSBI
Jan. 2012 - Nov. 2013San Antonio, Texas AreaProblems 1. Needed Data warehouse Design to fit large data downloads.
2. Using Teradata Queries and spreadsheet for storing the results, needed automation.
3. Contract Negotiation was not accurate due to the exact data for viewership in its density and frequency model was missing.
4. Stream conflicts on different STB device were unknown to its density and frequency model.
5. Huge Teradata large data download needed in SQL for Analytics for contractual density Solution/Achievements
1. Data warehouse road map for ETL and reporting needs from Conceptual, Bus matrix and other design concepts.. using Kimball methodology
2. Introduced SSIS tool against the existing scripts used for Downloading data
3. Rediscovered data using analytics thus saved 15million dollars in contract negotiation thus expanded the team size and promoted as lead architect/Analyst
4. Made the data research to get the exact density and frequency of the conflict model
5. Made research and coordinated with other teams were using Hadoop. Evaluated SQL Solution and tuned the SSIS package packet size and parallel processing
Hewlett-Packard - Consultant From WiproTechnical Architect
Aug. 2011 - Jan. 2012Houston, Texas AreaProblem
1. Wanted to find out which supplier has maximum returns as defective components.
Solution/Achievements • Coordinated with the Business users to elicit requirement created Designed the Star Schema logical design dimensional model
• Resolved architecture & security for SSRS Reporting Services problem for the whole team
• Created roadmap for SSIS packages.
• Lead the team of fifteen developers to resolved their problems
• Received training on SPC (System Process Control) Chart
• Dealt with complex statistical formulas to create U,P,OC & other Charts
• Created user stories & use cases for technical team
• Worked on System integration plan.
Robert Half InternationalDW Analyst
Jan. 2011 - Aug. 2011San Antonio, Texas AreaWorking on Data Warehousing OPAT tool, Gathering requirements,Co-orninating with technical team etc
COMSYS formerly Venturi Technology Partners and several othersConsultant
Jul. 1998 - Dec. 2010Worked on Different projects which includes- Wilshire Credit Corporation Evergreen Healthcare Consulting
Infosys Technology Microsoft City of Vancouver Oregon Dept. of Human Resources Nike Merix LTD Conway Problems
1. Mainframe data in bulk needed to transfer in SQL and Analysis to be done at the front end
2. Needed report coming out of Legacy system
3. Needed to get specific need from large data warehouse
4. Needed Dynamic DataMart across the products in Microsoft
5. Needed report to have slice and dice capability at Wilshire
Solution/Achievements
1. Single handedly architected and design Data warehouse in SQL Server and also for pre-process aggregate tables so the reports can get immediate results. Awarded top 10 consultant in State.
2. Elicit requirements to match and converted business needs into technical analysis
3. Created the DataMart to cater the functional requirements
4. Architecture and design Dynamic DataMart populated of the metadata captured at the front end
5. Created the star schema and introduced (SSAS) cubes.
Intch is a Professional Networking App for the Future of WorkSee more people like Dnyanesh on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
225156 people
16
Program Manager @ DISH Network
26
Investment manager @ United FX
33
Financial consultant @ Nedixprimecrypto.com
70233 people
42
Senior Mining Engineer @ Riot blockchain
62
CEO /Co-founder @ The James Ruff Group/ HardMoney Loans
25
Mortgage Loan Officer @ Triple T Investment INC