Krishnaveni Lakshmanaperumal

Business Systems /Data Analyst

Email: adktze@r.postjobfree.com

Ph: 510-***-****/ 408-***-****

Experience Summary

●Seeking a team-oriented environment that fosters professional development around Twenty Years of experience in IT, Data analysis, Data migration with strong technical, business analysis as Testing, Business Database Analyst, Development, Project Management, Lead, and support in Design, testing and development environments in Agile/ Scrum process environments.

●Hands on experience in BI in huge Data warehousing projects using Colibra Catalogue tools, Schema, RDBMS concepts, Normalizations, Data Partitioning via slices and dices of Data Warehouse and Data repository as per required multi-dimensional reporting purposes.

●Worked Customer Interactive data analysis from external sources via MonkeySurvey and Sprinkler tool and have worked on Data extract and for numerical data and statistical analysis for Business values

●Involved in Data Governance Team research for Data issues from overall Datagaps from Agile projects to track the Data sources and tracking Metadata and revisit and untangle the complex Data Chains

●Established and worked in Agile Story grooming, SPRINT planning sessions and discussions for solutions in daily stand meetings, template workshops with DMI team from Master Data Management system.

●Inbound and outbound architecture designing and reverse engineering and created Framework for complete Wellsfargo data by reverse engineering the source code and document the ETL transformations for all Source to Target Mappings until reaching actual System Of Record.

●Trained in Agile life cycle initially at Wells fargo and fortunate to work for challenging MDE environment for implementation of new innovative idea to remove multiple systems taking copies and transforming, instead to talk to one single server MDE and call from one single server for data quality, performance, removing all knots to avoid intermediate data traffics.

●Managing team and ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure when migrating from multiple source applications and work with their Technical and Business teams.

●Flexible in working in any ETL technologies and design for Data warehousing projects (Salesforce, SSRS, SQL, Python, Oracle, Crystal reports, ETL reporting tools for dashboards, Tableau, Oracle, TeraData, Workbench tool, Adapt etc)

●Reverse engineering and gathering ETL functionality, analysis of Scenario based ETL strategies, transformation rules and mapping data from source to target, queried the database using SQL queries for data mining, data analysis and data modeling.

●Designed Data mart and Data Warehouse using Star Schema & Snowflake Schema for implementing Decision Support Systems.Extensively worked and managed on Teradata, T-Sql, stored procedures, Triggers, cursors, functions, DTS packages.

●Domains for ETL Transformations on Revenue Management for Forecast analysis, Finance domains applicable for Banking, product retailing, Medical Domain for Shipping and order processing of product domains.

●Created Dashboards, Trend Analysis, Forecasting service and Profits complete data visualization and analysis to extend the capabilities of a Microsoft SQL Server 2005 Analysis Services cube.

●Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, ORACLE, TERADATA, flat files using connectors, tasks and transformations.

●Created Drill-through targets to another report using SQL Server 2005/2008 Reporting Services, SSIS and defined data source, data source views, dimensions, measures, hierarchies, attributes, calculation, actions, perspectives, translation, and security roles.

●Worked in reports involved in Regression and Functional Testing cycles for all datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

●Implemented using Tableau for data analysis, drag and drop qualities to view preview of Ad hoc data and reports.

Certifications :

Masters in Computer Science and Applications

Bachelors in Computer Science

California Life And Health Insurance Certified from California Department of Insurance

Microsoft Certified in Sql Server

Certified in Anti Money Laundering

Scrum trained and certified

Certified Computing Professional (CCP)

Technical Skills

SQL Server Tools

Enterprise Manager, Query Analyzer, Import & Export (DTS), Profiler, Report Services, Analysis Services

GUI

ASP.NET 2.0/1.x, ASP 3.0, VBScript, JavaScript, HTML, XML, XSLT, CSS, SOAP, UDDI, WSDL,UML2.0,VB.NET, AJAX,WSDL,.NET Framework 3.0, WCF,WPF, VBA,EPIC, JIRA

BI Tools

SFDC, PL/SQL, MS SQL,Teradata, Jitterbit,ER Studio, Crystal Reports 9.0, VSS 6.0,PVCS,JIRA, Cognos, Tableau Collibra, Apache tools

ETL Tools

Microsoft SQL Server DTS, Microsoft SQL Server 2005/2008 (SSIS, SSRS, SSAS), Abinitio

Databases

SQL Server,Aginity Netezza, MS Access 97/00/03, MySQL,DB2, Sybase, ORACLE, AQT, SOQL, SFDC,Hadoop, Teradata, Python

Domain Knowledge

Medical, Financial, Banking, Insurance, Health checks, Order processing.

Project Title: Data Services SR Projects, CAREWARE migration, Cricket Health Jan 2020 – Till Date

Client : Blue Shield, Oakland, CA

