PROFESSIONAL SUMMARY:

• Business Intelligence Consultant and team lead with a 9 - year career in data warehousing, business intelligence, and data management architecture, design, development, and solution implementation in Confidential services.
• Possess knowledge of Credit Card account life cycle management in Finance domain, Functional knowledge of Collections and Recovery operations.
• Possess Knowledge of multi-tenure loyalty program in Retail domain. This is a loyalty program across all WSI brands - the first time that customers can earn points by purchasing across the multiple brands (WSI, Pottery Barn, West Elm, etc.).
• A progressive Lead Developer with a strength in driving performance, reducing inefficiencies and cutting costs
• Possesses comprehensive knowledge and hands on experience in both ETL and Reporting tools which includes -
• ETL Ab initio, Tableau Reporting and Data Visualization SAP Business Objects Universe designing, Business Objects Webi and Deski report building, Unix shell scripting, Oracle database, SQL, PL/SQL, Teradata database, APEX HTML DB, Data Warehousing Concepts, Data Modelling Concepts.
• Experience in Software analysis, design, development and maintenance projects.
• Experience with co-ordinating with different departments to attain business requirements.
• A project planner with expertise in planning, executing and spearheading various SDLC and Agile Scrum projects in compliance to quality standards.
• Experience in Ab Initio toolsets including the following:
• Parallel and serial flow batch graphs, conditional components, other components like reformat, normalize, and join, lookup and graphs processing ASCII and EBCDIC layouts.
• Knowledge on Ab-initio architecture including the GDE, Co-operating system, EME and other related items.
• Fine tuning of Ab-initio graphs based on performance enhancement by proper usage of memory in the components.
• Well versed with various Ab Initio components such as Join, Rollup, Partition De-partition, Dedup sorted, Scan, Normalize, De-Normalize.
• Expertise knowledge improving Performance and Troubleshooting of the Ab-Initio graphs and monitoring AB-Initio run time statistics.
• Experience with advanced Ab-initio meta-programming, air commands and other admin related tasks including the creation of. save and performing migration from one server to the other.
• Experienced working in Tableau Desktop.
• Ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Filters, prompts, Calculated fields, Groups, Parameters in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau
• Hand on experience in end-to-end development / deployment of software components starting from requirement analysis to system study, designing, coding testing, de-bugging, documentation and implementation.
• Known for effective communication with excellent relationship building & interpersonal skills, Strong analytical, problem solving & organizational abilities. Possess a flexible & detail oriented attitude.
• Synchrony Financial is a consumer financial services company offeringconsumer financing products, including credit, promotional financing and loyalty programs, and instalment lending, through Synchrony Bank, itswholly owned subsidiary . Synchrony is the largest provider ofprivate label credit cards in the U.S. The company provides private label credit cards for such brands as Amazon, JC Penney, CheapOAir, OneTravel, Sams, Walmart, Lowe’s, Guitar Center, Gap, BP.
• We as Data warehouse solution providers, store this credit card holder information from the instance a credit card is applied till the account is closed/charged off.

TECHNICAL SKILLS:

ETL Tools: Ab Initio, Apache Spark,IntelliJ, Data Pipelines

BI Reporting Skills: Tableau Desktop, Tableau Server, SAP Business Objects (SAP BO)Universe Designer ToolSAP BO XI WEBI ReportingSAP BO XI Deski ReportingTOAD, SQL Developer, EDIT PLUS, APEX (HTML DB)

Languages: Oracle, PL/SQL

OS Platforms: UNIX

Scripting Languages: Unix shell scripting, Python, Scala

Database: Oracle, Teradata, Hive

Scheduler tools: Autosys, Control-M, Azure Data Factory

Data Analytics: Tableau Reporting and analytics/ Data Analysis/ Data Visualization

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior Data Engineer

Responsibilities:

• Co-ordinate between various data applications to understand how and where the source fields are being populated.
• Build and review design deliverables
• Developed and Conducted IT code reviews of Ab initio graphs to extract, transform and load the data in intermediate datasets
• Performed dependency analysis between the new objects created in the ab initio graphs
• Conduct IT and UAT testing of each of these graphs
• Record errors reported during Unit and Integrated testing
• Prepare the production Implementation Plan to release the codes successfully
• Attending daily stand-ups, which is a short meeting where teammates talk through: what I worked on yesterday, what I did today and if am blocked.
• Involved in variety of other scrum meetings, such as planning meetings (where the team pulls in stories (requirements), grooming meeting to look at the backlog/list of stories and flush out the timeline and work expected, demo (show the work that was completed in the sprint), etc.

Confidential, Chicago, IL

Data warehouse System analyst/ Senior ETL Developer

Responsibilities:

• Gather business requirements
• WorkedwithRequirementsAnalystsandSubjectMatterExpertstoidentify,understandanddocumentbusinessneedsforthedataflow
• Prepare a mapping document for each of the fields in the extract to contain source-target mapping.
• Performedanalysisofthesourcedataanddatamappings
• WorkedwiththeProjectManagementinthecreationofprojectestimates.
• ServedasaliaisonbetweenthebusinessSMEs,businessdatavalidatorsandthecoreprogrammembers
• Co-ordinate between the data warehouses to understand how and where the source fields are being populated.
• Build and review design deliverables
• Developed and Conducted IT code reviews of 100+ Ab initio graphs to extract, transform and load the data in intermediate datasets
• Performed dependency analysis between the new objects created in the ab initio graphs
• Conduct IT and UAT testing of each of these graphs
• Record errors reported during Unit and Integrated testing
• Prepare the production environment to implement the codes successfully
• Understanding the customer supplied documents and capturing requirements for report developments.
• Arranging and attending calls with onsite members and other related teams whenever required.
• Maintaining the application, changing/modifying existing reports etc.
• Create BO Universe based on customer's reporting requirement
• Designed, developed and implemented Business Objects Webi reports.
• Was immensely recognized by the customer on sending a defect free extract when the product went live.

Confidential, Chicago, IL

Data warehouse System analyst/Senior ETL Developer

Responsibilities:

• Gather business requirements
• Working with the team to identify ETL objects, DB objects where the old Sams accounts were being processed
• WorkedwiththeProjectManagementinthecreationofprojectestimates.
• Data Profiling in different stages of data transformation to ensure Data reconciliation.
• Reviewing every single graph to make sure changes were done to lookup new account numbers from crossref table for incoming old account numbers
• Identify every single rollover dataset which will need to be fixed to convert all old accts to new account numbers.
• Documentation for project support and maintenance. Creating case studies of major enhancements.
• Build and review design deliverables
• Modify Ab initio graphs to extract, transform and load the data in intermediate datasets
• Coordinate with teams and business teams to conduct IT and UAT testing of each of these graphs
• Record errors reported during Unit and Integrated testing
• Maintain requirements status update log.
• Give requirement document walkthroughs to developers.
• Ensure all changes in requirements are documented & communicated to required folks.
• Create process flow diagrams, test cases, log defects and provided testing support in QA, staging & production.
• Create Implementation plan and share with client and offshore teams.
• Create HxH plan listing down the tasks in sequence of their execution on the date of implementation.
• Prepare the production environment to implement the codes successfully

Confidential, Kettering, OH/ Chicago, IL

Data warehouse System analyst/ Senior ETL Developer

Responsibilities:

• Gather business requirements
• Analyse business ETL requirements and decide on design approach
• Analyse business reporting requirements and design BO Universe around it
• Build and review design deliverables
• Review construction progress with offshore team daily
• Create new ETL graphs using Ab initio to extract the data from file and load into the respective target tables with the business rules.
• Conduct code reviews of the newly created objects and modified objects
• Worked with the integration teams and the ETL teams to ensure a smooth transition from the design phase to the implementation phase.
• Peer review between teammates
• End to End testing involved the testing of the data from flat files to reports.
• Co-ordination with onsite team and developers.
• Involved in quality assurance to ensure quality, validity and accuracy of data across the servers.
• Provide demo to users to understand the newly created objects and reports
• Conduct IT and UAT testing
• Record errors reported during Unit and Integrated testing
• Prepare the production environment to implement the codes successfully

Confidential, Kettering, OH/ Chicago, IL

Report developer/ Data analysis

Responsibilities:

• Overall responsibility for short/medium term planning and organisation of all resources.
• Developing and managing interdisciplinary teams for multi-party projects.
• Writing up reports on business operations for the executive staff.
• Attending regular progress meetings with Senior Leads and Directors.
• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Analysed data to show the yearly, monthly increase in the number of credit card holders by client.
• Analysed data and created Box Plot and Whisker reports to show the outlier customers who didn't make the most payments.
• Identified and Researched clients who took unauthorized discounts and acted to recover owed balance
• Understanding the customer supplied documents and capturing requirements for report developments.
• Understanding the business requests clearly and addressing business concerns.
• Working harmonically with onsite counterpart and other related application teams.
• Arranging and attending calls with onsite members and other related teams whenever required.
• Maintaining the application, changing/modifying existing reports etc.
• Understand Requirement, Analysing Systems and Source Databases.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Created basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Representing data using the visualizations such using Charts.
• Used Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Used parameters and input controls to give users control over certain values.

Confidential

D ata warehouse System analyst / Senior ETL developer

Responsibilities:

• Gather business requirements
• Setting up the new environment for the Application in Carrollton Data centre for Collections DW.
• Co-ordinated with teams to be get the New DNS & IP to be configured in the AI Graphs & Scripts
• Getting all new Software's installed in the new data centres.
• Identifying all the active datasets to be moved to Dallas data centre
• Working with warehouse leads to Identify impact of migration on dependent warehouses
• Identify ETL objects, DB objects, datasets mount points to be moved to the new server.
• Setting up onetime RSYNC to copy all the objects to the new server and making the new server the replica of old server.
• Co-ordinating with teams to schedule the parallel loads in both old and new servers
• Validating data loaded in all Database tables during parallel run
• Validate that reports are being refreshed accurately at expected times in the new server and returning the same results in both the server.
• Understand the HLD (High Level Design Document) and participated in all aspects of project starting with inputs to understanding the requirements and getting the queries/doubts cleared from the business users if any.
• Also, participate in coordination with offshore team for workload distribution and management.
• Documentation for project support and maintenance. Creating case studies of major enhancements.
• Build and review design deliverables
• Record errors reported during Unit and Integrated testing
• Maintain requirements status update log.
• Give requirement document walkthroughs to developers.
• Ensure all changes in requirements are documented & communicated to required folks.
• Create process flow diagrams, test cases, log defects and provided testing support in QA, staging & production.
• Create Implementation plan and share with client and offshore teams.
• Create HxH plan listing down the tasks in sequence of their execution on the date of cutover.
• Prepare the production environment to implement the codes successfully

Confidential

Sr. Abinitio Developer

Responsibilities:

• Gather business requirements
• Prepare ETL, DB and Reporting design deliverables
• Created a new table to load the PLCC and PSCC settlement reporting data from source
• Created new ETL jobs to load the new DW table.
• Testing of new ETL jobs which load the new DW table
• Scheduling the ETL jobs using Autosys scheduler
• Prepare new Business Objects Universe to facilitate reporting on the new Universe.
• Co-ordinate with users to ensure UAT goes smooth
• Prepare the production environment to implement the codes successfully

Confidential

Sr. Ab initio Developer

Responsibilities:

• Gather business requirements
• Identify ETL objects, DB objects and BO Universes where the PII fields were located
• Modify all the ETL jobs to generate tokens for the incoming account numbers in the source feeds.
• Test the token generation algorithm to ensure only unique tokens are generated for each account number
• Add account number token to all the DB tables where account number token was found
• Build and review design deliverables
• Modify Ab initio graphs to extract, transform and load the data in intermediate datasets
• Conduct IT and UAT testing of each of these graphs
• Record errors reported during Unit and Integrated testing
• Prepare the production environment to implement the codes successfully
• Able to work independently/autonomously.
• Ability to work on multiple assignments parallelly.
• Strong technical skills (will be able to pick-up new technologies).
• Self-driven
• Led the team as SPoC for investigations & troubleshooting of Level1&2 issues.
• Proficient written & communication skills.
• Good exposure in development background.
• Process Oriented.
• Optimist, Enthusiastic, Confident, Flexible, always willing to learn new technologies.