Rani Samyuktha

Dallas, TX ad4yt8@r.postjobfree.com +1-302-***-****

Tech Lead

Profile

Over 13 years of experience in Information Technology and a wide range of progressive experience in providing product

specifications, design, analysis, Project Management, development,

coding and implementation of the business technology solutions.

Industries: Healthcare, Medical Products, Food, Retail Functional Areas: Information Technology Methodologies: Agile, Waterfall, Project Management

Employment History

Digital Solutions Consultant Lead Consultant at NTT DATA, INC. (formerly Dell Services Inc.), Dallas

April 2011 — Present

Data Analyst/Report Developer at BCBSNC

April 2023 — October 2023

•Validated data and ETL jobs as part of Teradata to Snowflake Migration.

•Re-created and Validated Tableau reports pointing to both Teradata and Snowflake.

•Updated Abnitio jobs that failed during the migration.

Details Dallas TX United States

Skills

Business Intelligence BI Reporting

Cognos

Tableau (Business Intelligence Software)

QlikView (Data Analytics Software)

Enterprise Report Management (ERM)

Power BI

Analytics

•Created thorough documentation for migration, data validations

and report validations.

Environment: Tableau, Abnitio, Business Objects, SAS, Alteryx

Development/Production Support Lead at BCBS ARIZONA (AZBLUE)

May 2021 — March 2023

BCBS Arizona (called as AZBlue) is an Insurance company based in Arizona. Worked as both Development Lead and Production Support Lead in various applications including BI, EDW, API, etc.

•Developed Account, Member and Claim Hubs for data coming from various sources HRP, EDW, etc. and generated Guiding Care Reports

•Scheduled Nightly and Micro Batches and was responsible for monitoring.

•Created Splunk Alerts for Hubs jobs to avoid manual monitoring.

•Transitioned and Supported various Applications in Production Environment.

•Created POCs for the Finance team to help in decision making.

•Provided Executives with analytics and decision-support tools used as the basis for reorganization, consolidation and relocation strategies.

Data Warehousing

SQL (Programming Language)

Netezza

WhereScape

Scrum (Software Development)

JIRA

ServiceNow Microsoft Office

Extract Transform Load (ETL) Informatica

Extensible Markup Language (XML)

•Collaborated with Stakeholder groups across the organization

to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

•Ran scrums, conducted meetings, coordinated between Business & team members and prepared task lists for various projects in the team.

•Created thorough Documentation like Requirements, Run Books, etc. for support activities.

•Monitor, assign and work on tickets in the order of priority from Business and ensure no SLA breaches.

•Investigate and work with DBAs to increase performance of the Nightly and Micro Batch process to avoid delays.

•Ensure work-life balance by coordinating between Business and team members at onsite and different offshore locations.

•Played the Lead and Managed the onsite and offshore team.

•Ability to manage multiple tasks concurrently and meet the deadlines.

Environment: WhereScape RED, API, SQL Server, DevOps, Active Batch, SharePoint, MS Project.

Business Analyst at MEDIFAST

September 2020 — February 2021

Medifast, Inc. is an American nutrition and weight loss company based in Baltimore, Maryland. Medifast produces, distributes, and sells weight loss and health-related products through websites, multi-level marketing, telemarketing, and franchised weight loss clinics.

•Develop Business Architecture using Requirements such as Scope, Processes, Alternatives and Risks.

•Analyze Client's Business Requirements and Processes through Document Analysis, Interviews, Workshops and Workflow analysis.

•Conduct 5+ levels of testing including Functional, Regression, User Acceptance, Integration and Performance to verify the client's needs are met.

•Communicate Client's Requirements by constructing easy-to-understand data and process models.

•Identify and Reconcile errors in client data to ensure accurate Business Requirements.

•Draft and Maintain business requirements and align them with Functional and Technical Requirements.

•Responsible for running scrum and make sure Jira and Confluence are being updated on a regular basis.

•Manage and work with offshore team for on-time deliverables.

Environment: Mulesoft, Tableau, RedShift, RingCentral, Tealium, SocketLabs, Jira, Confluence, MS Project.

Data Security

Application Programming Interface (API)

Production Support

Agile Software Development Operating Systems

Business Requirements Technical Communication Effective Time Management Communication Skills Adaptability

Project Management

Ability to Work in a Team Functional Requirement Healthcare Services Information Technology Managing Client Expectations

Languages

English

BI Admin/Analyst at AVMED

September 2018 — August 2020

AvMed is an Insurance company based in Florida. Over 50 years, their mission has been to help their members live healthier by providing them with Quality, Cost-Effective plans and Excellent Member Services. Worked as a BI Admin and Lead on the KTLO team.

•Gathered Requirements, Created TAW and Reports based on different End User Requirements.

•Negotiate and liaise between Business, Technology, Development and Support Teams.

•Good understanding of Technical trends, architectures and highly motivated to know more about latest technology, new software and products.

•Provided Executives with analytics and decision-support tools used as the basis for reorganization, consolidation and relocation strategies.

•Collaborated with Stakeholder groups across the organization

