Anshul Agrawal Email & Phone Number

Atlanta, Ga, Us

Bangalore, Karnataka, In

• Key contributor to the Charter's MIGR8 project, joining mid-project in January 2024 to lead the XBI Workstream, overseeing the migration of 2+ PB of data to AWS Redshift.• Guided team onboarding and knowledge sharing by mentoring new team members on project standards, code conversion, and Redshift-specific optimizations.• Facilitated support from AWS Professional Services to ensure alignment with Charter’s architecture, collaborating on key deployment and performance adjustments.• Secured AWS MAP funding by developing a comprehensive Business Case for Project Cost Optimization, successfully supporting Infosys’s eligibility for AWS’s funding program.• Coordinated communication with Infosys leadership for strategic updates, project funding requests, and reporting metrics, strengthening Infosys’s standing in the engagement.

Stamford, Connecticut, Us

Worked on Project#8 – Charter MIGR8 Teradata to Redshift Migration Project(Project Details here ☛ https://www.linkedin.com/in/starpageup#projects )• Led the XBI Workstream in the MIGR8 project, migrating 2+ PB of data from Teradata to AWS Redshift, meeting aggressive performance and data integrity standards for seamless continuity of Charter’s BI services.• Brought deep Redshift expertise from previous experience, enhancing the project with features like Data Sharing, Concurrency Scaling, WLM setup, Permissions configuration and Usage Monitoring.• Oversaw code conversions for BI’s critical Stored Procedures, converted complex (L/XL) Stored Procedures by leveraging prior experience, swiftly adapting without prior knowledge of the underlying business logic.• Enhanced project efficiency by performance tuning existing code to Redshift Standards, expanding on knowledge of triaging queries and optimizing areas by use of accurate data structures and code.• Implemented rigorous Validation processes, using T0-T1 parallel snapshot testing, which enabled consistent data accuracy and maintained system integrity across environments.• Coordinated daily operations across onshore and offshore teams, driving progress through regular stand-ups and representing the project in weekly status calls to track milestones.• Supported post-go-live operations with a dedicated month of hyper-care, optimizing Stored Procedures and validating BI data accuracy for Sales and Supply Chain Verticals.Provided Thought Leadership, Technical Expertise, and Impact on the MIGR8 project to drive within very strict timelines and requirements of a tough client.

Atlanta, Georgia, Us

Worked on Project#7 – Carter’s Enterprise BI / Global Insourcing Center (GIC) Project (Project Details here ☛ https://www.linkedin.com/in/starpageup#projects )• Quickly onboarded to Project after joining the client, for Development and Support of over 1500+ Control-M Jobs and 300+ Informatica Workflows. These covers Jobs on EDW Loads and Informatica Integrations.• Managing a Team of Total 11 ETL Resources at offshore to support the Carter’s Enterprise BI environment.• Supporting the 24*7 working model; Creating and Managing Shifts, performing Rotations, providing adequate Coverage over difficult times like Night Shifts and Weekends.• Acting as an internal consultant, providing vision, anticipating problems, and designing solutions for the assigned project. Ensuring deliveries are on-time.• Designing and developing ETL Solutions, Database structures for loading data in ELT fashion (Extract, Load and Transform methodology) from multiple data sources into AWS Redshift Cloud.• Creating integrations across Carter’s Systems utilizing Informatica, Control-M and other tools like ESB (IBM WebSphere MQ), Data Power, EDI etc. to meet Business and IT requirements• Maintaining consistent Support along with deliveries. 1) Resolution of Avg 150 Tickets per month by ETL Team, with issues pertaining to Job Failures, Data Issues, and other Business Requests. Collaborating with other IT teams on Issue Resolution as necessary. 2) Improvement of several recurring job failures by tracking and identifying them using 80:20 Pareto analysis 3) Fixing and Automation of several Data Load Jobs within Carters to reduce support requirements.• Provide hands-on support for Builds, Production Launch, and Post-deployment issue resolution.• Project Management by effectively tracking Tickets in JIRA in AGILE/Scrum based approach.Awarded Carter’s – Systems Plus GEM (Going-Extra-Mile) award within 3 months of joining the project for contributions made to the project.

Wood Dale, Il, Us

