Shilpa Bharadwaja

• Primary point of contact for client personnel and stakeholders to provide daily status on critical jobs during open enrollment, understand user requests and oversee delivery of deliverables. • Worked as Tier1 level support to actively work on issues, processing/loading claim data approximately 1 billion dollars daily transactions. • Analysed and presented resource forecasting to Management from both confirmed opportunities as well as the opportunities in pipeline. • Skilled in communicating and interacting effectively verbally and in writing with all levels of management. • Communicate with customers and prospective clients on a daily basis to build and establish long lasting relationships and grow new business. • Cross-sold reporting services to Client - CVS Caremark through consultative sales to automate reporting environment, thereby expanding Genpact’s footprint and growing the revenue by $ 4.5M through implementation and support services.

• Chaired weekly managerial meetings to explain strategic reports illustrating $1M+ in revenue growth and to help formulate strategies to forecast and project department profits of $500K+. Handled meetings to resolve tactical, strategic revenue related concerns for Contract Management team of Crown Castle • Resolved up to 60 user issues per week and provided reporting environment support. Coordinated with third party vendors when necessary and facilitated problem resolution with optimum speed and efficiency • Worked closely with business and management teams to understand data and reporting needs, to elicit and document business requirements, and to develop strategic reporting solutions • Developed more than 40 IBM Cognos complex reports with drill through functionality, conditional formatting. Created 12 dashboards for various functional Managers and other end users. Designed custom views to illustrate process results or summaries of large sets of data by interpreting sources of data and deviation • Established and monitored security to control end user data access in reporting environment • Identified shortcomings of current reporting environment and recommended top management on migration to newer version of IBM Cognos. Provided management with multiple Star Schema data warehouse designs. • Designed and presented datamart design using IBM Cognos Framework Manager. • Trained user groups on designing quick and easy reports in Query Studio and Analysis Studio without developer intervention. Build well-managed data solutions, tools, and capabilities to enable self-service frameworks for data consumers • Established data analysis with strong SQL capabilities • Followed Agile Methodologies and Ceremonies like Sprint Retrospective, Grooming, Stand Up Meetings • Ensured program/project teams are following Crown Castle Data Quality standards

• Achieved good Client reviews and Client offered IBM Cognos project extension and revenue generation of up to $300K for Newton Consulting through meticulous and attention to detail project management skills. • Trained ~15 user groups on designing quick and easy reports in Query Studio and Analysis Studio without IT intervention. Built data solutions, tools, and capabilities to enable self-service frameworks for data consumers • Involved in designing DMR models using IBM Cognos Framework Manager and deployed packages to the Report Servers. • Implemented Framework Manager security for data access, object level access and package access based on the Organization Security Levels. • SME of data models with relational databases, OLTP and OLAP • Fulfilled ad hoc report requests and designed scalable reports. Performed data analysis for users using Analysis Studio. Designed OLAP Cubes using IBM Cube Transformer • Designed and built planning models and applications using IBM Cognos 8 Planning - Contributor Administrator. Managed administrator responsibilities which included Application Deployment, GTP process, table publish and incremental publish

• Analyzed existing client system, created Proof of Concept (POC), presented POC to clients and offered robust reporting environment • Handled complete end to end responsibilities from recognizing data sources, designing metadata models in IBM Cognos Framework Manager, reports design in IBM Report Studio to reports execution • Designed complex reports consisting of calculations, drill through functionalities, and charts in Cognos Report Studio • Worked extensively on report schedules, performance tuning, and bursting • Provided efficient OLAP framework structure for client to enable easy self-service adhoc reports creation. Established data analysis, data profiling responsibilites with strong SQL capabilities. • Followed Agile software development methodology while working with Siemens Energy. Scrum Meetings during all the phases of the project integrated releases

• Gathered business requirements. Designed, developed and maintained reporting environment at PNC Bank using Qlikview Enterprise BI Suite • Developed improvised reports, designed scorecards and dashboards by collaborating data from various sources in Qlikview Enterprise BI tool • Extracted the data from various sources like DB2, UDB, Flatfiles and COBOL files using Informatica and loaded into target SQL Server database. • Derived the incremental extraction and load logic for each target table (SCD Type1, Type 2 and Type 3) and fact tables based on the source data.

Masters in Computer Applications