to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

•Successfully documented, coordinated and upgraded all Servers from Windows 2008 to Windows 2012 and 2016.

•Ran scrums, conducted meetings, coordinated between Business & team members and prepared task lists for various projects in the team.

•Successfully coordinated and completed the Data Center and Exadata move from Miami to Plano.

•Performed maintenance on Dev, Test and Prod Servers on a regular basis.

•Responsible for Deployments, Catalog Refreshes, Data Security, Configuring the applications and other Admin activities including providing access, train Business users on BI applications, etc.

•Created thorough Documentation like SOP's, Run Books, etc. for support activities.

•Monitor, assign and work on tickets in the order of priority from Business and ensure no SLA breaches.

•Investigate and work with DBAs to increase performance of the Nightly Incremental process to avoid delays.

•Ensure work-life balance by coordinating between Business and team members at onsite and different offshore locations.

•Played the Lead and Managed the onsite and offshore team.

•Ability to handle multiple tasks concurrently and meet the deadlines.

•Team player with good communication and interpersonal skills. Responsible for interacting with Business Partners to help identify information needs and business requirements for reports.

Environment: OBIEE 11.1, Oracle 18c, ServiceNow, ODI 1 1g, QlikView 11.20, QlikSense 13.9.3

BI Analyst at CONVATEC HEALTHCARE PRODUCTS

January 2018 — August 2018

ConvaTec Group is an international medical products and technologies company, offering products and services in the areas of wound and skin care, ostomy care, continence and critical care and infusion devices. In this project, we created and built an Enterprise Data Warehouse solution for all ConvaTec's Sales, Gross Margin and Revenue. Also, provided the End Users with Power BI Dashboards to report different measures in the Company.

•Created Business Requirements Document by gathering requirements from End Users.

•Worked with Users and Stakeholders to analyze and validate Requirements.

•Negotiate and liaise between Business, Technology and Support Teams.

•Created Source to Target Mapping Documents for Landing, Staging and Integration Layers.

•Identified Key Performance Indicators to be reported on the Dashboard.

•Extracted and Loaded the Landing tables from SAP to SQL Server using ABAP Extract in Data Stage.

•Manually profiled the tables using a query to ensure the data is correct and transformed as per the client requirement.

•Involved as primary on-site ETL Developer during the analysis, planning, design, development and implementation stages of project.

•Prepared Data Mapping Documents and Design the ETL jobs based on DMD with required tables in Dev Environment.

•Used Data Stage as an ETL tool to extract data from Source Systems, loaded the data into SQL Server Database.

•Created detailed Test Cases, Test Sets and executed them manually.

•Managing the Client expectations, both technical & communication, and explaining them to offshore team.

•Designed, Developed and Deployed Business Intelligence Applications.

Environment: Power BI 2.61, SAP, SQL Server 12, Data Stage 11.3

BI Specialist/ Analyst at TENET HEALTH CARE, Dallas

October 2017 — January 2018

Tenet Healthcare Corporation is a multinational investor-owned healthcare services company based in Dallas, Texas. Worked as a Business Analyst for the Meaningful Use Project.

•Served Customers and Businesses by running and viewing reports. • Execute and Validate test cases.

•Responsible for Specifications, Implementations and Analytics.

•Worked with Business Intelligence and Data Warehousing tools.

•Identify root causes and corrective actions to meet short and long-term deliverables.

Environment: Cognos 10.1, Netezza, Jira, Data Stage 11.3

Software Dev Advisor at TEMPURSEALY

May 2017 — July 2017

Tempur Sealy International, Inc. is an American Manufacturer of Mattresses and Bedding products. It was formed when Tempur-Pedic International, a manufacturer of memory foam mattresses acquired its biggest competitor Sealy Corporation in 2012 and is based in Lexington, Kentucky. In this Project, I was responsible to create SSIS Packages to load the tables.

•Gathered Requirements and inputs from users to provide them with a better solution.

•Translated requirements from the Business and Analyst into technical code.

•Designed, Built and Deployed effective SSIS packages.

•Provide support and fix issues in the packages.

Environment: SQL Server, SQL Server BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), .Net

Software Dev Advisor/Report Developer at TENET HEALTH CARE, Dallas

January 2015 — April 2017

Tenet Healthcare Corporation is a multinational investor-owned healthcare services company based in Dallas, Texas. In this project, we provided and implemented the solution of archiving the data of Vanguard Hospitals which Tenet acquired.

•Gathered, Analyzed and Documented the Requirements from End Users to provide them with the Output they were expecting.

•Migrate and ensure correctness of data from Source to Target Databases.

•Created POC for the Executive Dashboard in Tableau and converted existing Cognos Reports to Tableau Dashboards.

•Created Proof of Concepts and Mock-up Reports to give the End Users a glance of what they will be seeing.

•Ability to design and deploy rich Graphic Visualizations with Drill Down and Drop-down menu options and Parameters using Tableau.

•Created different KPI using calculated key figures and parameters. • Create Role Based access to the users on Solix and ensure the data is accessed by approved and required business users.

