Data Manager
Resume:
ANU KUMAR
adjrff@r.postjobfree.com
Business Intelligence (BI)/Data Warehousing Advisor
SUMMARY
MicroStrategy Certified Business Intelligence (BI) Developer and Data Warehousing Advisor having 20 years of IT experience in Architecting, Designing and Developing Data Warehouse/Business Intelligence applications for large corporations like American Express and CVS Health.
Extensive work experience spanning all Data Warehousing focus areas: Data Visualization (using Stephen Few and Edward Tufte’s principles), SQL, UNIX scripts, Requirement analysis, Source data analysis, Data modeling (OLAP structure/Fact-Dimension model), Data extraction and Transformation logic (ETL), Report/Dashboard development using MicroStrategy and Tableau (Web and Mobile).
Experience in developing logical/physical data models - Star schema/ Snow-flake modeling on Teradata (MPP), Oracle and DB2 databases.
Experience in all phases of BI Systems Life Cycle (Analyze, Manage, Develop, Test and Implement) – using both traditional Waterfall and Agile methodologies.
Experience as Technical Sr. Manager (managing BI teams), People Management (mentoring, coaching, accountability and talent retention). Coordination across multiple Tech and Business groups to implement complex BI solutions.
TECHNICAL QUALIFICATIONS
Data Warehousing/BI Tools MicroStrategy Ver. 8.1, 9.0.1, 9.2.1, 10.4. 11.1 (2019) including MS on AWS Cloud, Server Administration, MS Mobile development, Actuate (Ver. 5.2 and 7.1), Tableau (Ver. 10.5, 2019)
Databases Teradata, Snowflake Cloud DB (on AWS), DB2, Oracle, SQL Server.
Languages SQL, PL/SQL, UNIX Script, VBScript, C++, VC++, VB 6.0, HTML.
Tools & Applications Visual Studio 6.0, Rational Requisite Pro, TOAD/Quest, Teradata SQL Assistant, Load Runner, Visual Source Safe, Stellent Document Management tool, Objective Grid 7.02 from Stingray Software
EDUCATION/DOMAIN CERTIFICATIONS
Bachelor of Engineering (B.E)
R.E.C. Bhopal (National Institute of Technology - NIT)
Year Passed: July 2000.
Certified MicroStrategy Project Designer
(MicroStrategy Desktop: Reporting Essentials + MicroStrategy Architect: Project Design)
Certified MicroStrategy Project Developer
(MicroStrategy Report Services: Document Essentials + MicroStrategy Desktop: Advanced Reporting)
PROFESSIONAL EXPERIENCE
CVS Health
September 2012 – Present
Title: Advisor, BI/Analytics
Location: Scottsdale, AZ
BI Tools: MicroStrategy, Tableau. DB: Teradata, Snowflake on AWS Cloud, Oracle. Core Skills: SQL, Data Visualization, OLAP Data modeling and Dashboard development (Web/Mobile).
Tasks and Responsibilities:
Requirement (Story) analysis, design, code, test, debug, and implement (using Agile methodology) complex Business Intelligence solutions using MicroStrategy, including development of reports, grids, graphs, dashboards, OLAP data model and SQL queries – with complete ownership of BI architecture.
As MicroStrategy certified Developer - Worked on all aspects of MicroStrategy tool: Intelligent Cubes, Documents, Dossiers, Grid reports, Object Manager, Integrity Manager.
Worked extensively in MicroStrategy Administration like creation of new users, roles, privileges, shared folders, access controls Lists and Report development using Advanced Prompts, Custom Groups, Consolidation, Drill Maps, Non-aggregate, Conditional and Transformation metrics.
Data Visualization/Dashboard design using Stephen Few and Edward Tufte’s principles.
Tune supporting queries and reports, SQL performance tuning, building upon best practices and processes to improve end-user experience and response time.
Transition from Traditional DB (Oracle) to MPP DB (Teradata) - Ensuring that all changes get replicated for multiple projects on EDW and CDW platforms utilizing Teradata defined best practices, tools, and change management processes.
Build upon best practices and processes to improve end-user access and response time. Provide testing assistance on production updates, including MicroStrategy upgrades, project rollouts, architecture modifications, and new dashboards/reports.
As Sr. Technical Manager (Scrum master) manage BI teams and coordinate across multiple Tech teams and Business groups.
Provide support of current MS Narrowcast Services and work to migrate reporting to Distribution Services. Assist the user support group in methodology inquiries, issue resolution, data research, and documentation.
Maintain and update skills in data warehousing, programming, and application development through monitoring of the BI/DW knowledge bases, BI white papers, online user groups, including being up to date on healthcare and financial business environment.
Apollo Group Inc.
October 2011 – September 2012
Title: Sr. Business Intelligence Architect
Location: Phoenix, AZ
Tasks and Responsibilities:
Worked as Technical Lead for architecting and conversion of Business Object (BO) BI tool to MicroStrategy in Apollo group.
Provide guidance and knowledge transfer to existing BI development team, including best practices with MicroStrategy tools.
Perform problem assessment, resolution, and performance tuning for new and existing reports.
Collaborate with data modelers and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
Interface directly with Business customers to understand their process and information needs.
Validating MS BI product results (after BO conversion) against requirements and existing BO reports/dashboards.
American Express (through Infosys and AtoS Syntel Inc.)
May 2005 – October 2011
Title: Technical Lead Architect
Location: American Express @ Phoenix, AZ / Toronto, ON, Canada
Tasks and Responsibilities:
As Tech Lead Architect - took bottom line responsibility for report delivery and implementation per AMEX deadline/SLA, manage client expectations, estimates and scope associated with each task/delivery.
Conceptualized, Architected, and Designed BI/MicroStrategy reporting solution.
Played an over-arching role coordinating effort across multiple tech teams and groups: Data Architects, DBAs, ETL and BI reporting team.
Led a 12 member BI technical team and served as primary client contact to resolve all BI/DW solution and architecture related issues.
Developed SQL queries and UNIX Scripts as required for data quality analysis report, data verification and performance tuning.
Worked with DBAs to exclusively design OLAP database design (Star/Snowflake schema) for all BI reporting requirements.
Design Proof of Concepts using both 2-tier and 3-tier architecture in MS.
Ameriprise (previously American Express Financial Advisors) through Infosys
February 2001 – May 2005
Title: Programmer Analyst
Location: Minneapolis, MN @ Ameriprise
Tasks and Responsibilities:
Actuate Server Administration with 24/7 support and maintenance to Actuate reporting system (Ver.5 and Ver.7).
Manage and coordinate Actuate server maintenance, software upgrade, integration issues with all related support groups within Ameriprise. (Included Stellent Document Management server installation- as a separate project).
Coordination across Tech and Business groups- for new report designs, enhancements and maintenance activities.
Migration from Actuate Ver. 5.1 to Ver. 7.1. The tasks involved were:
oDecommissioning all stand-alone Actuate applications (on independent single servers) and migrating to multi-volume clustered environment.
oConverting all existing C++ RS and RC APIs to Java/SOAP based APIs.
Data modeling and Database design (OLTP) for Actuate reports.
Northwestern Mutual (through Infosys)
July 2000 – February 2001
Title: Software Engineer
Location: Bangalore, India
Porting GUI application from DOS to VC++
Tasks and Responsibilities:
Design and code the application screens being ported from DOS based screens VC++.
Testing- Including Test plan (Unit/Integration) documentation.
Integrating Objective Grid 7.02 from Stingray Software with Microsoft Visual C++ 6.0 for grid-based data display.
Coordination with multiple vendors, DBAs, business and technology groups for end-to-end analysis, design, development, testing and implementation.
References
Available upon request.
Contact this candidate