Data Analyst Architect

SARAVANAN RANGANATHAN

PROFESSIONAL SUMMARY

Seasoned Enterprise Data Architect, Data Analyst, Data Integration Lead, Engineering, Developer with proven track records in delivering successful business application systems in Health Care, Automotive, Life Sciences, Technology and Salesforce and Banking Depository Sectors.

• Having 18+ years of IT experience, 10+ years of ETL experience, 5+ years of BI reporting experience

• Exceptionally skilled in understanding complex business problems and deconstructing them

• Work closely with all business areas/stakeholders to capture BI (Business Intelligence) requirements based on business objectives, initiatives, challenges, and questions in a simple and engaging way, whilst making insightful recommendations

• Strong prioritization and multi-tasking skills with a track record of meeting deadlines

• Document the requirements, technical solutions, prepare design documents, test documents to trace the requirements. Translate user stories into wireframe designs of the dashboards

• Load data from multiple data sources including ingest, transform, clean, shape data using various ETL tools SSIS, Power Query (Power BI), Informatica, Alteryx, Kalido

• Create scalable Data/ETL and Power BI solution architectures. Design and build business intelligence in an effective, automated, and reliable way. Establish data level security and object level security

• Apply dimensional, fact data modelling concepts and practices to develop conceptual, logical, and physical data models (star schema and snowflake models) including creating relationships

• Create and maintenance of extracts, different visuals, KPI, reports, dashboards, paginated reports, DAX patterns, write complex DAX to solve business requirements

• Automate the data loads, refreshes using schedules, delivering large complex Data Integration and Data Modernization projects aligning with IT roadmap.

• Excellent communication, mentoring skills. Involve Capacity estimation and planning Relevant Skills: Dashboards Data Analytics Data Integration Development Solution Architecture Engineering

Modeling Automation

Areas of Expertise: BI Reporting Technology Transformation Database Development ETL Cloud Legacy Modernization Enterprise Data Analyst Data Analytics BI Architect Technical Lead SME Business development Technical Expertise: SSIS, SSRS, MS Power BI, Informatica, Alteryx, SQL Server, SSMS, Oracle, DB2, SQL, T-SQL, PL-SQL, Power Query, DAX, Excel Analytics, Azure SQL, Azure Synapse Analytics, Azure Data Factory, Azure Data Bricks, Shell Scripting, Batch Scripting, Visual Studio, TOAD, PL/SQL Developer, SSAS, Kalido, Informatica Cloud, Autosys, Qlikview, Lavastorm, Python, SQL* Loader, SVN, Azure DevOps, GIT, ERWin, SilverRun, Rational Rose, Visio, HTML, ASP, Cold Fusion, VB Script, Java, C/ C++, COBOL, Designer/Developer 2000, Visual Basic PROFESSIONAL EXPERIENCE & PERSONAL DETAILS

Cognizant Technology Solutions (USA/India): 18+ Years – 09/13/2004 thru till date LinkedIn: https://www.linkedin.com/in/saravanan-ranganathan/ Personal Email id: ************@*****.***

Mobile Number: +1-201-***-****

Green Card Holder

EDUCATION AND CERTIFICATIONS/COURSES

Master of Computer Applications, Bharathidasan University, India

Bachelor of Science (Physics), Madras University, India

Microsoft Certified: Power BI Data Analyst Associate (PL-300) – Jan 2023

Microsoft Certified: Azure AI Fundamentals (AI 900) – August 2021

Microsoft Certified: Azure Data Fundamentals (DP 900) – July 2021

Microsoft Certified: Azure Fundamentals (AZ 900) – July 2021

OCP Certification - Oracle 9i SQL/Admin I and II

Oracle 9i DBA course - SQL Star International Ltd SARAVANAN RANGANATHAN ************@*****.*** +1-201-***-**** PROJECTS EXPERIENCE

HEDIS-ClaimSphere Data Integration/Claims Reporting: Sr Data Analyst/Tech Lead/Developer Apr 2020 – Till Date Technologies: SQL Server, SSIS, SSRS, Power BI, Autosys/Tidal scheduling

Closely work with a range of stakeholders to ensure business requirements are fully understood and document the requirements.

Analyze user requirements, based on findings, design functional specifications

Provide end to end data solution to ingest data from various data sources using ELT/ETL

Perform ingest, transform, clean, shape data, data modeling, visualize and analyze data using different data sources including csv, text, excel, other files, databases, data flows, SharePoint, etc.

Use Power query (M language) to perform transform and load data.

Design, develop, optimize, maintain and support ETL processes and reports using Stored Procedures, queries using Microsoft SSIS, SSRS and Power BI

Create and manage 30-40 data models by creating star schema and snowflake schema models & create required relationships

Create parameter, date tables to perform full load and incremental data loads, store database names, etc.

Write complex DAX queries using various functions including aggregate, filter, date & time, logical, financial, text, relationship, hierarchy, and time intelligence functions. Write Semi additive measures

