KRANTHI EDLA

+1-979-***-**** • ad4tpg@r.postjobfree.com • linkedin.com/in/kranthikedla

WORK EXPERIENCE

Professional Profile

Highly motivated IT professional, with over 16 years of experience in BI/ Data Visualization/ Data Analytics, providing consulting services and implementing projects. Experienced in leading, motivating, bringing strong leadership qualities, equally comfortable working on own initiative. Possesses exemplary technical problem solving and negotiation skills and accustomed to delivering results under considerable pressure, remaining calm and effective and prioritizing wisely.

Clients

Westfield Specialty, CDW, Janssen, CSL, Bayer Pharmaceuticals, Blink Health, Mizuho Americas, Sun Pharmaceuticals, Guardian Life Insurance, Credit-Suisse, Walt Disney World, Standard & Poor’s, Capital One

Skills

Data Visualizations Design & Implementation, Visual Analytics, Self-service Analytics, Report Design & Development, Installation, Configuration & Maintenance of Reporting Environments, Data Warehouse/Data Mart Design & Implementation, Data Modelling, Business Analysis, Leading/ Managing teams, Project Planning & Management.

Westfield Specialty, NJ (Mar 2023 – Present)

BI Architect

• Design visualization templates for Enterprise Analytics.

• Architect the Design and development of various dashboards for multiple LOBs.

• Analyze multiple sources, design and maintain Tableau data sources for analytics.

• Manage the scope of projects and a team carrying various reporting deliverables.

• Collaborate with business leads, including C-suite, to understand reporting needs and provide solutions for measuring KPIs and gaining insights.

Environment: Tableau Cloud, Tableau Desktop, Snowflake, AWS, SQL Server

Amnet Digital, NJ (June 2022 – Dec 2022)

Technical Lead – BI

• Work closely with senior management to set the expectations for seamless migration effort and data gaps.

• Visualize sales data, partner data, HR data sourcing from different systems to cater Data Visualizations and Reports.

• Manage team of 12 that comprises of Data Analysts and BI developers to deliver various projects.

• Plan project scope and adhere to the timelines for deliverables.

• Data Analysis, Data discovery, GAP Analysis for migrating multiple projects.

Environment: Power BI, Cognos, MS BI Suite, Azure, SQL Server

Axtria, Berkley Heights, NJ (Oct 2021- May 2022)

BI Lead

• Manage team for supporting marketing digital processing Operations.

• Help senior management with drawing insights on data operations & infra costs.

• Visualize sales data, digital & social media, website, print media, paid search data, data quality checks for all data deliverables for various vendors.

• Coordinate On-boarding of new deliverables into MDP data lake and provided data extracts to multiple downstream teams.

Environment: Tableau, AWS, Amazon Redshift, HDFS, Hive, Power BI, Talend

Bayer Pharmaceuticals, Whippany, NJ (May 2020 – Sep 2021)

Data Visualizations Expert

• Designed Tableau visualizations for market access reporting to replace the existing third-party application.

• Helped senior management and business with tracking key metrics by creating visuals, dashboards and reports.

• Built and managed dashboards with key metrics for digital marketing campaign’s holistic view.

• Oversaw various workstreams in Cyrus reporting platform for new development and maintenance of data visualizations.

• Enhanced the presentations for QBR meetings by simplifying and making the dashboards seamless and tell a story.

Environment: Tableau, HDFS, AWS, Amazon Redshift, Snowflake, Power BI, Talend

Blink Health, New York, NY (Aug 2019 – Apr 2020)

Architect - Data Visualizations

• Helped executives and senior management with tracking weekly business performance metrics by creating various reports and dashboards.

• Provided solutions to different product owners to track key metrics.

• Delivered financial reporting for invoicing different pharma partners and internal/ external auditing purposes.

• Created data feeds to external pharma partners for operations reporting and ad-hoc analysis saving $16,000 quarterly.

• Designed and developed LookML projects/explores in Looker for e-commerce ad-hoc analysis and reporting.

