Home

Rajini Natarajan - Sr BI/Data Analyst

[email protected]

Location: San Ramon, California, USA

Relocation: Remote/Hybrid

Visa: H4 EAD

Rajini Natarajan Mobile: 510-269-8097 E-mail: [email protected] Summary Over 15+ years of IT experience in Software Development, Business Intelligence, Data Analysis and Business System Analytics. Worked on Tableau Desktop, Tableau Server, Tableau Reader, Tableau Online and Tableau Prep. Acquired Tableau Desktop Specialist Certification in April 2019. Have excellent data visualization skills in creating rich dashboards/charts/stories for data analysis to deliver business insights, to identify customer behaviors and business health. In depth knowledge in Tableau advance analysis features like set, parameters, LOD calculations, clustering, forecasting and dashboard actions Also built interactive dashboards using technique like guided analytics and visual best practices provided by Tableau. Worked extensively on joining tables, multiple data connections using cross database joins /data blending, worked on data extracts, and managing queries. Created rich dashboards and prepared user stories to create compelling dashboards/stories to deliver actionable insights. Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with sites, providing access to the users, and adding them to the specific groups and projects, scheduling refreshes and subscriptions in Tableau Server. Worked extensively on server side with compliance focus to control the permissions as needed by implementing user level filters. Strong experience in writing complex analytical SQL queries, re-factor the existing code to improve the craftsmanship and worked on performance tuning. Experience in documenting business requirements and business solutions to solve problems and issues related to business operations. Worked on building end to end ETL solution to build the required aggregates and metrics for powering the reporting layer with CRM integration. Solid exposure to Data Warehousing and Data marts concepts. Also having good understanding of various DWH schema designs (Star Schema and Snowflake schemas). Partner with data engineering partners to facilitate access to key data and ensure data quality. Extensive knowledge of Software Development Life Cycle (SDLC), Methodologies (Waterfall/Agile). Experience in connecting different data sources like SQL, Oracle, Snowflake, Hive, ProgreSQL, Google Big query, Amazon Redshift, Flat files & Excel files. Expertise in preparing code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications, etc. Having strong analytical, logical, communication and problem-solving skills. Ability to adapt to new technologies by self-learning. Skills Reporting Tools: Tableau 2022.1, 2021.1.x, 2020.1.2, 2019.1.2,9/10,2018.1.3, MicroStrategy 8.x, 9.x Databases: Oracle, DB2, MySQL, MSSQL, AWS Redshift, PostgreSQL ETL: Talend, Informatica Cloud Technology: Google cloud Hadoop Stack: Hive/Presto CRM Tools: Workday Languages: C, C++, Python Microsoft Suite: MS Access, PowerPoint, Excel, Word Scripting: Unix Shell scripting Platforms: Linux, Windows Tools: HP Quality Center, JIRA, Office Tools, Visio, SharePoint, Mode, Alation Git, Confluence, Jira Experience Sr Business Intelligence Developer/Business Data Analyst Feb 2022 Present Lyft, SFO (Remote) Worked with various executive, product management, engineering, finance, logistics, sales, and marketing teams. Enabled decision-making by conducting analyses from multiple sources to present research in a digestible and actionable format. Work closely with Data Engineers on the team to identify data sources, build scalable data models, and operationalize the data analytics. Have strong experience in building dashboards in any of the BI platforms, strong experience in writing SQL queries to understand and build dashboards/reports as per the user request. Analyze large data sets using a variety of query and visualization tools (Tableau/Mode). Perform data analysis, design and development of new and ongoing business intelligence (BI) tool (Tableau) involving complex Data structures. Provide technical design, coding, testing, implementation, maintenance, system and technical support for BI initiatives. Conduct and participate in code walkthroughs and document technical design. Assist in Quality Control testing. Troubleshoot and solve technical problems. Follow the release cycles and implement on-time delivery of bug fixes, change requests and enhancements. Monitor Dashboard Reporting and Presentation Layer functioning and performance and pro-actively fix issues as found. Support the performance of systems. Provide technical expertise in integrating and analyzing critical data. Clearly communicate any potential discrepancies and/or reporting downtime, including specific root cause, steps to resolution, and resolution date to a large end-user base. Work with subject matter experts to document and translate business requirements into technical requirements. Manage multiple projects and proactively communicates issues, priorities, and objectives. Business Intelligence Developer/Business Data Analyst June 2021 Jan 2022 Morgan Stanley, New York (Remote) Worked on AML Transaction Monitoring System infrastructure. Experience working with cloud data repository services such as AWS redshift. Work with the source team to understand existing security data and then create visually compelling and accurate security reports and dashboards for historical data trend analysis, and identification of opportunities to drive continuous process improvement. Created dynamic and interactive Tableau dashboards using best practices to effectively solve business problems by enabling business insights and making recommendations. Completed POC to migrate the dashboards from legacy DB2 systems to Hadoop hive data stack. Expert in data extraction using analytical SQL. Have strong analytic skill in data analysis to identify data patterns and root causes of data issues. Experience in performing data analysis/data mapping using Hive database. Expertise in design and development of Ad-hoc, Drill down/ Drill through reports, cascading, list reports, crosstabs, charts, and interactive dashboards. Developed various analytical reports from multiple data sources by blending data on a single dashboard. Worked directly with executives, data engineers and analysts when it comes to defining metrics, crafting solutions, and providing insights. Worked extensively on MSSQL/Hadoop migration projects. Worked on agile methodology. (On a ~6 months break due to Covid situation Dec 2020 to May 2021) Business Intelligence Engineer Sep 2019 Nov 2020 AAA, Walnut Creek, California Worked on Tableau Financial reports infrastructure automation. Collaborate with Business development teams and other business analysts in planning, prioritization, design, development, and deployment of new projects & system enhancements. Immense knowledge on analyzing Workday data and derived meaningful business metrics. Extensively worked on transforming the static tableau dashboards to dynamic with multiple filters conditions/parameters/set. Incorporated the best practices in data visualization and data source optimization to create useful/effective/interactive dashboards. Engage with stakeholders to gather requirements, involved in development/testing, and productionize new dashboards to drive actionable insights. Experience in writing and optimizing SQL queries for reporting purposes. Experience working with various data sources to include Relational Big databases/Datasets. Experience in data analysis and in improving the performance of existing dashboards. Support ad-hoc analysis and data requests to provide insights to executive leaders. Solid exposure to Data Warehousing and Data marts concepts. Also having good understanding of various DWH schema designs (Star Schema and Snowflake schemas). Design and build scalable data pipelines across data warehouses (Oracle DWH) using SQL to efficiently maintain historical data and to easily access the data for analysis and reporting. Worked extensively on Oracle SQL/GCP migration, Excel, JIRA, Confluence, and dashboard performance tuning. Business Intelligence Developer Nov 2018 Sep 2019 Kforce, CA Worked with Product managers and Stake holders to understand requirements, layout, and look and feel of the dashboard to be developed. Instrumental in building trust and relationship with business partners and executives. Executed fast paced and dynamic projects in a highly organized manner on a tight schedule. Combined views and reports into interactive dashboards in Tableau Desktop. Build tools/dashboards to automate reporting and generate insights that will allow business leaders to quickly and accurately see how our products and processes are performing. Work with the business to process requirements and convert them into meaningful reports as well as be able to train and communicate the reports to the business stakeholders. Report a suite of KPIs (key performance indicators) to leadership on weekly, monthly, and quarterly cadences - providing context and recommendations around opportunities and threats to the business. Hands on with Tableau Desktop (dashboard creation, report authoring and troubleshooting, data source management). Involved in process improvement and code artifacts. Build interactive filters, parameters, and calculations for preparing dashboards and worksheets in Tableau. Strong experience in writing complex Oracle SQL queries. Worked extensively on SQL, Excel, Data Warehousing and Tableau. Involved in migration task from MSTR to Tableau reporting. Business Intelligence Developer. Nov 2017 Oct 2018 MZ, CA Worked with Product managers and Stake holders to understand requirements, layout, and look and feel of the dashboard to be developed. Instrumental in building trust and relationship with business partners and executives. Executed fast paced and dynamic projects in a highly organized manner on a tight schedule. Combined views and reports into interactive dashboards in Tableau Desktop. Build tools/dashboards to automate reporting and generate insights that will allow business leaders to quickly and accurately see how our products and processes are performing. Work with the business to process requirements and convert them into meaningful reports as well as be able to train and communicate the reports to the business stakeholders. Report a suite of KPIs (key performance indicators) to leadership on weekly, monthly, and quarterly cadences - providing context and recommendations around opportunities and threats to the business. Hands on with Tableau Desktop (dashboard creation, report authoring and troubleshooting, data source management). Involved in process improvement and code artifacts. Build interactive filters, parameters, and calculations for preparing dashboards and worksheets in Tableau. Strong experience in writing complex Oracle SQL queries. Worked extensively on SQL, Excel, Data Warehousing and Tableau. Involved in migration task from MSTR to Tableau reporting. Business Intelligence Developer/Data Analyst May 2010 Dec 2013 IBM, Bangalore, India Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Business Intelligence life cycle. Established deep partnerships with business owners to identify BI needs for the business and evangelize existing solutions or develop new solutions appropriately. Defined system level block diagram depicting data sources and data flows. Involved in design, build, maintenance and deployment of reports, dashboards in tableau. Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Strong experience in writing complex Oracle SQL queries. Have work experience in collaborating with on-shore and off-shore team members. Worked closely with cross team IT team and ETL team for various Data sources issues. Exceptional analytical skills and attention to detail, with an ability to quickly grasp technical details. Senior Developer Sep 2008 to Apr 2010 ITC Infotech, Bangalore India Involved in analysis, design, maintenance, and execution of the project. Generating reports and documentation for the clients. Experience with SQL queries, profiling, and data quality management functions. Handling booking, amendment, closure, or cancellation of guarantee. Providing interfacing services to other system within the bank. Developed end to end new modules for implementing newer features in the application. Sr. Software Engineer Nov 2006 Aug 2008 Computer Science Corporation, Chennai India Extensive experience on new feature development, addressing production issues and mainly contributed on major data migration project [Mainframe VSAM system to Oracle database]. Leaded the data migration effort end to end. Extensively worked on complex SQL queries to deliver adhoc reports to business team. Assisted customers for UAT, created roll out plans and identified training needs. Software Engineer. Mar 2004 Oct 2006 Cognizant Technology Solutions, Chennai India Extensively worked on new feature developments using COBOL/JCL/CICS and DB2. Production support experience in handling mission critical systems. Automated regular production job flows using EASYTRIEVE. Education Bachelor of Engineering. 1998 2002 Keywords: cprogramm cplusplus business intelligence active directory information technology hewlett packard microsoft California