GYAN GUPTA

469-***-****

ac200h@r.postjobfree.com

PROFESSIONAL SUMMARY

•Over 20 years of experience in IT Solutions design, delivery, budgeting, people, and project management with specialization in Data Architecture, Business Intelligence, Data Warehousing, Analytics, and Application Development.

•Possess excellent, analytical, and organizational skills along with hands-on technical experience with end to end business understanding.

•Design, model, develop, and manage cost effective enterprise data models, data warehouse, business intelligence, and predictive analytics solutions across various industries.

•Ability to learn and manage new technologies, team building and consolidation, motivating teams, assimilating quickly, finding solutions during crisis, and thriving on challenges & pressures at work.

•Customer centric leader, who excels in delivering strategic business solutions with a focus in measurable ROI.

VERSATILE IT PROFESSIONAL & LEADER

Deliver End-to-End solutions Integrate Processes with Technology Optimize IT Performance Enterprise Data Warehousing Business Intelligence Analytics Bigdata Data Science Project & Resource Management Agile development Market Data integration Hands-on Manager

TECHNICAL SKILLS

Databases

SQL Server, DB2, MySQL, Postgres, Teradata, Oracle

BI Tools

IBM Cognos 7/10.2/11 (FM, Transformer, Report Studio), BO, Crystal Reports, Tableau, IBM Watson, Domo, Power BI

ETL Tools

SSIS, Informatica, DataStage

Bigdata

HDFS, Hive, Pig, HBase, Sqoop

Data Science

Python, R, SAS

Programming

VBA, VB, ASP, C#, PowerShell, Unix Shell scripting, Java Scripts, XML

Other Tools

ArcGIS, ESRI, MS Office, Visio, MS Project, AWS, Alexa Skill, Node JS, Lambda, RedShift, JIRA, Workday, Oracle ERP, Concur, Vertex, Xactly, Erwin, SecureFX/CRT, Adobe Writer, CA, HP OpenView, SharePoint

SOLUTION ENGAGEMENTS

Orthofix, Lewisville, TX March 2014 – September 2017 Director, Reporting & Analytics

•Managed all phases of project implementation starting from IT strategy, roadmap development, vendor selection, negotiation and consolidation, infrastructure planning, RFP, SOW, POC, technology selection, development management to implementation, team mentorship and management, support, and user training.

•Transformed non-performing team to a highly skilled, motivated, business oriented, result oriented and customer focused team.

•Improved IT turnaround time and customer satisfactions by 40% by creating internal BICC and BI User group for analytics improvement and adoption.

•Worked as an Solutions Architect/Leader and developed/managed Database models, Ad-hoc and standard reporting, Enterprise Data Warehousing, and Analytics related initiatives to support all business sales units, internal and external customer.

•Developed and managed SQL scripts, Stored Procedures, SSIS packages, Reports, Dashboards, SAS predictive models, Python scripts, ETL packages, and various Bigdata ingestion programs.

•Designed and managed Star schema model for EDW, documented ETL mapping, mentored EDW Testers, Business Analyst, ETL developers and various business EDW consumers.

•Designed, developed & managed Enterprise Data warehouse, BI analytics & data strategy roadmap, self-service product development, day to day reporting & analytics for FP&A, HR, Sales & Marketing, Order to Cash, COE, Customer Service, Finance, SOX Control, Compliance, Supply Chain, Vendors, and External Auditors, etc.

•Integrated various external and internal data for analytics into EDW e.g. Oracle ERP, Concur, Market Data, Vertex Tax, Workday, Salesforce, Supplier data, CMS data, Xactly incentive comp, etc.

•Explored and managed new technologies and R&D activities e.g. Bigdata, Cloud solution, IOT, Mobile responsive Analytics apps, Box, GIS integration, AWS, Alexa Skills, etc.

Environment: Oracle 11i/R12 ERP, Noetix, Workday, IBM InfoSphere DataStage, Oracle 12c, SQL Server 2012, SSIS, SSAS, SAS 9.2, BO, Tableau, Domo, PowerPivot, Cognos 10.2/11, BO, ESRI Mapping, IBM Watson Analytics, TM1, HFM, Vertex Tax, Concur, Salesforce CRM, JIRA, AWS, Alexa Skill, NodeJS, Python, Xactly Incentive Compensation, bigdata, DynamoDB, JIRA, SharePoint, EDI, Redshift, MySQL, Bigdata (HDFS, Map Reduce, Hive, Sqoop, Pig, Hue, NoSQL, HBase), WinSCP, Box, Docusign, and Unix Bash scripting.

