Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Santhana Krishnakumar Paulraj

Plano,TX

Summary

ETL ARCHITECT/BUSINESS INTELLIGENCE TECHNICAL LEAD / MICROSOFT AZURE DATA ENGINEER/ INFORMATICA/BUSINESS OBJECTS/QLIKVIEW/SSIS/AB INITIO A successful technical lead with 15+ years of experience delivering quality results amidst tight schedule encompassing the following areas: Informatica Power Center Informatica Power Exchange Microsoft Azure Google Cloud Informatica Cloud Microsoft SSIS Ab Initio Qlikview Business Analysis Production Support Administration and Maintenance Development and Enhancement Release Management Data Quality Project Management

Results-driven data professional with proven track record in ETL engineering. Skilled in creating efficient data pipelines and ensuring data accuracy. Known for strong collaboration with team members and adaptability to changing project requirements, bringing valuable SQL and data warehousing skills.

Diligent [Desired Position] with strong background in ETL engineering. Experience in designing, developing, and maintaining ETL processes, with focus on data integration projects. Demonstrated ability in problem-solving and optimizing data workflows.

Experienced with ETL processes and data integration techniques. Utilizes SQL proficiency and strong analytical skills to develop effective data solutions. Track record of optimizing data workflows and ensuring seamless data transformation and loading.

Professional data integration specialist with strong focus on delivering high-quality, reliable solutions. Adept at designing, developing, and maintaining ETL processes, data warehousing, and database management. Team player known for adaptability and delivering results in dynamic environments. Skilled in SQL, Python, and ETL tools like Informatica and Talend.

Detail-oriented [Job Title] designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.

Knowledgeable [Desired Position] with deep understanding of data integration and transformation processes. Proven track record of designing and implementing efficient ETL solutions that streamline data workflows. Demonstrated expertise in leveraging advanced technologies and enhancing team collaboration to meet dynamic business needs.

Data engineering professional with extensive experience in designing and optimizing ETL architectures. Known for delivering high-impact data solutions that support strategic decision-making. Reliable team player who adapts to evolving requirements, showcasing strong analytical and problem-solving skills.

Experienced with designing and implementing robust ETL solutions to optimize data flow and integration. Utilizes cutting-edge technologies and methodologies to ensure seamless data processing. Track record of collaborating effectively with cross-functional teams to achieve organizational goals.

Database development professional with strong experience in PLSQL and proven ability to enhance database functionality. Known for collaboration and delivering reliable solutions in dynamic environments. Proficient in database programming and debugging, consistently meeting project deadlines.

Experienced with database programming, focusing on PLSQL. Utilizes effective query optimization to improve database performance and reliability. Knowledge of data modeling and schema design ensures robust database architecture.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Informatica ETL Lead