Worked on Project#6 - Videojet Enterprise Business Analytics (Project Details here ☛ https://www.linkedin.com/in/starpageup#projects )• Improved Performance of existing Reporting Model by carefully evaluating and adjusting the OBIEE Data Model based on Database Table Structure.• Provided Reports in OBIEE for Revenue, Sales Orders, Service, Opportunities, etc. based on transactional data coming from multiple Data Sources like Oracle EBS, Oracle Fusion Cloud / Oracle Financials, Navision, SFDC, Big Machines, etc.• Provided extensive Period over Period comparison (like Year over Year - YoY, Quarter over Quarter, Month over Month, etc.) Reports using custom Fiscal Calendar defined for Videojet.• Provided Complex, Multi-Level Aggregated, Transactional day to day reports by means of Custom Logical SQL and Direct SQLs in OBIEE. These Reports would otherwise have been difficult using standard Data Model based approach.• Created reports using advance SQL functionalities like SYS_CONTEXT, Parameterized Views, dynamically adding Measures to SQLs using Pivot/Unpivot etc.• Responsible for the design and implementation of cross functional Business Intelligence Systems and Processes.• Performed migration of some Reports from Oracle BI platform to Tableau - to provide better Visualizable Reports.• Upgraded OBIEE 11g (11.1.1.7.1) to OBIEE 12c (12.2.1.2) in its entirety and migrating from ODI to Informatica – Improved Performance, added New Security Model and Migrated All Users • Created Informatica Cloud Workflows and Mappings to extract Data from Oracle Fusion Cloud / Oracle Financials using OTBI Web Services and Custom SQL Queries. This method of extraction is different from using BI Cloud Connector BICS Extracts or Any other specific Connectors which may require a subscription fees and do not provide complete extracts.Had the best ever, recognized coordination between Onsite and Offshore to ensure smooth and successful ongoing project.

Atlanta, Ga, Us

Worked on Project#5 - Verizon HUM® Sales, Service and Marketing Analytics (Project Details here ☛ https://www.linkedin.com/in/starpageup#projects )• Performed Setup and Installation of OBIEE 11g on Oracle Enterprise Linux (OEL 6)• Performed Setup and Installation of OBIA 7.9.6.4 for Sales, Service & Marketing Analytics. Set Informatica 9.5.1 HF2 Repository with pre-built Mappings and Workflows that comes with OBIA.• Setup Data Warehouse Administration Control (DAC) Scheduler with OBIA on OEL 6. Identified and customly set the only tables required for Sales, Service and Marketing Analytics in the DW database.• Set and coordinated with Siebel CRM Team for setting up DAC's Change Data Capture views and triggers in Siebel database.• Performed setup and integration of Siebel Marketing with OBIEE, to enable successful launching of Siebel Marketing Campaigns.• Set SSO (Single Sign On), integration with OID LDAP, Custom Roles & Groups assignments in DW database and overall Security in OBIEE - including both Authentication and Authorization (Catalog permissions and privileges).• Developed Reports and Dashboards to requirements, modified OBIEE Repository (RPD) models - Added new Subject Areas, Metadata to enable customized, self-serve Reporting.• Integrated Data from various sources to show one view for Orders, Customers and Device History & Current Analytics.• Developed Next Gen visualizable Graphs and Charts in OBIEE using D3 (Data Driven Documents) JavaScripts. Some similar samples of implemented D3 Viz are available here: 1) https://datamaps.github.io/#map_election 2) https://github.com/d3/d3/wiki/Gallery• Set overall coordination in the Team. Set processes for Code Development and Deployment.• Performed System upgrades like Patching OBIEE, coordinated with Oracle Support (MOS) for the support required, bugs encountered, etc.Offered a full time FTE position with Verizon for the consistent deliveries and contributions that I made to the Project.

Toronto, Ontario, Ca

