10+ Years of IT Experience in the Design, Development and Implementation of Data Warehouses/Business Intelligence applications using the rapidly evolving technology, thrive on managing multiple projects with strong combination of knowledge, ability, integrity, competing deadlines of getting the work done well on time and collaborate with various IT Teams, business teams and Vendors.
Skills
TOOLS/TECHNOLOGIES:
Informatica Power Center/BDM/IDQ/IICS/PWX 10.2
JIRA
Tivoli Work Scheduler (TWS)
MS Office suite 2010
QLIKVIEW
AWS (Amazon Web Services)
Salesforce
Big Data, Hadoop
SAP Business Objects Enterprise XI 4.0
TIBCO
Tableau 10.2.1
SaaS
SOAP UI
SQL
Service Manager
Oxygen XML Editor 17.0 (64-bit)
Ultra Edit Professional Text/HEX Editor 21.20.0.1014
VW Sales Dashboard,CCPA Compliance Product, 01/2020 to 06/2020 Iqvia Holdings Inc – Saint Paul, MN,
Gather Business requirements as per the CCPA confluence page Collaboration with data architect to design the ETL.
Extract the CCPA consumer compliance requests from DSRM application.
Developed the ETL mappings with data analysis, data quality, data integrity to search customer PII data against DW applications, MDM, Matching Engine and Data Lake based on the rules provided by business representatives,customer matches ETL mappings based on the TIER1 and TIER2 Matrix logic, load the data into CCPA application Informatica Power Center & BDM Developer 10.2.1.
Connected Vehicle data associated with customers loaded into Transactional database for reporting.
Created the SQL Views for Tableau visualization and users can analyze the data in Tableau for VWSales Dashboard.
Parameterize hard-coded values in Parameter files in Linux/Unix.
Participate in Design Review, Code Review for the Data Model and ETL.
Provided the Knowledge Transfer to Production support team.
Create the deployment groups to the physical environments for "Dev","UAT" and "Production" using Informatica Repository Services.
Schedule the batch jobs in TWS using IBM Dashboard Application Services Hub.
Create technical documentation for Supporting.
Version control available in PowerCenter Repository Service.
Parts Invoice,CarNet 2.0,Enterprise Leads(AU/VW), 07/2018 to 12/2019 Master Data SME-Manufacturing, VWGoA – City, STATE,
Gather Business requirements as well as data realities to understand the business objectives via sessions with business representatives.
Collaboration with data architect, data scientist & data governance representatives from the business to design the dimension modeling and visualize the data using ERwin
Capture the metrics on data analysis and design the business process to define the physical target which allows the grain, dimension and facts using Toad for Oracle Professional Edition.
Review the Dimensional models referred to as star schemas/Snowflake schemas designed for DW/BI system with Operational representatives.
Worked in the Agile environment containing Scrum and Sprint with two weeks iteration.
Worked with AWS (Amazon Web Services) team for Snapshot process and read-replica process and passwords stored in AWS secret manager.
Worked with connection creation to ping the AWS cloud servers for connection set-up in Informatica ICS.
Worked with Aeris vendor to refresh the data from VPC.
CarNet 2.0 Product workflows from AWS (Amazon Web Services) using Informatica ICS Developer into Data Lake Landing zone.
Developed workflows by performing cleansing and conforming transformations Using Informatica BDM Developer 10.1.1 for Enrollment report.
Worked with DBA to implement the tables in databases through VW DBTools Application Services.
Ensures code functionally tested before it releases into production.
Audi Dailydoc, Chattanooga, VCI/Cloverleaf, 04/2015 to 11/2017 Master Data SME-Manufacturing, VWGoA – City, STATE,
Participated in project planning sessions with business analysts andteammembers to analyze business IT Requirements.
Designed with data architect for data modeling to visualize data using ERwin.
Worked on data analysis and design process to implement the physical tables using Toad for Oracle Base Edition.
Worked with DBA to implement the tables in databases through VW DB SRS Application Services.
Perform the data Integrity in staging area using Informatica SQL Loader process and Send the erroneous records to business users via datax users transfer protocol.
From Staging area loaded the data to target databases by ETL mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Filter, Expression, Aggregator, Joiner, Update Strategy using Informatica Power Center 8.6.1.
Referential Integrity check build and maintain the logical relationships between tables in RDBMS.
Create the universe objects in the BI universes roll up to Brand, Port, and Nation, Region, Area, Dealer and Carline level using SAP Business Objects Universe Designer.
Data Operations Specialist, 03/2011 to 03/2015 Volkswagen Group Of America – City, STATE,
Supporting the production support for Incident Management initiative.
Resolve Production Issues and providing quick resolutions and Incident requests and Performance tuning of long running jobs.
Make sure that all the jobs are completed as per the SLA requirements.
Worked as a Subject Matter Expertise (SME) on most of the Subject Areas and downstream Applications.
Configured the MySQL ODBC connections from local environment to High Availability Environment.
Worked with different processes of a project like Initiating, Planning, Executing, Monitoring & Controlling and Created the Conceptual Solution.
Created the Detail Work Plan and Project Work Plan in order to coordinate concurrent development through different initiatives.
Provided Weekly Activity Status reports to Leadership.
Performed the Code Inspection/Review for the Coding developed by the ETL Developers to make sure the standards and the best practices are followed.
Automated the processes from existing Manual processes and Analyzed the existing systems and made a Feasibility Study.
Supporting the Informatica Administration activities involving creating and managing users, creating repositories, code migration from one environment to other etc.
Debugger to validate mappings and to gain troubleshooting information about data and error conditions.
Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
Used Tivoli to schedule the workflow process Performed Unit testing, string testing, regression testing, smoke testing and system integration testing.
Create test cases and test the transformation/jobs.
Developed Slowly Changing Dimension type I, II and III.
Participated in weekly standard meetings for data warehouse standards for future application development.
Worked on Month-End Process.
Trained and certified in TIBCO and Saas.
Education and Training
Master of Science: INDUSTRIAL TECHNOLOGY, Expected in 04/2011 Indiana State University - Terre Haute, IN GPA:
Bachelor of Science: Mechanical Engineering Technology, Expected in 04/2007 Jawaharlal Nehru Technological University - Hyderabad, India, GPA:
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
