Home

Sarany - Data Analyst

[email protected]

Location: Texas City, Texas, USA

Relocation: Open

Visa: H1B

Summary 13 years of IT experience with exposure to various BI reporting tools, including ETL, data modeling, scheduling, and transfer of reports. Designed and implemented object-based and data-level securities in Power BI and OBIEE dashboards for business users. Designed various pictorial representations of reports in Power BI, OBIEE Answers and BI Publisher. Strong knowledge of Data modelling, DB Tools, and concepts. Hands-on experience in ETL, data ingestion tools. Fair knowledge of fine-tuning the queries for optimum performance. Have good knowledge in the Banking domain and worked in various Banking Finance products such as Finance Documentary Trade Port (DTP), Commodities Control Application (COCOA), TCS BaNCS. Strategized in different SDLC and Agile phases, involved in requirement gathering, analyzing, and documenting business and technical requirements, development, testing, implementation, and L3 support. Worked in agile model deliverables and participated in all phases of Agile meetings, used Scrum / Kanban board. Closely worked with SIT, UAT, and PSS teams for successful module releases. Expertise in job scheduler tools like Control-M and Windows Task Scheduler to automate and schedule batch jobs as per the requirements. Efficiently implemented File Transfer Protocols such as SFTP, and CFT (Axway Cross File Transfer) to securely transfer the files/reports from one server to another. Hands-on knowledge in version control tools like Git Bash / Jenkins and DevOps Basic understanding of Cloud concepts and certified with Azure Fundamentals. Hands-on experience in Production Change Management process. Technological Skillset Reporting Tools: Power BI, OBIEE, BI Publisher, SAP BO Crystal Reports, Basic SAS ETL Tool: Talend Open Studio Database: Oracle 11g Query interfaces: Oracle PL/SQL Developer, SQL Developer Other Software: Control-M, MS Visual Studio, Putty, Git Bash, DevOps, MS PowerPoint, MS Word, MS Excel Operating Systems: Linux, Windows Methodologies: Agile and Waterfall model. Certifications: Edureka Certified: Business Analyst using Power BI Microsoft Certified: Azure Fundamentals Microsoft Certified Technology Specialist: .NET Framework 2.0 Windows Applications Microsoft Certified Technology Specialist: .NET Framework 2.0 Web Applications Oracle Database SQL Certified Associate Certification. Core Expertise: Power BI | OBIEE | OBIEE Repository Data Modeling | OBIEE Dashboard Designing and Securities Implementation | Oracle DB |SAP BO CMC | SAP BO Web Intelligence | Crystal Reports | SQL | PL SQL Stored Procedures | SQL Performance Tuning | Talend ETL | SFTP | JIRA | DevOps Tools Bitbucket, Jenkins, Git Bash, Artifactory, Auto Deployment | Control-M | Axway Cross File Transfer (CFT) | Windows Batch Scripting | Windows Task Scheduler | Visual Studio | Disaster Recovery Planning | AZURE Fundamentals and Cloud Concepts | Base SAS | JCL | Mainframe | DB2 Work Experience: Projects Handled in VIRTUOUS TECH Project Title Enterprise Application Renewal (EAR) Duration Oct 2023 Present Role: Power BI Reports Developer Responsibilities : Created Power BI Sample Report to demonstrate Outline Solution for Business Team. Imported Data into Power BI using Direct/ Live Query based on Table size and created lookup tables to maintain Relationship Utilized DAX queries to Modify data and to created new columns and Measures Installed and configured Enterprise gateway in Power bi service. Used Power Query for Data transformations. Used M-query language in Power Query. Worked on all types of transformations that are available in Power bi query editor Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI. Wrote DAX expressions to create new measures, calculations per business requirements. Effectively used data blending, filters, actions, and hierarchies feature in Power BI. Analyzed the data using Statistical features in Power BI to develop trend analysis. Published the developed dashboard, reports on the Power BI Services so that the end- users can view the data. Successfully integrated custom visuals based on business requirements in Power BI desktop. Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards. Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, and Logical, information, Text, and date functions in source data. Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards. Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients. Operating System Windows 11 Database ORACLE 19c, Microsoft SQL DB Language & Tools Power BI Desktop, Power BI Online Location Frisco, Texas Projects Handled in VIRTUSA Project Title Documentary Trade Port Report Generation (DTP RG) OBIEE, Power BI Client Standard Chartered Bank GBS Malaysia Duration Dec 2018 May 2022 Description The DTP RG project involves report design and development for trade operations users in 44 countries. Application data is received from the mainframe system as flat files and uploaded to Oracle DAAS DB tables which act as a reporting source. Role : Lead Consultant Requirement gathering from BA or Country trade ops user directly. Development of ETL (Talend), OBIEE Reports, Scheduling Reports, and File transfer scripts. End to End implementation from Requirement gathering, Development, Unit Testing, SIT, UAT, Regression testing support, Production Implementation support, and User verification Testing support. Evaluate Power BI features for business requirements Propose report designs in Power BI and discuss with Business users Worked on Power query editor to prepare data Worked on Power BI modeling to define joins and cardinality Worked on multiple relations and many-to-many relationships in Power BI Worked on Multiact, multi-grain scenarios in Power BI Implemented DAX functions for various fact calculations for efficient data visualization in Power BI Developed reports and dashboards in Power BI Desktop Developed Dynamic Tooltip Visual, Drill Down, Drill through in Power BI Published Power BI dashboards into Power BI service and developed reports Worked on Row-level Security (RLS) and controlled access in Power BI Created Apps, scheduled refresh, incremental refresh in Power BI Highlights Supporting end-to-end throughout the project life cycle thereby gaining complete knowledge of the project. Supporting multiple projects from different trade applications. Operating System Linux, Windows 2010, Windows 2007 Database ORACLE 11g Language & Tools Power BI, OBIEE, SQL, SAP BO CMC, VB, Windows Batch script, Linux shell script, DevOps GIT Bash, Jenkins, SFTP, CFT Location SCB Global Business Solutions (GBS), Malaysia Projects Handled in CAPGEMINI Project Title COCOA Trade Reporting OBIEE Client Standard Chartered Bank GBS Malaysia Duration Sep 2015 Jul 2017 Description The COCOA Trade Reporting project involves reports & dashboard development for COCOA banking applications to keep track of client data & bank performance in the Trading finance sector. Role: Lead Consultant Worked during the whole life cycle of the project from requirement gathering to deployment. Analyzed the data and developed a logical star schema model with consultation from Data modelers and business analysts. Developed metadata repository using OBIEE Administration Tool in Physical, Business Model and Mapping, and Presentation Layer. Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per business requirements. Developed Time series objects using Ago and To Date functions for time series comparisons. Designed and developed various interactive dashboards and reports with drilldowns, guided navigations, filters, and prompts. Worked towards performance tuning of dashboards and reports with Business Analysts and DBAs. Integrated BI Publisher with OBIEE to build reports in Word and doc format. Highlights Supporting end-to-end throughout the project life cycle thereby gaining complete knowledge of the project. Supporting multiple projects from different trade applications. Operating System Linux, Windows 2010, Windows 2007 Database ORACLE 11g Language & Tools OBIEE, SQL, Oracle PL/SQL Location SCB Global Business Solutions (GBS), Malaysia Projects Handled in COGNIZANT Project Title: Landmark Retail Application OBIEE Upgrade from 11.1.1.6.0 to 11.1.1.7.1 Agilent BI Divestiture OBIEE migration from 10g to 11g Client: Landmark Group, Dubai Agilent Technologies, USA Duration Nov 20, 2013 Jul 17,2015 Description: Landmark Retail Application project involved out-of-place upgrade of their existing OBIEE 11.1.1.6.0 to 11.1.1.7.1. Agilent BI Divestiture project involved the migration of OBIEE applications from 10g to 11g along with backend data split, the company is being split into 2 different entities: Agilent and Keysight. Role Associate Worked during the whole life cycle of the project from requirement gathering to deployment. Analyzed the data and developed a logical star schema model with consultation from Data modelers and business analysts. Developed metadata repository using OBIEE Administration Tool in Physical, Business Model and Mapping, and Presentation Layer. Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per business requirements. Developed Time series objects using Ago and To Date functions for time series comparisons. Designed and developed various interactive dashboards and reports with drilldowns, guided navigations, filters, and prompts. Worked towards performance tuning of dashboards and reports with Business Analysts and DBAs. Integrated BI Publisher with OBIEE to build reports in Word and doc format. As a key member of this project, involved in end-to-end project activities like installation, Configuration, Administration, and Defect fixes during SIT & UAT. Worked closely with ORACLE on the SRs which were part of product/upgrade issues. Highlights : Installation and configuration were challenging parts as it was in AIX OS where software-only installation was carried out. The major challenge faced in this project was renaming the USER folders in the catalog as we changed the LDAP which was used in 10g. The way users log into the 11g application was different from the 10g application which was the reason for renaming USER folders. Operating System AIX, Windows 2007 Linux, Windows XP Database ORACLE 11g Language & Tools OBIEE 11g, SQL Location Cognizant Technology Solutions, Chennai Projects Handled in TCS Project Title Securities Target Operating Model (STORM II Reporting) OBIEE 11g Reporting Client Standard Chartered Bank, Singapore Duration May 04, 2011 Nov 15, 2013 Description TCS-owned custodian services tool NCS was migrated to BaNCS which is the source for the STORM II Reporting application using OBIEE 11g STORM II reporting application acted as a near real-time system for most of the modules and PL/SQL procedures have been used as an ETL for a couple of modules. Role IT Analyst Requirement analysis, Design, and development of the RPD/report/Dashboards/BI Publisher. Supported SIT/UAT/UVT support during go-live for various countries that have gone LIVE. Performance Tuning for long-running report queries. Highlights Explored BI Publisher and created a few complex reports like Invoice Printing. Received client appreciation award for completing some complex reports in BI Publisher. Operating System Linux, Windows XP Database ORACLE 11g Language & Tools OBIEE 11g, BI Publisher, PL/SQL Location Tata Consultancy Services, Chennai Keywords: business analyst business intelligence database information technology golang microsoft procedural language