Worked on Project#4 - RBC Capital Market's Business Intelligence and Analytics (Project Details here ☛ https://www.linkedin.com/in/starpageup#projects )• Participated in discussions with RBCs Technical SMEs and Analysts from different banking areas. Assessed and analyzed technical requirements; identified and delivered solutions meeting these requirements.• Modified OBIEE Repository (RPD) Data Models and Report designs.• Identified Code Migration and Deployment strategies and proposed Solutions.• Participated in all phases of testing (performance, integration, end-to-end, PIV, DR, etc.) and provided adequate support for QA (Problem Resolution, etc.).• Facilitated reviews/walkthroughs of code as well as test plans/results.• Managed Production and Non-Production Environments Implementations with use of Enterprise Change Management practices.• Performed Oracle BI 10g system upgrade to Oracle BI 11g. Upgraded and migrated the code. Performed system patching.• Implemented Security Model in the new 11g Environment.• Contributed to critical documentation required in the project and relevantly stored it in SharePoint/Confluence systems.• Proactively resolved conflicts and escalations.• Managed Change implementations and provided after hours support to the client (as needed).Provided 100%, error-free code deployments to Production Environment, even in case of large complex deployments.

Cambridge, Ma, Us

Involved in Project#3 - Biogen Idec BI Enablement (Project Details here ☛ https://www.linkedin.com/in/starpageup#projects )Involved in:• Analyzing client's existing Oracle BI and Business Objects Reporting systems.• Assessing existing Reports and Dashboards - Cataloguing these in a structured format on the basis of the columns used in the Reports.• Understanding existing Data Models in OBIEE RPD and BO Universe. Analyzing from Dimensional Modeling perspective and checking on anomalies like Fact to Fact joins, Cyclic Joins, Degree of Snow Flaking, redundant structures, etc.• Analyzing OBIEE Usage Data to understand most used and important reports.• Documenting findings.• Establishing approach to rationalize the identified Reports and providing estimates on time and complexity to perform this rationalization. Creating a Delivery Schedule.• Helping Project Managers to build consensus for Future State of the Client's BI Systems.

Rahway, New Jersey, Us

Worked on below two projects: Project#1 - Merck Global Human Health Business Intelligence and Analytics Project#2 - Merck Global Human Health Managed Development Services(Check details on these projects here ☛ https://www.linkedin.com/in/starpageup#projects )• Provided round the clock support. Team configured in Onsite, Offshore and Near Shore model.• Delivered to Business Requirements, fixing bugs, and dealing with how-to s related to Adhoc Reporting.• Reverse Engineered the system from Dashboards -> Database -> Informatica Mappings -> Source System to analyze the data issues.• Systematized Dual Schema Data Sync Architecture for the Data Warehouse for 24x7 high availability of the system.• Upgraded system from Oracle Database to Teradata for faster response times.• Upgraded system from Siebel Analytics 7.7 to OBIEE 10g.• Worked on supporting users on Siebel CRM Platform.• Acted as Lead Technical Analyst and SME for Data Warehousing systems. Part of the Core Team for Solutions Delivery.• Provided in-depth system analysis for global corporate initiatives and changes.• Adequately documented knowledge on systems characterized in form of Word Documents and stored on SharePoint for retention.Termed by Onsite Lead as 'I know my system is safe in your hands’. One of the client's lead enunciated that I adhere to understand their needs and requirements and deep dive to provide support across all stratas of IT.

Teaneck, New Jersey, Us

Cognizant Internal Training on Data Warehousing and Business Intelligence. Attained conceptual knowledge and Hands-on on various Enterprise Information Management Tools like• Informatica• IBM Cognos• Oracle Business Intelligence• IBM DataStage• SAP Business ObjectsFollowed by successful completion of extensive internal testing and practical demonstration of these concepts and tools.Promoted to Associate - Projects, having:• Worked with Cognizant for a total tenure of 5 years, engaged with 3 major clients in 4 big projects working in various capacities and project roles.• Received an Early Promotion to Associate - Projects Level, within 2 years of Joining as a Fresher to Cognizant, for contributions made in projects.• Highly appreciated by Project Managers, Senior Leadership, and fellow colleagues.• Presented two effective innovations which resulted in cost savings for clients. 1) Innovation on Automating User Management reducing support tickets 2) Innovation on Automatic Load Failure Alerting reducing continuous system monitoring.• Involved in timely status reporting across horizontal and vertical reporting structure. Managed work effectively and was also involved in co-curricular activities like corporate level initiative like Ops Clarity within Cognizant.

Technical Development and Support of Client's VB .Net Application. Development of modules like Payroll, Legal and Advisory, etc. Supervising Client's Operations Team on application usage and driving the business.

Bachelor’S Degree, Computer Software Engineering

High School

High School