•Created Reports from Tables, Stored Procedures and Views in Solix APM.

•Converted Crystal Reports – Converted SQL Server Procedures to MySQL Procedures.

•Responsible to provide resolutions for production incidents/failures and user requests.

Environment: Tableau 10, Solix EDMS 6.5, Solix APM, SQL Server 2000/2005, MySQL, Oracle 1 1g, Netezza 7.0

Report Developer/Business Analyst at TENET HEALTH CARE, Dallas

April 2011 — December 2014

Tenet Healthcare Corporation is a multinational investor-owned healthcare services company based in Dallas, Texas. In the Meaningful Use Project, we provided Tenet with end-to-end solution for electrizing Patient Data and report on several measures, to help Tenet improve Patient Care and Quality.

•Involved in Requirements Gathering and Specification writing after interacting with Business Users, Line of Business Requirements and other Stake Holders.

•Worked with Project Managers, Business Analyst and End Users to understand business requirements and translated them into the Technical Specifications.

•Designed Cognos Framework Manager Model with different views (Database View, Business View, Presentation View) using Oracle 1 1g as per Business Users Requirements.

•Involved in Data Modelling by creating/updating Logical Entity Relational Model (ERM) and published Packages using Framework Manager.

•Worked on Cognos Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages.

•Implemented Framework Manager Security for Data Access, Object level access and Package access.

•Implemented Stored Procedure Query Subject in Cognos Framework Manager.

•Using Cognos Report Studio, created various complex List Reports, Grouped Reports, Crosstab Reports, Chart Reports, and Drill-Through Reports for Mobile and iPad Applications.

•Developed Reports with Multiple Cognos Viewers and with multiple Cognos Reports developed Complex Reports, Dashboards for Mobile and iPad Report Applications.

•Applied OLAP functionalities such as drill-down/drill-up in Analysis Studio and Report Studio.

•Customized data by adding number of Prompts, Filters, Calculations, Summaries and Functions.

•Developed Complex Reports using Crosstab having different calculations, data items and Customized Page Formatting.

•To improve functionality and performance created Cubes in Transformers and defined data items in Cubes before publishing.

•Wrote test scripts and queries for reports and cubes to verify data against the database.

•Trained users to make their own ad-hoc reports using Cognos Query Studio.

Environment: Cognos 8.4 & 10.1.1 (Framework Manager, Report Studio, Query Studio), Cognos PowerPlay Transformers, Cognos iPhone/iPad Reports, Oracle 1 1g, TOAD 8.6, Netezza 7.0, Data Stage, Windows 7

SAXON GLOBAL INC., Dallas

July 2010 — April 2011

Report Developer at DOLE FRESH VEGETABLES, Monterey Bay

November 2010 — March 2011

Dole Food Company, Inc. is an American agricultural multinational corporation headquartered in Westlake Village, California. The company is the largest producer of fruit and vegetables in the world. In this Project, we reported the Sales, Produce and Revenue of the company.

•Developed List, Crosstab, drill through and complex reports which involved multi-queries.

•Interacting with End Users on a regular basis for resolving issues pertaining to reports.

•Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.

•Designed and Developed the Framework Manager models from different data sources and published into server.

•Developed reports using system Development Kit (SDK) by java scripts at the backend.

•Created multi-dimensional cubes in Cognos Transformer using Impromptu Query Definition (IQD) generated from Cognos Framework Manager.

•Created ad-hoc report using Cognos Query Studio and SQL reports using Cognos Report Studio.

Environment: Cognos 8.4/8.3 (Framework Manager, Report Studio, Query Studio, Metric Studio, Event Studio, Power play Transformers), Oracle 10g, Informatica 7.1.2, MS Excel 2003, SQL Server 2005, Windows XP

Report Developer at GameStop, Dallas

July 2010 — October 2010

GameStop Corp. is an American Video Game, Consumer Electronics and Wireless Services Retailer. The company is headquartered in

Grapevine, Texas. In this Project, we created Dashboards and Reports for Sales and Inventory Management.

•Worked in building Relational models and multi-dimensional packages and published packages to Cognos Connection using Framework Manager and created daily, weekly and monthly reports using those packages.

•Implemented Security with LDAP and Group level security in Cognos Connection Portal.

•Creation of Procedures, Views, Tables and Functions per business requirements in SQL Server.

•Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.

•Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.

•Created different types of reports like List, Crosstab, Chart, Drill-Thru, Master Details, Cascading using different prompts.

•Created Drill Through reports and Conditional Formatting by using Report Studio.

•Developed Prompt Pages and Conditional Variables.

•Production Support which involves solving user problems.

Environment : Cognos 8.4 (Report Studio, Analysis Studio, Framework Manager, Query Studio), Oracle 9i, SSIS, Data Stage, Microsoft SQL Server 2005/2008.

Education

Master of Science, The University of Arizona, Tucson

August 2008 — May 2010

Graduated with Master's Degree

Bachelor of Technology, Acharya Nagarjuna University, Guntur

September 2004 — April 2008

Graduated with a Bachelor's Degree

Contact this candidate