Leading US based travel company
03.2020 - 03.2022
  • Company Overview: This is US based travel company and a commercial website for finding discount rates for travel-related purchases such as airline tickets and hotel stays. The company facilitates the provision of travel services from its suppliers to its clients. This is headquartered in Norwalk, Connecticut, United States and is wholly owned by Booking Holdings. The company handles many products including Flights, Rental Cars, Hotels and Vacation Packages.
  • Managed the ETL team of Finance Business which takes care of handling data for Financial and accounting operations.
  • Created ETL jobs for extraction and loading of bookings and Financials to accounting. This includes AR and AP.
  • Analysis of data issues and job failures and Perform RCA (Root Cause Analysis) of job failures.
  • Strong experience in all phases of Analysis, Design, Development, Testing, Implementation and Production Support of various ETL projects in the Insurance and Reinsurance Domain.
  • Created stored procedure/script for validation of business rules to ensure the data and amounts are accurate before loaded to accounting.
  • Ensured all critical jobs are completed on time and appropriate communications are sent to downstream systems in a timely manner
  • Created PD alerts for critical jobs needed for Finance and accounting operations.
  • Created jobs to load commission files for all rental car and hotel vendors and load them to commission data store
  • Responsible for reconciliation between ARC BOS files and AP .
  • Effective coordination and worked with other product teams and payments team in solving the Finance data related issues.
  • Worked on cash reconciliation project and created data loads for loading optimized statements to cash recon system.
  • Analyzed all issues related to cash reconciliation and closed all unapplied transactions in Cash recon .
  • Complete understanding of Agile methodologies and worked on projects in Agile way
  • Experience with working in Atlassian JIRA for incident management and github for deployment and versioning.
  • Excellent problem solving and analytical skills .
  • Ensured best practice documents are built and reusable assets deployed which helped in the support and maintenance of the different ETL modules
  • Actively involved in the production support of ETL components and ensured the issues are fixed promptly.
  • Created Linux scripts in order to support the ETL loads and to send notification to the users.
  • Experience with developing complex SQL statements
  • Experienced in creating Informatica Mappings, Sessions, and Workflows
  • Solid understanding of SDLC, and best practices in design, development, testing, and deployment.
  • Ability to architect an ETL solution and implement data conversion strategy.
  • Experienced in Performance tuning of Informatica and optimization of SQL queries.
  • Developed solutions to client problems through application of personal experience and methods and tools.
  • Performed ongoing refactoring of code, utilizing visualization and other techniques to fast-track concepts, and delivering continuous improvement.
  • Created confluence pages for any critical documentation and also for tracking key projects
  • Supported database patching and server level patching for all databases and Informatica serveres.
  • Conducted weekly Knowledge sharing sessions with team to avoid any knowledge gaps with the team.
  • Good rapport with the team and nominated GEMS for best team members every month.
  • Quick Learner with excellent Leadership, Interpersonal and Communication skill. Worked with Clients in US for 6 years
  • Maintained a high level of accuracy in data entry tasks, resulting in improved overall data quality.
  • Processed requests for service from internal and external customers.
  • Improved system efficiency by monitoring computer performance and troubleshooting issues as they arose.
  • Ensured smooth workflow through effective coordination with other IT professionals on projects and tasks.
  • Boosted productivity by providing technical support to users, resolving issues in a timely manner.
  • Streamlined operations with routine maintenance tasks, such as updating software and hardware components.
  • Reduced system downtime, implementing proactive troubleshooting and rapid response strategies.
  • Reduced error rates in data processing with implementation of stringent quality control measures.
  • Optimized resource usage by efficiently allocating computer systems for various workloads and user needs.
  • Contributed to project success, closely collaborating with IT departments to implement new technology solutions.
  • Streamlined data management processes, leading to more efficient retrieval and storage of information.
  • Improved ETL processes by redesigning workflows and optimizing data extraction methods.
  • Developed custom ETL solutions to address unique business requirements, resulting in more effective data management.
  • Streamlined data integration tasks for increased efficiency, utilizing advanced ETL tools and techniques.
  • Designed robust error handling mechanisms for efficient troubleshooting and issue resolution during the ETL process.
  • Mentored junior team members on best practices in ETL development, fostering a culture of continuous learning and improvement.
  • Identified bottlenecks in existing ETL processes, implementing improvements that significantly reduced processing times.
  • Enhanced data quality and accuracy by implementing stringent validation checks and monitoring procedures.
  • Partnered with stakeholders to define clear project requirements, translating them into actionable tasks for successful execution.
  • Spearheaded efforts to automate repetitive tasks within the ETL pipeline, freeing up valuable time for higher-value activities.
  • Championed the adoption of agile methodologies within the team, leading to improved collaboration and faster project completion rates.
  • Conducted thorough analysis of source systems to identify potential data issues, ensuring accurate and timely data ingestion.
  • Collaborated with cross-functional teams to ensure seamless data flow between systems, increasing overall system performance.
  • Provided expert guidance on database design principles, helping optimize schema structures for efficient querying and reporting capabilities.
  • Led comprehensive testing efforts to validate functionality, performance, and reliability of developed solutions before deployment into production environments.
  • Resolved complex technical issues through careful analysis and debugging, ensuring minimal impact on business operations.
  • Managed multiple concurrent projects while adhering to strict deadlines, ensuring timely delivery of high-quality solutions.
  • Evaluated emerging trends in ETL technologies, recommending strategic investments to enhance organizational capabilities.
  • Documented developed solutions for ease of maintenance and future enhancements, fostering knowledge sharing within the team.
  • Evaluated current processes to develop improvement plans.
  • Gathered, documented, and modeled data to assess business trends.
  • Produced detailed and relevant reports for use in making business decisions.
  • Compiled research data and gave professional presentations highlighting finds and recommended optimizations.
  • Conducted thorough reviews of operations to devise and deploy improvement strategies.
  • Restructured procedures through coordination with compliance director to create and execute projects.
  • Leveraged on-site observation and personal interviews to identify team and individual strengths.
  • Recommended [Type] operational improvements based on tracking and analysis of [Type] data.
  • Implemented effective monitoring and alerting mechanisms for ETL workflows, enabling proactive resolution of issues before they escalate.
  • Evaluated and recommended appropriate tools and technologies for ETL development, ensuring alignment with business objectives and budgetary constraints.
  • Streamlined data integration tasks by automating manual processes and introducing scheduling tools.
  • Contributed to the successful migration of legacy systems by designing robust ETL architectures compatible with newer technologies.
  • Reduced report generation time by implementing efficient query techniques and database indexing methods.
  • Worked closely with database administrators to fine-tune performance, ensuring seamless integration between SAP Business Objects and underlying data sources.
  • Conducted thorough testing of reports, dashboards, and universes to guarantee accurate results and optimal performance.
  • Developed complex SAP Business Objects universes to support advanced reporting needs.
  • Optimized existing universes by identifying inefficient joins or structures, resulting in faster response times for report users.
  • Provided expert technical support for end-users, promptly addressing issues and resolving problems related to SAP Business Objects applications.
  • Streamlined data extraction processes for improved data quality and report accuracy.
  • Enhanced system performance by optimizing SAP Business Objects reports and dashboards.
  • Participated in project planning meetings, contributing valuable insights based on experience with SAP Business Objects development best practices.
  • Facilitated training sessions for new users, increasing their proficiency in utilizing the capabilities of SAP Business Objects tools effectively.
  • Spearheaded migration efforts from legacy systems to SAP Business Objects, minimizing downtime and ensuring seamless transition for users.
  • Multitasked and managed multiple deliverables and projects concurrently and facilitated use of SAP for enterprise resource planning.
  • Ensured data security by implementing appropriate access levels and user restrictions within the SAP Business Objects environment.
  • Trained and mentored junior staff on SAP system operations and functionality.
  • Documented and maintained technical specifications for SAP applications.
  • Streamlined data integration efforts by developing reusable components that enhanced productivity across multiple projects.
  • Enhanced data warehousing capabilities for improved decision-making processes through careful design and implementation of Teradata solutions.
  • Managed project timelines effectively by prioritizing tasks according to urgency while maintaining superior standards of quality in deliverables.
  • Conducted thorough code reviews to identify potential issues, maintaining a high standard of quality throughout the development process.
  • Implemented effective backup and recovery strategies to safeguard vital business data from loss or corruption.
  • Proactively identified opportunities for process improvements within the team, leading to increased efficiency and productivity.
  • Developed high-quality ETL processes to ensure accurate data loading and transformation, resulting in better reporting functionality.
  • Partnered with business analysts to refine data models based on changing requirements or new insights gleaned from analytics initiatives.
  • Integrated external data sources into existing Teradata systems through robust import/export mechanisms, expanding analytical capabilities for endusers.
  • Mentored junior developers on best practices in Teradata development, fostering a culture of continuous learning and improvement within the team.
  • Optimized database performance by implementing efficient indexing strategies and query optimization techniques.
  • Provided timely support for production issues related to Teradata applications, working closely with operations teams to resolve problems efficiently without impacting overall system performance.
  • Improved system stability with rigorous testing procedures, identifying bugs early in the development cycle and ensuring prompt resolution.
  • Conducted regular performance tuning sessions, identifying bottlenecks and implementing solutions to optimize system resources effectively.
  • Collaborated with multi-functional roles to communicate and align development efforts.
  • Completed quality reviews for designs, codes, test plans and documentation methods.
  • Mapped data between source systems and warehouses.
  • Developed and modified programs to meet customer requirements.
  • Selected methods and criteria for warehouse data evaluation procedures.
  • Tested software applications and systems to identify enhancement opportunities.
  • Proactively addressed potential issues through rigorous testing methodologies, reducing bug occurrences during live releases.
  • Provided expert guidance on Unix-based systems, serving as a valuable resource for colleagues and clients alike.
  • Collaborated with cross-functional teams to design and implement system upgrades, ensuring seamless integration with existing infrastructure.
  • Enhanced system performance by optimizing Unix shell scripts and streamlining processes.
  • Resolved complex technical issues through thorough analysis and troubleshooting, minimizing system downtime.
  • Contributed to successful project completion by meeting deadlines and adhering to strict quality standards.
  • Developed custom Unix scripts for various business needs, simplifying tasks and improving productivity across departments.
  • Updated legacy systems using modern Unix technologies, enhancing usability while maintaining compatibility with existing infrastructure elements.
  • Streamlined workflows with the development of automated tools and processes, increasing overall efficiency.
  • Optimized application performance by implementing effective debugging techniques and addressing identified bottlenecks.
  • Developed efficient code for software applications, resulting in improved functionality and user experience.
  • Proved successful working within tight deadlines and a fast-paced environment.
  • Built databases and table structures for web applications.
  • Coordinated deployments of new software, feature updates and fixes.
  • Tested and deployed scalable and highly available software products.