BlueCross BlueShield, Richardson, TX October 2006 – March 2014 Principal EDW and BI Solution Delivery Management

•Worked with Analytics Information Management and TIS group as a lead for various corporate data architecture, integration, reporting and analytics initiatives.

•Supported internal and external clients to implement, manage, and support solutions (e.g. BI, OLAP Cubes, Ad-Hoc, Data architecture, Standard Reporting, ETL, Predictive analytics, Dashboards and Visualization solutions).

•Actively involved in presenting demo, and mentoring various teams throughout organization at various levels to improve Data and Analytics adaptability in the organization.

•Led solutions for Medicare, Medicaid, Provider ratings, Claims, Claims Recovery, Health Care management, Campaigns, BlueView, eIVR, Sales, PMO, Prospects, Renewal (Small group/Large Group), HP Openview, CA Helpdesk/Change control process, Problem management, VBCM, ACO, BCC, BHI, Customer ROI, Pharmacy reporting, Predictive indicators for medical management (Alineo/Ariel), and KPI business alerts.

Environment: DB2, Oracle, Teradata, IBM InfoSphere DataStage, SQL Server, SSIS, SSAS, SAS, R, Cognos, Siebel, eIVR, HP Openview, CA Helpdesk, Business Objects, Tableau, Unix, Access, GeoCoder, VBA, Salesforce, MotioCI, Webtrend, Google API.

UnitedHealth Group, Plano, TX August 2003 – October 2006 Business Intelligence Technical Delivery Lead

•Led an onshore and offshore team of developers, ETL developers, DBA, and BA to design and support BI solutions for Care Management, 24 Hours Nurse line, Assessments, Gap and Intervention, and Quarterly/Yearly Cost Effectiveness & Outcome reporting package development for customers.

•Helped business teams, with providing leadership, to monitor ROI, utilize and manage different resources effectively to drive the business successfully.

•Developed BI reporting, Data models, and ETL scripts.

•Developed SQL scripts for data validations and testing.

Environment: DB2, Oracle, SQL Server, SSIS, SSAS, SAS, Cognos, VBA, Access.

R Systems Inc, El Dorado Hills, CA April 2000 – August 2003 Business Intelligence Solutions Delivery Manager

•Managed teams of resources of 10 to 15 depending on project needs.

•Worked as an Off-shore and On-shore project coordinator.

•Involved in requirement gathering, project planning, project negotiations, project delivery, ongoing support, process streamlining, and maintenance.

•Managed various projects up to 2 Million USD and successfully managed clients and teams of resources from different geographical locations.

•Involved in mentoring, solution designing, troubleshooting, user training, and onsite customer issue resolutions & management along with hands-on technical expertise.

Managed following accounts for R Systems

1.Verizon, Irving, TX

2.Aggreko, New Iberia, LA

3.Synhrgy HR Technologies (Currently Mercer HR), Houston, TX

4.RealNames Corporation, Redwood City, CA

5.State Government of California – FPPC, Sacramento, CA

Environment: DB2, Oracle, MySQL, SQL Server, SSIS, SSAS, Sybase, Cognos, Crystal Reports, Brio, Broadbase EPM, ASP, VB, VBA, Access.

R Systems, India November 1999 – April 2000 Lead Software Engineer

•Worked with software development team and played different roles for various external customer and internal projects, which include business analysis, data analysis, database design, data integration, and report development & configuration tasks.

• Involved in documentation, user training, software packaging, and ongoing applications support.

Environment: Oracle, SQL Server, DTS, Cognos, Crystal Reports, ASP, VB, VBA, Access.

Sumitomo Motherson Integrated Technologies June 1999 – November 1999 Programmer Analyst

• Worked as a programmer analyst to support internal applications development, maintenance to support supply chain, and production planning activities for Auto parts manufacturing resource planning and delivery.

Environment: Sybase, FoxPro, SQL Server, DTS, Crystal Reports, ASP, VB, VBA, Access.

CCS Computers July 1996 – June 1999 Programmer

•Worked as a programmer for software product development and consulting company.

•Supported every phase of application development lifecycle from start to implementation and on-going support for various clients. e.g. Vista Levelor, ICI Paints, Army and LG Electronics etc.

Environment: SQL Server, DTS, dBase, FoxPro, Crystal Reports, ASP, VB, VBA, Access.

EDUCATION / CERTIFICATIONS

Masters of Computer Applications

Bachelor of Computer Science

Business Intelligence and Analytics Degree Certificate – SMU Cox

Contact this candidate