Data Engineer

Senthilnathan Sundaravadivelu

Charlotte, NC ***** - 980-***-**** - adjoi5@r.postjobfree.com

Summary

• 10+ years of professional experience in the IT industry and having full SDLC experience of large-scale enterprise applications (requirements, design, implementation, integration and testing). Worked as a Business intelligence specialist, technical Lead and BI consultant.

• Highly motivated business intelligence professional worked on leading BI tools in the market. Applied reporting best practices throughout the project life cycle.

• Experienced in developing and driving enterprise BI implementations and strategies within large enterprises.

• Strong project lead and organizational skills.

• Strong technical skills, extensively worked on SSIS, informatica and unix scripts

• Expertise in business intelligence applications and reporting area with various platforms including MSBI, QlikView, Dundas Dashboard and Tableau

• Strong RDBMS, DW skills, extensively worked on SQL Server, Teradata SQL and Oracle databases.

• Flexible and able to work under pressure and to deadlines.

• Proactively seeks opportunities to broaden and deepen knowledge base and proficiencies.

• Understands the necessity of project standards and applies them consistently.

• Communicated effectively with colleagues to identify needs and evaluate alternative business solutions. Ability to document and explain the technology behind work carried out.

• Experienced in developing rich interactive reports and dashboards integrating various reporting components from multiple sources including relational, hierarchical, XML, Web Services also leveraging Link Servers, Flat Files, XLS, CSV, SharePoint and RDBMS.

• Delivered critical timeline projects with good quality but without delay Skills

• Primary Skills Teradata SQL, SQL Server, MS-BI

Tools (SSIS, SSRS and SSAS), Informatica, Unix

scripting, QlikView, Tableau and Power BI

• Operating Systems Windows/Unix

• Languages .NET/Java (exposure)

• Development Tools Autosys, SQL Developer,

NDM Secure+, Teradata 16.20, Informatica

10.2.0, SSDT and SQL server Management studio

• Databases Teradata, SQL server and Oracle

• Configuration Tools GitHub, Jenkins, U-deploy,

Visual studio, Jira and PAC2k

• Domain Knowledge Wholesale Credit Banking,

Media Advertisement, Customer Survey and

Public Sectors

• Documentation MS-Visio, MPP

• Automate, Diagnosis, Excel, Reporting, UNIX

• Database concepts RDBMS and Data warehousing

• Problem – Solving

Experience

NTT DATA, INC March 2019 to Current

Business Intelligence Specialist

Charlotte, NC

• Working for Wells Fargo project - Wholesale Customer Survey applications

• Worked on MRA concentration and CRE reporting projects

• Working closely with team members to deliver project requirements, develop solutions and meet deadlines.

• Design the conceptual and logical models.

• Design and develop the reusable survey framework process

• Develop the unix scripts for files exports from Teradata and send the generated files to third party application via NDM

• Implemented generic metadata driven data quality rules check

• Improved operations by working with team members and customers to find workable solutions.

• Created generic process to receive the inbound files from third party system.

• Work effort estimations

• Managing the good relationship with the client and stakeholders

• Providing the quality service by establishing and enforcing organization standards. And reviewing the completed tasks to ascertain compliance with standards

• Ensuring that the company's data and information are protected from unauthorized access

• Promptly escalate issues, which affect product delivery and quality that are beyond scope of influence and report same to reporting manager

• Provide accurate and detailed weekly task reports

• Documented technical specifications and project testing methods for future reference and other assignments.

• Recommended and executed plans to improve development tools and processes. NTT DATA, INC April 2013 to March 2019

Business Intelligence Specialist

Bangalore, Karnataka

• Involved in multiple Wells Fargo projects - WCDIR Portfolio (for Wholesale Credit Risk Reporting) WCDIR CORE, WCDIR Regulatory, WCDIR 2.0, FCC, WORC, WRAP, G&G and CDD.

• Responsible for project requirements discussion and analysis, estimation, process control, compliance monitoring, project delivery and production deployment support activities.

• Preparing functional requirements documentation, design flow diagram, ETL mapping, development tracker, deployment validation and unit testing documents.

• Environment setup across development, user testing and PROD/BCP

• Involved in requirements gathering with onshore/business team.

• Managed and supported the Offshore development process and provided all the technical implementation support.

• Managed server setup, code deployment and configurations.

• Produced the technical design document for the project implementation Managing the delivery schedule of each application phases.

• Worked with QA's and coordinated the defect fixes.

• Worked on SQL server to Teradata migration project

• Implemented the Coding Standards.

• Responsible for analysis of existing programs including performance, diagnosis and troubleshooting of problem programs, and designing solutions to problematic programming.

• Developed the ETL mappings in Informatica and SSIS tools.

• Deployed and Go-live on time.

• Involved in design the conceptual and logical model.

• Creating the objects (like Tables, Procedure, Functions, View etc.) in SQL server.

• Contributions Successfully Completed Functional Specification document.

• Successfully completed the SQL coding.

• Successfully completed Complex SSRS Reports.

• Successfully completed Query Performance.

Genisys Information System (India) Pvt. Ltd. August 2011 to April 2013 Assistant Consultant

Bangalore, Karnataka

• Worked for Media Advertisement projects. Aegis is a major Media Service provider in UK, having presence in more than 80+ countries which provide the clients the media services.

• Involved in design the conceptual and logical model.

• Responsible for developing new programs and proofing the program to develop needed changes to assure production of a quality product.

• Provided assistance to testers and support personnel as needed to determine system problems.

• Designed and developed the Data warehousing/OLTP design for Media Domain.

• Designed and developed the replication in SQL Server

• Designed and developed the complex SSIS ETL packages and reports

• Integrated the dimensions and facts in Dundas dashboard

• Designed and developed the automation packages in production environment.

• Worked on complex existing Cubes and Analysis database.

• Worked on Complex stored procedure for application. Aroha Technologies June 2009 to August 2011

Software Engineer

Bangalore, Karnataka

• Worked for Genisys software. Genisys is an integrated IT and ITES Outsourcing company. To capture their business processing, they have an Excel system where BPO Metrics related data is still stored and they are including manual resource to perform KPI calculation.

• Created proof-of-concept prototype applications for demonstration and evaluation purposes.

• Introduced automation tools to reduce redundancy and enhance workflow.

• Analyzed solutions and coding fixes for software problems.

• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes. Education and Training

ANNA UNIVERSITY CHENNAI April 2009

BACHELOR OF ENGINEERING: Electronic & Communication Engineering Tamil Nadu

Overall percentage: 69%

GOVERNMENT OF TAMILNADU April 2006

DEPARTMENT oF TECHNICAL EDUCATION: Electronic & Communication Engineering Tamil Nadu

Overall Percentage: 85.54%

KKMHS School April 2003

10th Matriculation: Matriculation

Overall Percentage: 69.63%

Certifications

• Data warehousing (DWH) concepts, NTT Data - 2013

• Microsoft Business Intelligence Tools (SSIS/SSRS), NTT Data - 2014 Awards and Recognitions

• Received Outstanding Contribution Award, NTT Data - May 2014

• Received Outstanding Contribution Award, NTT Data - Sep 2015

• Received Team Award, NTT Data - Feb 2015

Contact this candidate