Project Management Business Intelligence

VIJAYALAKSHMI K.S

****.**********@*****.*** +1-929-***-**** Fremont, CA, 94538

Information Architect / Project Leader / Data Modeler Accomplished Information Architect & Technical Leader with 15 years of IT expertise in Data Warehousing with functional knowledge of ETL & BI concepts. Profound knowledge of Architecture design, Dimension Modelling, Data Mapping, ETL & BI design. Gained experience in the project management aspects, led cross-functional & cross-border teams in designing scalable solutions, engaged in creating proposals, ready build DWH solutions to suit any manufacturing industry. Adept in requirement gathering, interaction with stakeholders, aligning technology solutions with business objectives. Carried out projects in Banking (Bank of America, Lloyds Bank, Citibank, Merrill Lynch), Retail and Manufacturing sectors. CORE COMPETENCIES

Designing DWH solutions – Expertise in gathering requirements, Architecture Design, Data Analysis, High level design documentation, Dimension Modelling, Data Mapping, ETL & BI Design, Development, Technical support, Business Intelligence reporting, dashboard, Mining

& predication analysis.

Cloud based architecture – Enriched knowledge on Azure, AWS and hybrid architectures, Hands-on experience in Azure Devops, solutioning the ETL pipelines using cloud-based ETL tools like Azure Data Factory, Azure Synapse Analytics and data visualization using Power BI.

Data Modelling – Strong knowledge in designing efficient data models using Erwin, Power designer, depicting the business relationships in facilitating communication among the stakeholders.

Project Management & Agile Methodologies – Performed Agile, Scrum, best practices in DWH projects. Handled project planning in Azure DevOps, facilitated Scrum events, Monthly

& Quarterly business reviews

Data Integration – Experience in accomplishing complex data integration & transformations using DataStage, Informatica, SSIS & open-source tool Pentaho.

Business Intelligence & Reporting – Experience with Business Objects, Hyperion, Cognos, SSAS & SSRS, Power BI, Open-source tools Jaspersoft, QlikView to generate business insights, KPIs and analytical dashboards.

Security & Compliance – Knowledge of Data Governance policies, Data Audit & Retention Strategies, Data Quality standards, Meta-Data driven approach. KEY ACHIEVEMENTS

Led Data Analytics Platform – Spearheaded Fast Track Data Engineering teams in different time zone, solutioning and effective project planning to achieve customer success

Designed Scalable Data Model – Designed Authorized Data Store (ADS) model, organizes data from multiple systems of record while enabling faster data management, improved performance, better scalability, while minimizing redundancy & complexity. VIJAYALAKSHMI K.S

****.**********@*****.*** +1-929-***-**** Fremont, CA, 94538

Implemented the architecture design & the migration approach – Architected the overall project plan and the approach in migrating the customers from legacy channels to SOC while keeping the ongoing business operations seamlessly.

Devised Hight level design specifications – Designed & Translated the business requirements into effective technical document, provided all relevant stakeholders with a bird’s eye view of the solution architecture and the design after implementation

Identified measurable Key Performance Indicators – Insight in discerning the KPI’s into achievable Lead, Lag indicators, and in turn converting into productive dashboards.

Business & Technical Stakeholder Alignment – Managed cross-functional teams and consulting engagements, driving successful cloud adoption, data-driven decision-making, and digital transformation initiatives.

TECHNICAL EXPERTISE

Cloud & Virtualization: Microsoft Azure Synapse Analytics, Azure Data Factory, AWS, VMware ETL Tools: DataStage, SSIS, Informatica

BI Tools: Business Objects, SSAS/SSRS, Cognos, Hyperion, Tableau, Power BI Open-Source Tools: MY SQL, Pentaho, Jaspersoft, BIRT, QlikView DevOps Tools: Microsoft Visual SourceSafe, Azure DevOps Database: SQL Server, Oracle, MS-Access, Teradata, DB2 Modelling Tools: MS Visio, Erwin, Power Designer, SQL Server Job Scheduling & Automation: SSMS, Azure DevOps Pipelines, Windows scheduler Database Mgmt. Tools: TOAD, SQL *Loader, Putty