ETL Technical Lead/ETL Developer

Leading Insurance Company
12.2017 - 05.2019
  • Regulatory Reporting Department Data Warehouse (RRDDW) is a warehouse of the premium and Loss information including the Financials which will be filed with NCCI (National Council of Compensation Insurance) bureau every quarter by the company. The required Premium and Loss information will be retrieved from different source systems and will be loaded to RRDDW after applying transformation rules in ETL.
  • Strong experience in all phases of Analysis, Design, Development, Testing, Implementation and Production.
  • Involved in interaction with the Regulatory Reporting users and responsible for gathering the requirements, analysis, technical design, development, testing and implementation of Ab initio graphs
  • Experienced in creating complex Ab initio graphs using the applicable components effectively.
  • Experience in working with components involving Filter, Reformat, Gather, Replicate, Partition By Key, Sort, Rollup, Dedup Sorted, FTP, SFTP, Inflate, Deflate, Compress and Decompress Components.
  • Created DBC files for the source database from where the data is extracted.
  • Created generic graphs for data extraction and the data is pulled from different source system using different parameter sets created.
  • Created FTP/SFTP jobs for pulling the file from Mainframe System which contains premium and Loss information.
  • Created graphs for running the dynamic difference and compared the data in warehouse during every release.
  • Tracked the Jobs and the graphs using the Ab initio EME console
  • Created tags for Ab Initio code using the script for each deployment and Coordinated with admin for the deployment.
  • Experience in creating phases and tasks in Service Now as part of the release process.
  • Experienced in Installation and Configuration of GDE 3.0.4.1
  • Expertise in scheduling Ab initio jobs using Autosys Scheduler.
  • Identified data sources and worked with source system developers and business owners to define data extraction methodologies.
  • Executed the Quarterly jobs on time and ensure the warehouse/DataMart is loaded on time for the Business to file the information with bureau.
  • Executed the History jobs for updating the Historical data bi yearly.
  • Experience in creating JILs for implementing jobs in AutoSys.
  • Performed validation of the ITD and YTD for premiums and Losses after the warehouse is loaded.
  • Coordination with various source systems for understanding any impact because of the changes made to the system.
  • Handled incidents created for job failures in Service Now within the SLA.
  • Handled all the Business requests with all the Financial queries from Business and response provided within the SLA
  • Involved in AVP (Application Verification Process) Testing for any Changes to Dev/QA/PROD servers and ensured the application availability.
  • Worked with Data architects for any DDL changes to the warehouse.
  • Experience in tools like Service now and Agile Central