Data Services - Senior Business Data Analyst

Responsibilities:

●As Senior data analyst are being both analytical and abstract, As an effective analysis to troubleshoot and understand how best to extract imperfect data using tactics make the information as objective as possible and bringing together analysis, technology and business objectives to ensure that all the data they collect is used to achieve Business Goals and provide solution for growth in Business values.

●Involved from scratch to design, reverse engineer, Data Profiling, Gap Analysis, BRD vs Transformation rules documentations as per process, Data research for successful implementation of SR Challenging projects.

●Customer Interaction for Statistical Analysis for data received from external sources to have estimation and future planning figures for all Claims and survey feedback from Members and Providers using Collibra Catalogue tools for actual Statistics of Claim amounts from historical data repository.

●Use Statistical Techniques for hypothetical validation of data and interpretations for presenting to the Business Users / Data Governance team for Data Lineages and Data complexities using Apache to track the historical modifications.

●Involved in Data Governance Team research for Data issues from overall Datagaps from Agile projects to track the Data sources and tracking Metadata and revisit and untangle the complex Data Chains

●Implementation of data via Tableau Reports and Dashboards and Reverse engineering using Python scripts for all ETL rules.

●Incorporated solutions driven Complex SRs with all challenging tasks in research of historical data for COA,AID CODE,Sequoia CARD print /Medhok data extracts by capturing from Member,Claim, Provider Data population sourcing from multiple onion layers( RAWS_STG,BOR, BIS)

●To analyze and create transformation rules remove existing traffic and succeed to capture the complexities and support, guidance from experienced Subject Matter Expertise from BlueShield for existing ETL transformations and have robust way of implementing Customer Base Audience Population summary for all BSC and CARE1ST data to address all Data issues with all slices and dices to present to Data Governance team for data fixes.

●SCRUM process Agile meetings are day to day participations to share and gather and complete team efforts with all integration systems and facing all challenges to remodel and implement solutions for SR projects, support for PVM related BOR Datagaps and resolutions, Data migration from CAREWARE to Landmark via BOR Data layer.

●Created, managed, tracked STORIES in JIRA EPIC tools and discussions for solutions in daily stand meetings, template workshops with DMI team from Master Data management system.

●Technically strong to dig and have reverse engineering of the source code and document the ETL transformations for all Source to Target Mappings until reaching actual System Of Record for all needed scenarios.

●Solution driven techniques new innovative idea to remove multiple systems taking copies and transforming with complete team efforts communicating with Business, Technical Team, Data modeling team and Data Services team for data quality, performance, removing all knots to avoid intermediate data traffics.

●Tracking and supporting for all solution driven support for UAT and production support and technical support whenever needed

●Rules And discoveries using Source To Target Mapping(STTM) documentation,Updations, System integrations, Downstream Impact Analysis, Fixing Gap between Technical and Business day-to-day issues and resolve.

Project Title: Marketing Team DataMart Oct 2017 – Nov 2019

Client : Wells Fargo, San Francisco, CA

Business Systems Analyst

Project Title: Global Banking Reporting and Analytics System July 2011 – Mar 2012

Sr Business Data Analyst

Responsibilities:

●Involved from scratch to design, reverse engineer for successful implementation of Marketing Data Environment. Incorporated agile for Challenging tasks in research of historical data for Credit Card Accounts for capturing customer summary population sourcing from multiple onion layers to remove existing traffic and succeed to play single handedly to capture the complexities and support, guidance from experienced seniors from Wellsfargo for existing ETL transformations and have robust way of implementing Customer Base Audience Population summary for all accounts in Wells Fargo.

●SCRUM process Agile meetings are day to day participations to share and gather and complete team efforts with global systems and facing all challenges to remodel and implement brand new MDE system

●Created, managed, tracked EPIC driven STORIES and discussions for solutions in daily stand meetings, template workshops with DMI team form Master Datamanagement system.

●Created Framework for complete Wellsfargo data by reverse engineering the source code and document the ETL transformations for all Source to Target Mappings until reaching actual System Of Record.

●Process Flow and data flow process for all Wealth Management - FInancial Investment, Estate Planning using all financial strategies

●Trained in Agile life cycle initially at Wells fargo and fortunate to work for challenging MDE environment for implementation of new innovative idea to remove multiple systems taking copies and transforming, instead to talk to one single server MDE and call from one single server for data quality, performance, removing all knots to avoid intermediate data traffics.

●Data analysis for all customer accounts and secured data and credit card security checks for all CLEAR and ANON schema structures. Complex functionalities include Credit Card score,ITA model Scores, Master Card Baps, Base Audience population,Wealth Management, Mortgage indicators for direct / automobile loans, Bev Online Events, Home mortgages.

●Reverse engineering without developers guidance to capture the flow of data with all complexities to populate data for ITA campaign and ITA promo executions from Customer summary data