Environment: Looker, AWS, Amazon QuickSight, Tableau, G-Suite, Amazon Redshift, Amazon Athena, Python, MySQL

Mizuho Americas, New York, NY (Oct 2018 – Aug 2019)

Senior Tableau Consultant

• Implemented data visualizations for senior market and credit risk executives to monitor daily/monthly risks across all business entities resulting in $200,000 annually.

• Headed the analysis, design and implementation of Tableau infrastructure, which now serves as an analytics platform for all departments within the bank.

• Chaired various reporting initiatives to support Americas risk management team, including sourcing of disparate data sources, data validation and automation of legacy manual reports.

• Liaison between technology and risk for gathering reporting requirements, and converting the requirements into technical specifications.

Environment: Tableau 10.3, SQL Server 2014, Windows 2016 Server

Sun Pharmaceuticals, NY (Jan 2017 – Sep 2018)

BI Consultant – Tableau

• Helped C-suite in analyzing sales operations metrics by creating executive dashboards to track KPIs.

• Built in-house analytic solution to save $1M for the organization on market research.

• Conducted source data analysis, performed data profiling and synthesized data for developing visuals.

• Managed and delivered projects; owning all deliverables against timelines.

• Authored documents for business requirements and transformed them to technical specs and trained users using Tableau at different levels.

Environment: Tableau 10, Cognos, Oracle 11g, SAP BW, Windows 2012 Server

Guardian Life Insurance Company, New York, NY (May 2015 – Dec 2016)

BI Lead

• Headed multiple teams for new initiatives, enhancements and support of BI in corporate office of technology.

• Engineered automation process for various report batch runs for daily client reports.

• Interacted with business users to understand their requirements, analyzing the available data to build Tableau dashboards.

• Created rich dashboards, visually telling stories of the business status, agents’ performance, strength & weakness.

• Built universes and Created auditing reports for various purposes like user activity, query performance and debugged several data issues using Informatica mappings & sessions.

Environment: Tableau 9, SAP BO BI 4.1, Business Objects XI 3.1, Informatica 9.6, Oracle 11g, IBM DB2 9.7, SQL Server 2008, Windows 2012 Server

Credit Suisse, New York, NY (Jan 2012 – April 2015)

Sr. Consultant - Business Intelligence

• Designed and developed reporting platform for market risk space; led a global team and ensured timely deliverables.

• Reconciled the reporting to a more strategic and transparent platform and met regulators requirements.

• Synthesized the data and developed reports/ visuals for C-level executives using Tableau.

• Trained users in creating Tableau worksheets and visualizations to help them do their own ad-hoc analysis.

• Evaluated the two data visualization tools Tableau and QlikView

• Provided support for Users creating report schedules, data connections, projects and groups in Tableau server.

Environment: SAP BO BI 4.1, Business Objects XI 3.1, Tableau 8, Oracle 11g, PL/SQL Developer, OBIEE 11g, Oracle SQL Developer

Cognilytics, New York, NY (Apr 2011 – Dec 2011)

Sr. Business Intelligence Consultant

• Developed a product called ‘Navigator Suite’ which has content-rich dashboards & scorecards for mortgage portfolio managers.

• Used multi-value components like line charts, bar charts, stacked column charts and combination charts, and single-value components like gauge, slider, dial and progress bars in the development of the dashboards.

• Incorporated new Xcelsius components like print button, connection refresh button, reset button, and trend Icon.

• Validated data by writing scripts (stored procedures) for the visuals used in the product.

Environment: Business Objects XI 3.1, SQL Server 2008, QAAWS, Xcelsius 2008, Windows 7, Windows 2008 Server.

Credit-Suisse, New York, NY (Mar 2010 – Mar 2011)

Business Intelligence Tech Lead

• Led a global team and Involved in the design of a data warehouse and data mart for post-trade for cash securities product, settlements & trading, sales support user groups.

• Designed, developed & documented new Universes and created reports using Web Intelligence Rich client.