Project Mgmt. Tools: Azure DevOps, Excel, Jira

Language(s): SQL, PL/SQL, Java, C, C++, ASP.Net, VB.Net, HTML, XML, COBOL PROFESSIONAL EXPERIENCE

Mind Bridges Technologies [Apr 2021 – Dec 2024]

Client: Microsoft, USA

Led the FastTrack Data Engineering team on the project objectives in achieving customer adoption & customer success for the M365 products purchased

Solutioning the FastTrack Analytic System with the ETL pipelines using Azure Data Factory, Azure Synapse Analytics, Power BI

Involved in PI planning, Effort estimation using DevOps, facilitating sprint planning & standups

Involved in creating efficient Data Models for the USAGE telemetry data across different segments

Addressing the quality issues and the inconsistent data arising from IDEAs through FastTrack Analytics platform

Optimized data models for performance, scalability, and flexibility, ensuring efficient query processing and response times.

VIJAYALAKSHMI K.S

****.**********@*****.*** +1-929-***-**** Fremont, CA, 94538

Conducted data profiling and analysis to identify optimization opportunities and implemented solutions to improve data quality and usability

Utilized Power BI to create interactive dashboards and reports for stakeholders, resulting in improved data visibility and actionable insights

Infosys Technologies, USA [Sep 2016 – Dec 2017]

Client: Bank of America, USA

Interacted with the business and the stakeholders in undertaking the objectives to create an enterprise view of the client (Authorized data store) which sources data from all systems of record.

Developed and maintained conceptual, logical, and physical data models to support BI reporting and analytics requirements.

Designed the artifacts to provide enterprise view of the client to the downstream, to perform due diligence on the client who were onboarded/refreshed to perform AML intelligence

Involved in GAP analysis, profiling the data and solution design

Prepared the high-level design and the mapping specifications

Designed T-SQL based queries to reconcile the data both daily & monthly from all deposit systems to validate the data sent downstream. The daily sends emails when discrepancy occurs, monthly matches the end of month balances

Designed Power BI reports to serve the operational reporting requirements for international payments. The reports catered the needs of corporate, commercial and public sector clients.

Collaborated with data engineers to automate workflows and optimize data loading processes, reducing manual effort and improving data timeliness Wipro [Aug 2011 – Mar 2016]

Client: Lloyds Banking Group, UK

Involved & led the teams on requirement gathering, gap analysis, estimation on PPI

Prepared the design approach of the module Operational Reconciliation

Involved in the overall project plan and the migration approach for SOC implementation

Involved in the preparation of the high-level design documents and mapping specifications

Designed a reusable component using RCP and schema methodology to ease the design of Operational Reconciliation

Undertook test cases and code level reviews, design walkthrough to the review panel

Identified the loading strategies and retention policies

Provision of weekly status updates of each tranche in SOC onboarding

Incorporated performance tuning methods to increase the jobs performance

Created best practices for the developers to build efficient jobs

Had experience of working as an SME in the portfolio Infosys [Jan 2011 – Aug 2011]

PepsiCo, USA

Designed the business model for the leading global food & beverage company to build the EDW

Prepared design documents to build the data stage job relevant to the design approach

Reviewed Data stage jobs and test cases

VIJAYALAKSHMI K.S

****.**********@*****.*** +1-929-***-**** Fremont, CA, 94538

Created operational reports using Power BI involving DAX calculations L&T Infotech [Jul 2005 – Dec 2010]

Client: VF Corporation, USA

Captured the business requirement and modeled the database design for B2B reporting

Designed the loading strategy of the dimension and fact tables related to sales, orders, shipments etc.