●Analysis and deep dive to generate SOR Mapping documents resulted in Framework creation helped the team to proceed for further executions. Coordinated with Analysts and developers and share the complexities and to focus only on needed ITA data points for executions.

●Reusable Framework template for implementation of campaign executions for 13 LOBs overall and each LOB resulted in around 1000 data points and generating starting population for key encryptions and handing over all related traits to hang over the back drop key populations.

●Strong in Data analysis, slices and dices of data to encapsulate and provide solutions for data implementation in Hadoop for compete system sourced from various Mainframe systems, SQL Server, Tableau, Python and Teradata

●Hands on to work in Unix, DMF paths, Teradata,Apache,Abinitio, Oracle, Excel mapping for investigating the flow of data uploads and transformations and figuring out the final System Of record.

●Technically strong to understand and implement in challenging ETL environment sourcing from BMG,MDSS, CDB, C2T, BAPS Credit Cards,Experian, AFS, Acxiom, EDW, AIMS source systems to have one single MDE server to call data from and avoid multiple onion layers and complexities for all Wells fargo data mart users for their applications

●Successfully implemented the challenging task for figuring the final System of record as sources to capture via Abinitio, Teradata, Sql, Unix, Metadata and transformations and to reside all captured SORs in MDE server.

●Created new ETL Data Mapping and Documents with pseudocode and been major role to fix gap between technical and Business team since coming from Technical strong SQL skills

●Removing multiple onion layers in between source and destination and untangle all complexities and created runnable scripts instead of pseudocode to ease developers and reduce testing complexities.

●Interacted with Business teams to collect data for the conceptual design of the system and worked with Development Teams and Managers to analyze business needs and developed technical specifications.

●Created Excel mapping and Sql queries for all Metadata formation to capture from Excel to Sql tables for all layers of transformations to have one single layer for ease of developers and implementation

●Handled MDE team for data mapping and data structure gaps to fill gaps and display qualitative data with accurate mapping for all data transformations from DataMart to validate the data flow and Financial Carrying Values and Data migration to slice and dice as per data need to squeeze as per need of source and destination data access.

Project Title: Marketing Team DataMart, Jul 2016 – Oct 2017,

Project : Fed Edit Check Reporting, Schedule Reconciliation Sep 2014 – Apr 2015

Client : Bank of The West, San Ramon, CA

ETL BI Data Analyst Lead

Responsibilities:

●Team coordination and worked in successful implementation of Marketing Data Mart to Automate emailing and enhance Online and Mobile Banking and improve Customer interactions and analyze complete dependency of Geography, Time Dimensions and regular interaction with all project team members, NFG, CBG, RBG Business Owners, and IT/Technical Owner, QA teams and all other key stakeholder.

●Strong in SQL Server and Teradata and created Data Mapping and Documents with pseudocode and been major role to fix gap between technical and Business team since coming from Technical strong SQL skills

●Interacted with Business teams to collect data for the conceptual design of the system and worked with Development Teams and Managers to analyze business needs and developed technical specifications.

●Handled BIDM team for data mapping and data structure gaps to fill gaps and display qualitative data with accurate mapping for all data transformations from DataMart to validate the data flow and Financial Carrying Values and Data migration to slice and dice as per data need to squeeze as per need of source and destination data access.

●Designed with Ppt, Excel, Data collection process from Sql queries to provide Fed Edit scoreboard and results mapping for all schedules using Collibra Catalogue as reporting tool to pull data from common data repository for all drill through and coordinated with Business team and technical to implement successfully.

●LOB Mapping using Servicing LOB by mapping using Cost ctr num for all loan level / Segment ID level / Src Instr ID level for all schedule populations using Tableau, Sql Server, Python, Teradata.

●Can slice and dice and filter and verify in any Database repository using Data mapping and integration of UI applications back end data.

●Successful automation of verification of data from all schedules and all sources (AFS, ALS, IM, LP, IL, TSYS etc) in one dashboard for Federal submission.

●Asset/Wealth Management Planning vs strategies and rules to incorporate process used for financial investment management, estate and tax planning, accounting, retirement planning etc

●Team coordination and worked in successful implementation of SALESFORCE, OBIEE Fed Edit check Dashboards and Schedule Recon Dashboards for ease of Bug tracking and analysis of Development for all possible Data migration efforts.

●Handled BIDM team for data mapping and data structure gaps to fill gaps and display qualitative data with accurate mapping for all data transformations from DataMart to validate the data flow and Financial Carrying Values and Data migration to slice and dice as per data need to squeeze as per need of source and destination data access.

●Participate and contribute ideas in team meetings that address strategic business initiatives involving Salesforce.

●Followed agile and Scrum processes and got trained from BOW resulted in ease of handling challenges of hidden scenarios and time constraints.