Business Intelligence Technical Lead /ETL Developer / Reporting Developer

Leading ReInsurance Company
03.2009 - 11.2017
  • Microsoft Dynamics 365 LZ Integration and Global Information Services
  • Dynamics LZ Integration project extracts all the CRM data from Dynamics 365 and load to Oracle landing zone using SSIS .This CRM data in turn will be used in the downstream reports as per Business needs.
  • GIS is a single umbrella serving the BI - Data and reporting needs of the different business units the company
  • Created SSIS packages for extracting the entities from Dynamics 365 to landing zone (Oracle)
  • Deployment and scheduling of the SSIS packages in the SQL server 2014.
  • Involved in the analysis and preparation of mapping sheet between Dynamics and Landing zone.
  • Experience in working with Dynamics 365 and analysis of the relation ship between the entities.
  • Deployment and scheduling of the SSIS packages in the TEST servers.
  • Implemented projects using Agile methodology and experience in MS Azure devops and Rally Agile Central.
  • Created scripts for validating the data validation between source and target.
  • Experienced in Installation, Configuration and Administration of Informatica PowerCenter.
  • Experienced in Performance tuning of Informatica and optimization of SQL queries.
  • Experienced in deployment of SSIS packages into the SQL server.
  • Handled administration for all the BI platforms including Informatica, Business Objects and Qlikview
  • Worked on the upgrade of Informatica power center from 9.5.1 to 10.1.1
  • Worked on the repository upgrade of Business Objects BI 4.2 from Oracle to SQL server
  • Involved in SAP Business Objects upgrade from XI R2 to BI 4.1
  • Strong experience in all phases of Analysis, Design, Development, Testing, Implementation and Production Support of various ETL projects in the Insurance and Reinsurance Domain.
  • Created stored procedures and macros in the development of the Excel based reports for Treaty Business
  • Expertise in data extraction from heterogeneous source systems like Oracle, Sybase, Lotus Notes, SQL Server ,DB2 ,VSAM Files and Flat files using Informatica Power Center and Power Exchange.
  • Involved in interaction with the end users and responsible for gathering the requirements, analysis, technical design, development, testing and implementation of Informatica components.
  • Analysis of data issues and job failures and Perform RCA (Root Cause Analysis) of job failures.
  • Ensured best practice documents are built and reusable assets deployed which helped in the support and maintenance of the different ETL modules.
  • Actively involved in the production support of ETL components and ensured the issues are fixed promptly.
  • Created Linux scripts in order to support the ETL loads and to send notification to the users.
  • Experience with developing complex SQL statements
  • Experienced in creating Informatica Mappings, Sessions, and Workflows
  • Solid understanding of SDLC, and best practices in design, development, testing, and deployment.
  • Ability to architect an ETL solution and implement data conversion strategy.
  • Experienced in Performance tuning of Informatica and optimization of SQL queries.
  • Developed solutions to client problems through application of personal experience and methods and tools.
  • Performed ongoing refactoring of code, utilizing visualization and other techniques to fast-track concepts, and delivering continuous improvement.
  • Created ETL components involving SCD2 and MD5 hash algorithms for insert/update scenarios.
  • Leveraged Informatica Cloud to upload and download Salesforce data to LZ tables for serving the reporting needs in Qlikview and Business Objects.
  • Developed complex reporting in Business Objects for Group Finance and Treaty Business for access in BI Launch Pad and in Crystal Reports
  • Complete ownership and successful upgrade of Informatica, Informatica Cloud, Business Objects
  • Involved in the daily, weekly, monthly status meeting for Technical upgrades, Change Advisory Board (CAB) meetings, SAP Release Process Cut over etc
  • Administration & Support of all the BI servers and technologies under GIS landscape (Informatica, Informatica Cloud, Business Objects and Qlikview).
  • Implemented Automatic job delay notification resulting in quicker response to ETL data issues.
  • Creation of Audit, Balance and Reconciliation (ABC) process for all ETL applications. .
  • Enabled Automatic Restart and Notification process in case of any job failures.
  • Solid verbal, written, presentation and interpersonal communication skills
  • Utilized tasks scheduler in the various windows servers to create reusable task for services recycle to clean up logs and improve server performance in Qlikview and Business Objects.
  • Developed Policy and Billing dashboards in Qlikview for the Life and Health Business users.
  • Developed the Global Capacity Model dashboard in Qlikview which was helpful for all the IT users and managers to track the requests efficiently.
  • Supported various Qlikview applications for the users from different business units like Treaty , Claims ,Facultative e.t.c and enhanced the reports based on the requirements.
  • Deployment of the Qlikview (QVWs) into the servers and scheduling them in QEMC based on the user needs.
  • Handling the task failures in Qlikview Management Console and providing the fix for the failures within the SLA.
  • Setting up dependency between ETL jobs and Qlikview reports using the Flag and File watcher jobs.
  • Setting up automated Email notifications in Qlikview if the task has not been kicked off in Console within the expected time range.
  • Handled user administration and provided access to users for Qlikview dashboards with the access to the specific applications that is applicable for them.
  • Created tasks in Qlikview servers for the periodic restart of the Qlikview services.
  • Analyzed the Qlikview scripts for all the requests that comes from Business and provided the analysis details to the users.
  • Perform routine Admin tasks (Code move, Setup, Deployment, Coordination and Backup).
  • Integration of Various Lotus Notes database data into Oracle Environment using Power Center.
  • Provided strategic thinking leadership pertaining to new ways of leveraging information to improve business.