Create/Manage dashboards, reports, workspaces based on data loads, claims, etc.

Using DAX patterns and simply subbing in parameters and core measures to speed up Power BI development which can be reused on multiple reports/dashboards

Analyze Power BI performance by identifying and locating any bottlenecks using Query diagnostics and Performance Analyzer

Create static, dynamic roles to implement object level and row level security

Publish the reports, dashboards to workspaces. Customize themes for report pages, dashboards

Create and manage deployment pipelines

Create and manage scheduled data refreshes

Provided solution to load 1TB of data (including historical) loads from converting IBM mainframe data into SQL Server tables using SSIS.

Creation, maintenance of ETL code, SSIS packages, SSRS reports, stored procedures, user defined functions, SQL scripts, views, tables, etc.

Involved to fine-tune SQL queries with better performance

Worked on conversion of SSRS reports to Power BI reports

Created incremental load process or on demand load process to consume the data on regular basis

Converted the EBCDIC data conversion into ASCII by writing user defined functions.

Interpreted data, analyzed results using statistical techniques.

Created SQL server agent/Autosys jobs to automatic the end-to-end solutions

Automate the deployment scripts using Azure DevOps, TFS, GIT repo, Pipelines, releases, etc. One View/Operational Performance Reports: Data Engineer/Analyst/ETL Architect Oct 2019 – Apr 2020 Technologies: Alteryx, Informatica Power Center, SSIS, SQL Server, Oracle 11g, AWS, Power-BI

Work closely with all business areas/stakeholders to capture BI (Business Intelligence) requirements Interpreted data, analyzed results using statistical techniques.

Provided end to end data solution to ingest data from various data sources using ELT/ETL

Developed and implemented data analysis, data collection systems and other strategies that statistical efficiency and quality.

Design and map data models to shift raw data into meaningful insights.

Created/managed 10-20 data models

Built automated interactive reports and dashboards and publish the reports to Power Bi Service

Wrote DAX queries and functions in Power BI

Identified different improvement areas and innovations to minimize the manual efforts, automate the activities. Supplied technical expertise on data storage structures, and data cleansing.

Creation/maintenance of ETL, SSIS packages, reports, dashboards, stored procedures, functions, SQL scripts, views, tables, etc.

SARAVANAN RANGANATHAN ************@*****.*** +1-201-***-**** Commercial Data Warehouses: Data/ETL Architect/Lead/Analyst Feb 2015 – Sep 2019 Technologies: Kalido DIW, Kalido MDM, SSIS, Informatica Power Center, Informatica Cloud, SQL Server 2014, Oracle 11g, Lavastorm, MS Power BI, QlikView 12.

Managed Datawarehouse databases/applications

Creation/maintenance, and deployment of SSIS packages, reports, dashboards, ETL Code, Stored procedures, Functions, scripts, views, tables, etc.

Create/maintain/monitor databases, create logins, users, etc.

Gather business requirements in the BI context and design data models to convert raw data to meaningful insights.

Create and manage dashboards and visual interactive reports using Power BI.

Identify KPIs with clear objectives and monitor them consistently.

Perform design, develop, and deploy Power BI scripts and perform efficient detailed analysis.

Perform DAX queries and functions in Power BI.

Create charts and document data with algorithms, parameters, models, and relations explanations.

Perform SQL querying for best results.

Disability Specific Enhancements: ETL Developer/Senior Developer/Data Analyst Feb 2014 – Dec 2014 Technologies: Mainframes, PL/SQL, Oracle 10g, SQL Server, DB2, Java.

Written stored procedures, packages, scripts, and tuned Queries.

Involved in different SDLC phases like Analysis, Design, Coding, Testing, UAT testing

Responsible for requirement gathering; identifying requirements.

Responsible for reviewing the effort estimations and share it with stakeholders. Adverse Drug Event Product: Technical (Database) Lead/Sr. Developer Nov 2008 – Dec 2013 Technologies: PL/SQL, Oracle 10g, SQL Server, SSIS, SharePoint, PHP, ASP, cold fusion

Managed & Led Managed Services support team

Written PL/SQL packages, stored procedures, functions, views, tables, etc.

Involved in different SDLC phases like Analysis, Design, Coding, Testing, UAT testing

Maintained all latest database changes in ER-Diagrams using Rational Rose SFDC/eSPN/ CDSL, DPOnline and eBroking: Database Architect/Sr. Developer/Developer Jun 1999 – Nov 2008 Technologies: PL/SQL, Oracle 9i, .Net framework, Designer 9i.

Involved the entire logical and physical data model with 50+ tables in the initial development of SFDC Project by using ERWin / Designer 9i Tools by applying different normalization methods and the tables created in oracle using forward engineering.

Created PL/SQL packages, stored procedures for reporting purpose using temporary tables for the modules: Demat, Remat, Account Transfer, etc.

Created sequences, synonyms, triggers, and other database objects. Performed Tuning on SQL Queries

Contact this candidate