Project Experience

Project Title: Data Migration in Robert Half from MJP to Salesforce Apr 2015 – Jun 2016

Client : Robert Half, San Ramon, CA

BIZ Data Analyst (Data Migration)

Responsibilities:

●Salesforce UI functionalities for all migrated data within customized objects of SFDC and handling team to develop, enhance and work with project timelines and deliverables.

●Work with internal stakeholders (sales, marketing, and finance, operations) to ensure that the custom processes and workflows support business requirements

●Serve as a subject matter expert on items related to Salesforce.com, third party integrations, and AppExchange.

●Functional and technical requirement documents for Terms and Conditions, Contracts, Job Orders, Special Rules, Contacts and Candidates play major entities and data to normalize as per functionality in Salesforce

●Worked in SFDC BI tool Workbench for ease of data joining and test scripts for SFDC object data verifications

●Complex logic in data mapping for Rates (complicated logic from data side) -Columns transformation logic calculations from MJP to SFDC as part DM tasks, as a team effort to periodically correlate and grab the story can help BSAs and correlate from DM side and UI side for rate calculations and updated stories to BSAs to fill gap for all UI and DM side when needed.

●Worked in Soql for Batch testing for US heavy performance risks.

●Salary Detail Data Analysis, Pay History Data Analysis: All gross, Total, Regular, Overtime, Double-time, Margin, Percent rate calculations and historical data for all pay records and migrated data from MJP and without impacting decimal calculations while displaying SFDC UI.

●Worked in Adapt and SalesForce Workbench tools to validate and verify data using sql skills

●Ensure users to have qualitative deliverable along with risks to be handled and change requests

●Worked in JIRA, EPIC, CMC tools for Issue tracking and task driven to correlate with all Stories / Change requests for constant updates to issues related to address to End Users and Project Management.

Project Title: WWSS Sales and Services Dashboards and Forecast BI Feb 2014–Aug 2014

Client : Cisco, San Jose, CA

BI Data Reporting Analyst Lead

Project Title: MES, Salesforce, Finance, Marketing Business Intelligence Apr 2012–Jan 2014

Client : Align Technologies Inc, San Jose, CA

Business Intelligence DataWareHousing for all In house Projects involved in Sales and Marketing, Finance, Manufacturing and all Integrated applications to derive into Business Intelligence Data warehousing using Sql Server Tools and Salesforce Reporting and dashboards.

Responsibilities:

●Involved in Automation of BI Report for ease of data validation and verification for every update in cubes and all related SSRS packages providing BI Reports using SSRS and SSAS.

●Salesforce implementation via Jitterbit tool to convert from Sql Server and reporting and dashboards.

●Implemented automated jobs and emailing system for ease of avoiding manual verification and reporting to the team for such a huge number of BI reports as per users requirements for all Integrated application data.

●Implementation of data via Tableau Reports and Dashboards and Reverse engineering using Sql scripts.

●Pivot table verifications and test scenarios to automate on a regular basis using cross verification Sql Scripts and implementing Sql Jobs .

Project Title : Intel Pricing, IDMS, BI reporting tool Feb 2010 –June 2011

Sr Sql Server Analyst (Intel, Santa Clara, USA)

Intel Pricing: Fixing and updating the initial prices for all Intel products were handled in Pricing consisting of internally 3 projects – TPM, iPAR and Sending to SAP .

IDMS – Intel Deal Management System: - Creating and processing deals for the products vary depending on the product hierarchy and corresponding dimensions. IDMS is one of the parts of Common Architecture Decision Support Systems.

COGNOS Reporting tool : Output of all deals were reported through COGNOS tool by using the Sql queries output of Deal and Geo data and comparing the billing figures.

Responsibilities:

●Involved in designing and implementing and support of all assigned internal projects

●Complex interface between Demand product data flow towards Pricing and Deal management system was handled when there was any data flow mismatch etc. using SSIS packages.

●Worked on a Complex data report to filter the entire project Product filters and Customer filters to check for the BAB and Bill figures and compare for the same after the deal is fixed. Faced huge impacts and solved dependency issues by creating a new functional design engine which never considered while developing in prior projects.

●Development, implementation and support of SQL objects along with .NET UI to send the Deal information to SAP by setting batch job timings thrice a day and monitoring the performance and supporting users when needed.

Project Title : Billing and Accounting System (HBOffice) June 2009 - Feb 2010

Sql server Analyst ( HBOffice, Oakland, USA)

Project Title : Ernst & Young Jan 2007 - Dec 2008

Sql server Analyst ( E&Y, Ohio, Cleveland, USA)

Project Title : ATOS Syntel August 2000 - Dec 2006

Project Lead ( Claims processing System, State Street CA, CNA Insurance NJ)

Contact this candidate