Provided technical guidance to the team, aided in Performance tuning and troubleshooting

Formulated the migration and the test plan

Created scalable Cognos reports sourced from SAP ODS and loaded into DB2

Involved in reconciling the Cognos reports versus SAP BW queries

Documenting the issue tracker with the business stakeholders Client: CITIBANK, Singapore

Understood the business requirement and designed the mapping documents for Star Schema which can support the end-users for decision-making

Designed and loaded the interim tables for cards, authorization, star schemas using data stage jobs. Data soured from mainframe flat files to DWH schema

Used stages like SCD, Remove Duplicates and many more

Created SQL scripts for star schema tables and DB sequences

Inserted data into one time dimension tables through oracle PL/SQL statements

Prepared test plans and tested the jobs through SQL queries Client: L & T Infotech

Understood the business requirement and identified the metrics with lead indicators

Led the delivery team in developing the solution & Architected the design

Prepared SRS, HLD, DLD, functional architecture, technical and report specifications

Designed the Dimension Model using Microsoft SQL Server suite and created the schema which involves multiple facts

Generated reports using SSRS & QlikView for project trend deviations.

Created alerts to project managers and delivery heads, an early warning signal via email and SMS about the threat during the project

Created prediction analysis & involved in showing demos to CEO’s & CFO’s

Managed Effort estimation and project management using PMP Client: HD SUPPLY, Florida, USA

Formulated, designed & developed the migration plan and the strategy in converting all DataStage jobs referring Teradata/SQL Server to Oracle and converting Teradata Bteq, MLOAD scripts to Oracle stored procedures and make all the projects up and running with Oracle as the backend

Used PL/SQL stored procedures to migrate data from Teradata to oracle for one-time dimensions and created partitions for the different lines of business

Created the inbound processing logic document and conducted walk through to the team and devised ETL development approach pulling data from FTP to staging & capturing deltas and developed the jobs for the same

VIJAYALAKSHMI K.S

****.**********@*****.*** +1-929-***-**** Fremont, CA, 94538

Used CRC technique for capturing the deltas and automated ETL jobs to load daily data feeds coming in from various business units and unit testing was done and conducted the pilot work of automated daily feed

Worked on profiling the data available from various business units and interacted with the offshore QA team to resolve the issues

Designed DFD, SDD, source to target mapping document and conducted design walkthrough to the team

Client: Roots Industries, India

Identified the KPI’s of certain functional units in the manufacturing domain

Collected the requirements about their ERP, database structures, head office & branch details, product hierarchy and customer relationships

Designed the dimensional models for the functional units like sales, production, inventory and finance

Prepared design specifications and developed jobs to extract the data, cleansing and transforming it. Aggregator, data conversion, script component, conditional split, slowly changing dimension, surrogate key generator, look up, transformer stages were used

SSIS jobs were designed to extract the parts, assemblies, work order details and queries were used to test the data

Developed SSRS Reports to show the part summary, assembly wise orders placed and the work order wise summary with prompts, pivots, list, crosstab, drill through reports and charts. Client: L&T Infotech, India

Designed the dimensional model to meet the objective attendance pattern of the employees

Identified the source systems that include OLEDB, Excel, MS Access and used transformations using SSIS involving Merge Join, Sort, Derived Column, Slowly Changing Dimension etc.

Developed truncate and load strategy for tables in the staging area for incremental data load and scheduled the packages using windows batch scripts

Developed the SSAS cubes using analysis services and built the hierarchies in the cube dimensions. Configurations were implemented on the cube

Design and develop the SSRS reports which include prompts, filters, hierarchies, highlighters for alerting the user and configurations in the report manager for web-based access EDUCATION & ACCOLADES

Master’s in computer applications – University of Madras, India – 2005

Microsoft Certified Professional

Oracle Certified Associate

IBM Datastage Certified

Received excellence award from Lloyds Banking Group

Contact this candidate