Education

Bachelor of Engineering - Computer Science

Anna University
Chennai , India
01.2007

Skills

  • Data integration with Azure Data Factory
  • ETL tools proficiency
  • Proficient in SAP Business Objects and Crystal Reports
  • Skilled in JIRA project management
  • Database query languages
  • Other Tools : SAP CHARM , SAP Netweaver , Rapid SQL, SQL Developer , HP ALM Quality Center, BMC Remedy, Mercury ITG, MS Office Suite, SQL Server Management Studio, Master Data Services Administration, AIR Touchstone , Agile Central , Service Now, Azure Devops, MS Dynamics 365 ,Github, Slack ,BMC Bladelogic , TOAD ,Dbeaver
  • Proficient in Autosys and Crontab
  • Proficient in Oracle and SQL Server
  • Data warehousing concepts

Accomplishments

  • Have received Xcelerate Warrior certificate in 2023.
  • Have Completed Digital : Wings 2 - Digital Transformation for Tech Leaders Curriculum
  • Received Best Performer award from customer in the Townhall Event in 2021
  • Received many ON THE SPOT awards for my contribution to the project
  • Received many appreciation from customers for handling key projects
  • Have been awarded K Pro Award for my Contribution as Knownmax Officer in 2013.
  • Have been awarded “Beyond the Performance Award” for my contribution to the Project in 2015.
  • Successfully managed a team of 10 members and received 100% customer satisfaction for the year of 2014.
  • Have received Star Team award in 2015.
  • Multiple appreciations directly from the Chief Information Officer for the quality of deliverables.
  • Have received many appreciations from the DAF and KC for my work towards IPMS and knownmax.
  • Played a major role in Automation Week organised by MU unit and also organised online events.
  • Have organized events as part of RIO week.
  • Have organized many team building events which was very well recognized by management.
  • Anchored the TCS Siruseri (Chennai ) family day event in 2013 as well as Xtravaganza conducted by Manufacturing ISU in 2014.

Certification

  • Microsoft certified Azure Data Engineer
  • Google Certified Associate Cloud Engineer
  • IBM Certified - Cognos 8 BI Reports
  • SAFE Certified Agile Practitioner
  • Project Management – E0

Timeline

Informatica ETL Lead

Leading US based travel company
03.2020 - 03.2022

ETL Technical Lead/ETL Developer

Leading Insurance Company
12.2017 - 05.2019

Business Intelligence Technical Lead /ETL Developer / Reporting Developer

Leading ReInsurance Company
03.2009 - 11.2017

Bachelor of Engineering - Computer Science

Anna University
Santhana Krishnakumar Paulraj