• Conducted POCs to ensure technical feasibility of visual representation of data.

• Designed, documented & developed dashboards using Xcelsius using QaaWS

Environment: Business Objects XI 3.1, Oracle 10g, Rapid SQL, Informatica 8.6, TOAD 8.5, Crystal Reports 2008, QAAWS, Crystal Xcelsius 2008, Window XP, Windows 2003 Server.

Disney World, Orlando, FL (Apr 2009 – Feb 2010)

Sr. Business Intelligence Consultant

• Design and implementation of $8M business Intelligence and Data Warehousing solution for the merchandise line of business as part of a $40+ M Oracle Retek implementation.

• End to end design of the solution and the delivery of 150+ operational, tactical and strategic reports, visuals/ dashboards, and the foundation for advanced analytics.

• Built complex reports using multiple data providers and extensively used OpenDoc to call child reports from parent reports.

Environment: Business Objects XI R3.1, BO SAP Integration Kit, IIS, Oracle 10g, Teradata, SAP BW, TOAD 8.5, Crystal Reports XI, Crystal Xcelsius 2008, Quality Center 9.2, Window XP, Windows 2003 Server.

Standard & Poor’s, New York, NY (Jun 2008 – Feb 2009)

Business Objects Administrator/ Migration Specialist

• Conducted meetings for implementing a standard architecture for deploying Business Objects across the organization.

• Migrated various applications from 5.1 & 6.5 to XI R2 and provided support to new environment.

• Configured servers in XI R2 for development, test and production environments and created group structure

• Recreated complete security model in XI R2 at enterprise level.

• Trained users in basic & advanced reporting functionalities, creating ad-hoc reports for analysis.

Environment: Business Objects 5.1, 6.5 & XI R2, Web Intelligence, Desktop Intelligence, TOAD, Oracle 10g, MS SQL Server 2005, SQL, PL/SQL, Windows Server 2003, AIX

Capital One Auto Finance, Dallas, TX (May 2007 – May 2008)

Business Objects Administrator

• Installed and configured Business Objects XIR2 and applied subsequent patches.

• Configured Central Management Server (CMS) Cluster, Created CMS, PM and Audit databases

• Managed security, report scheduling, users, user groups, servers and server group administration.

• Automated bulk report scheduling using APOS InfoScheduler.

Environment: Business Objects XI R2, Crystal Enterprise XI/X, SQL Server 2005, Oracle, Web Intelligence XI R2, Windows Server 2003

Jackson State University, Jackson, MS (Aug 2005 – Mar 2007)

Reports Analyst & Web Developer

• Maintained orders, inventory reporting for the Department of Biology.

• Expenses reporting for research fellows, balance sheets of federal grants for various research initiatives.

• Developed website of student organizations and student publications, designed & managed content for various articles.

• Published newsletters and magazine content for various events.

Environment: MySQL, PHP, HTML, CSS, Flash, Macromedia Dream viewer, Adobe Photoshop, Windows, Mac OS

EDUCATION

Master’s in Computer Science, Jackson State University, Jackson, MS

B. Tech in Computer Science & Information Technology, JNTU, INDIA

SKILLS

Databases: Amazon Redshift, Snowflake, Athena, Oracle 9i/10g/11g, SQL Server 2000/2005/2008/2012, Teradata v2r6, DB2

Analysis: SQL, Python

BI Tools: Tableau, Looker, SAP BO BI 4.0/4.1, Business Objects (6.X/XI R1/R2, XI 3.0/3.1), SAP BO Analysis, Crystal Reports XI/2008/2013, Xcelsius 4.5/2008, Informatica 9.1/9.6

Query Tools: Data Grip, Postico, TOAD, Teradata SQL Assistant, Rapid SQL, PL/SQL Developer, Oracle SQL Developer

Modeling Tools: VISIO, Erwin

Web Development: MySQL, PHP, HTML, CSS, Flash, Macromedia Dreamweaver, Adobe Photoshop

Contact this candidate