Lavanya Baskaran

• Provided design and architecture solutions to new applications being developed on the existing product including ADS transactional/snapshot table loads, DDW loads and generating customized as well as generally available ETL extracts.
• Analyzed various business artifacts like Functional Requirements, document the Technical Design/Solution Specification Documents and update the Requirement Traceability Matrix.
• Involved in creation/modification of Linux Wrapper Scripts for automating job scheduling through Control-M.
• Involved in UNIX to Linux migration as well as DataStage migration to 11.7 and performing impact analysis of any deprecated functionalities and fixing them.
• Lead the Harvest to Bitbucket migration project involving 350+ Bitbucket repositories and Jenkins pipelines.
• Created/tailored multiple process artifacts including code review, code migration checklist and Source code management process documents.
• Orchestrated the solution for the Day 0 processing setup for one of the major banks' merger, liaised with multiple companion teams, responsible of creating production conversion playbook.
• Involved in enhancement of the data porting utility using Python scripts to demo for a leading bank's Request for Proposal.
• Analyzed and provided migration architecture solutions for an Informatica ETL migration project that includes leading the team on server sizing and setup, establish endpoint connectivity, gold code analysis, migration to new infrastructure and upgrading from Informatica 10.2 to 10.5
• Managed a team of 10 to 15 including senior ETL developers, mentored, and provided troubleshooting and alternate development solutions.
• Liaised with other functional / project managers and management team providing metrics for governance dashboards, project status, resource forecasting and work allocation for the team.
• Experienced in project configuration management and preparing Process Audit documents and presenting to the SQA team.
• Extended support to staffing team to hire and train freshers as well as ready to be deployed experienced resources.

• Involved in profiling the Customer data using SAP Information Steward 4.1, Cleanse and standardize, perform de-duplication using SAP BO DataServices jobs.
• Document use case results and evaluate the software feasibility based on the results.
• Involved in Real-time job configurations for handling real time response (XML) messages and configuring data store for posting message request to services
• Implemented DataServices Pre-processing & Processing jobs using MQ Integration services with existing Validation & Match Services.
• Architected the Exception & Audit jobs to capture the audit and Exception history by leveraging existing Controls Tables for the Integration.
• Handled UNIX wrapper shell scripts while integrating with SAP Data Services.
• Performance tuned the Data Services job for handling high volume XML files.
• Responsible for Onsite and Offshore co-ordination and project tracking as a team lead
• Worked on a proposal to win a Data Quality project from a leading Information provider client and providing the effort/complexity estimate.
• Involved in defining ETL and system integration architectures combining data from disparate source systems and disparate data formats including XML, complex data files.
• Worked extensively on different stages like Transformer, Data sets, Sequential Files, Aggregator, Row Generator, Sort stages.
• Designed and developed a data reconciliation process ensuring no data loss.

· Mainly responsible for process management activities like documenting project milestones & metric reports.

· Handled extensive interactions with the clients, business owners, development team & the other support teams.

· Involved in resolving the performance issues of DataStage jobs and BO reports.

· Prepared performance test cases and other supporting documents.

Developed batch scripts for automating the compilation, export, import of DataStage jobs.

· Designed, documented, and developed DataStage ETL flows for actual implementation.

· Performance tuned the existing People soft delivered EPM jobs.

· Implemented DB2 Range Partitioning technique to considerably reduce the delete time on the warehouse tables.

• Mentored the team members on the process and technology.

· Involved in requirement analysis, technical design documentation, and development of jobs/sequences in Ascential DataStage 7.5 using sequential file, hash file, ODBC, and other processing stages.

· Generated SQL Scripts in MS-SQL Server 2000 for data validation at the source, staging, dimension and delete jobs.

· Created the reports through BO XIR2 desktop intelligence(Have worked on different formatting options, implementing open document functions, etc.,)

· Involved in developing Microsoft SSIS packages for trace logging and invocation of stored procedures and generated SSAS cubes for CDI and PCI metrics

· Developed Perl scripts to parse through the DataStage dsx files and automate the process of adding additional parameters to existing jobs.

· Mentored the interns of the DW Practice.