Home

saranya - powerbi developer

[email protected]

Location: Dallas, Texas, USA

Relocation: any

Visa: h1b

Name : Saranya Durairaj Email : [email protected] Mobile: 804-859-4635 LinkedIn ID: www.linkedin.com/in/saranya-durairaj Summary 13 years of IT experience with exposure to various BI reporting tools, 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. Integrated Snowflake data warehouse with Power BI to create interactive and visually appealing dashboards, enabling stakeholders to gain actionable insights from complex datasets. Integrated the data warehouse with business intelligence (BI) tools such as Power BI, Tableau, and OBIEE enabling users to derive insights and generate reports from centralized, curated data. In-depth understanding and experience with Microsoft BI stack such as Power Pivot, SSIS, SSRS, and SSAS. Proficient in SQL, SAS, and Python for data manipulation and analysis. Worked in different data sources like Snowflake, Oracle DaaS, and SQL Server. Hands-on experience in delivering Data Governance and Data Quality Management concepts and practices within the financial services industry. 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 Good knowledge of AWS Analytics Services and Database Services. 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: Microsoft Certified: Power BI Data Analyst Associate Microsoft Certified: Azure Fundamentals Oracle Database SQL Certified Associate Certification. Core Expertise: Power BI | OBIEE | Crystal Reports | SQL | PL SQL Stored Procedures | 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: Senior Data Analyst Virtuous Tech, Frisco (TX, USA) Oct 2023 Present Client: Fannie Mae Project: Enterprise Application Renewal (EAR) 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. Developed and implemented SSIS packages to extract, transform, and load (ETL) data from heterogeneous sources into the Power BI data model, ensuring data consistency and integrity. Installed and configured Enterprise gateway in Power bi service. Used Power Query for Data transformations and 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, implemented partitions in Tabular Models for Power BI. Wrote Time Intelligence 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. Developed SQL scripts to test the report output against DB results. Published Power BI Reports in the required originations and Made Power BI Dashboards available to Web clients. Environment/Tools: Windows 11, Power BI Desktop, Power BI Online, ORACLE 19c, Microsoft SQL DB Lead Consultant Virtusa, Kuala Lumpur (Malaysia) Dec 2018 May 2022 Client: Standard Chartered Bank Project: Documentary Trade Port Report Generation (DTP RG) Responsibilities: Developed and deployed SSAS tabular or multidimensional models to provide a semantic layer for Power BI, enabling users to perform complex analytical queries and calculations. Created data models as per the report requirement which involves analyzing the set of tables from SQL Server, Oracle and Snowflake tables in identifying the keys and relationship for report development. Evaluate Power BI features for business requirements and proposed report designs in Power BI to Business users. Implemented row-level security within Power BI to restrict access to sensitive data based on user roles and permissions defined in Snowflake. Developed ETL processes using tools like Informatica, Talend, or custom scripts, ensuring accurate and timely data integration from heterogeneous sources into the data warehouse. Generated Dashboards from Power BI service and provided business user access at workspace level. Demonstrated expertise in leveraging DAX functions to perform complex calculations, such as SUMX, CALCULATE, AVERAGE, and RELATED, for data analysis and modeling purposes. Developed DAX measures and calculated columns to derive insights and KPIs (Key Performance Indicators) from raw data, driving informed decision-making for stakeholders. Developed and designed paginated reports in Power BI Report Builder/SSRS reports to meet specific business requirements, including pixel-perfect layouts and complex data visualizations. Published Power BI dashboards into Power BI service and implemented RLS. Implemented data visualization best practices in Power BI, including proper use of chart types, color schemes, and labeling to enhance the clarity and readability of reports. Worked directly with business users and business analysts to prepare SQL scripts for ad-hoc reporting requirements. Environment/Tools: Linux, Windows 2010/2007, ORACLE 11g, Power BI, OBIEE, SQL, SAP BO CMC, VB, Windows Batch script, Linux shell script, DevOps GIT Bash, Jenkins, SFTP, CFT Consultant Capgemini, Selangor (Malaysia) Sep 2015 Jul 2017 Client: Standard Chartered Bank Project: COCOA Trade Reporting Responsibilities: Analyzed the data and developed a logical star schema model with consultation from Data modelers and business analysts. Developed ETL processes using tools like Informatica, Talend, or custom scripts, ensuring accurate and timely data integration from heterogeneous sources into the data warehouse. 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. Utilized DAX to create hierarchies, time intelligence functions, and custom aggregations to enhance data visualization and analysis capabilities for Power BI reports. Ensured consistency in visualization design across reports and dashboards, maintaining brand standards and user expectations for visual presentation. Environment/Tools: Linux, Windows 2010/2007, ORACLE 11g, OBIEE, SQL, Oracle PL/SQL Associate Cognizant, Chennai (India) Nov 2013 Jul 2015 Client: Landmark, Agilent Technologies Project: OBIEE Upgrade from 11.1.1.6.0 to 11.1.1.7.1 and OBIEE migration from 10g to 11g Responsibilities: 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. Environment/Tools: AIX, Windows 2007, Linux, Windows XP, ORACLE 11g, OBIEE 11g, SQL IT Analyst Tata Consultancy Services, Chennai (India) May 2011 Nov 2013 Client: Standard Chartered Bank Project: Securities Target Operating Model (STORM II Reporting) Responsibilities: 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 BA. 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/reports with drilldowns, guided navigations, filters, 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. Environment/Tools: Linux, Windows XP, ORACLE 11g, OBIEE 11g, BI Publisher, PL/SQL Sr. Programmer Analyst AON-Hewitt, Chennai (India) Sep 2008 Apr 2011 Client: YSA Clients from North America Project: Yours Spending Account (YSA) Responsibilities: Client data received via EFT (Electronic File Transfer) in the Mainframe generational datasets. SAS programs will be written to reformat these data as required. Created Analysis along with some CODE SNIPPETS to aid in the programmer. Depending on the plans that the clients have enrolled in we distinguish the participant data via SAS programs that involves querying DB2 data as well via SQL queries. Some of the plans that include are Wired Commute plan for Transportation and Parking reimbursements, Tuition and Adoption Plans, Contribution plans for Health and dependent care that are most familiar with US citizens. Environment/Tools: Mainframe, DB2, JCL, SAS, and SQL Education Degree / Specialization - Bachelor of Engineering / Electronics and Communication Engineering University - Anna University Year 2007 Keywords: business analyst business intelligence database active directory information technology microsoft procedural language Idaho Texas