Sathish Kumar Jeyakumar

adnv5o@r.postjobfree.com Contact No. 784-***-****

EXECUTIVE SUMMARY

Technology analyst with 9 years of experience in software development with a focus on SQL Server & Microsoft Business Intelligence (MSBI) Tools

Strong in SQL and possess good knowledge in performance tuning.

Been Onsite to Dubai for one year to work on the project delivery. The project was part of the lean six sigma (green belt).

Good knowledge in ELT concepts and utilized SSIS packages to extract data from various sources and created reports on top of it.

Lead the different teams across geographies and successfully delivered the release items.

Have knowledge in Devops and Microsoft Azure.

Good knowledge in implementing DMAIC principles.

Experience in various phases of SDLC, Agile and Kanban Model.

Worked as a Subject Matter Expert (SME) on defect prevention.

Possess excellent interpersonal skills and a team player.

Completed Associate Developer Certification in Dellboomi.

RELEVANT EXPERIENCE

Team Lead, Mindtree July 2019 - Present

Client: CIT

Technology: SSIS, SQL Server, Visual Studio, Sharepoint

CIT is a banking project and I was working as a Team lead for the project.

Integrated data from different sources and moved to regulatory reports. Used different transformations including Lookup, Data conversion, Derived Column and Source/Destination Connection in building the packages and deployed them in multiple environments.

Improved performance of the SQL code by analyzing the execution plan and implemented necessary indexes.

Made use of CTEs to dynamically add parameters to the views and improve the performance.

Automated the data transfer between different environments and reduces the PD efforts by 20 percent.

Lead the team of eight members across two tracks and provided regular updates to the business stakeholders and team management on the status of the project.

Worked on DP Metrics, Release (Sprint) Planning and CM Audit.

Took responsibility and worked effectively on Metric Calculation on Monthly and Weekly basis. Made sure all the metrics are calculated during the SDLC.

Mentored junior team members on technical challenges and provided guidance on the best practices to be followed during the code development.

Worked in Risk/Impact analysis of the new development items, Code Review and track on the team progress in daily tasks.

Handled escalations and prioritized release items based on bandwidth of the team.

ETL Developer (Chennai), Infosys Jan 2019 – June 2019

Client: Microsoft

Technology: Power BI, SSIS and SQL Server

Imported data from various sources such as flat file, excel, raw file and OLE DB database.

Worked in developing test cases and complete the unit testing and support system testing.

Supported other developers in providing technical assistance and development solutions.

Solution Lead (Dubai), Infosys Jan 2018- Dec 2018

Client: McDermott

Technology: SSIS, SQL Server, Tableau, Dellboomi

The project was part of the Lean Six Sigma (Green belt) initiative. I was working as solution lead for the project.

Improved quality performance and client satisfaction while achieving $135K cost savings.

Followed DMAIC principles and Kanban Model for development.

Identified various bottlenecks and prioritize them through Measuring & Analyzing techniques (Fish bone Diagram & Pareto Chart).

Supported in developing dashboard-using Tableau, which will store errors and validation failures from different systems.

Worked in Cloud Integration platform (Dellboomi) and completed Associate Developer Certification in Dellboomi.

GAMS Support, Infosys Jan 2016-Dec 2017

Client: McDermott

Technology: SSIS, SQL Server, Service Now, Visual Studio, Oracle.

Worked as part of the Global Application Maintenance and Support team for the McDermott.

Worked in handling the tickets from Service Now and attained SLA compliance.

Provides analysis of problems while working toward solutions to technical issues

Use SCRUM/Agile development methodologies.

In charge of collecting data. Processed given data to the desired format and generated production, quality, and analytical reports.

Participate in the full software development life cycle: Analysis, Design, Coding, Testing, Training, and Operational Support

ODS Developer, Infosys Jan 2014-Dec 2015

Technology: SSIS, SQL Server, Oracle

Developed Project Analytical and reporting services for McDermott International Inc.

Involved in the architecture of ODS.

Developed interfaces in SSIS / SQL server to collate data from multiple systems into Data Mart

Developed Technical Specifications Documents by understanding the functional requirements.

Co-Anchored presentations and Solved complex problems during DEMO’s and Client presentations

ODS Developer, Infosys Mar 2013-Dec 2013

Technology: SSIS, SQL Server, MDM

Developed Master Data Management (MDM) for McDermott International Inc

Took part in the design and architecture of Operational Data Store.

Worked in the moving the MDM (Master Data Management) information to DataMart for reporting functions.

Have a good exposure on EBX MDM environment and good functional knowledge in MDM concepts.

Developed interfaces in SSIS / SQL server that performs data communication from one system to another.

Acted as DP-Anchor by conducting regular and progressive meetings to reduce defects.

Developer, Infosys July 2012-Dec 2013

Technology: SSIS, SQL Server, SSRS

Formulated ADHOC reports for East BI reporting project, Time Warner Cable

Built ADHOC reports using SSRS and created SSIS packages for data transfer of regional data

Performed Query optimization for faster report generation

Developed and deployed ETL jobs and hosted the reports

Received best team award for quick and quality deliveries.

SKILLS

Domain : Business Intelligence

Design knowledge of relational databases, optimization, indexing, data warehousing and concepts. Skillful in Defect prevention and configuration management

Expertise in Operation Data store (ODS) & Datamart

Expertise in Material Management Systems (MMS) concepts.

Expertise in Application Maintenance and Support.

Expertise in Master Data Management (MDM)

Tools : MSBI-SQL Server, Dellboomi, SQL, SSIS, SSRS, SSAS, Tableau

Databases

: MySQL, Microsoft SQL Server 2012, Oracle.

Languages : C, C++

Operating Systems : Ubuntu, Windows 7, Windows 8

RELEVANT PROFESSIONAL DEVELOPMENT

Professional Skills and Development course Infosys.

RDBMS concepts with help of Oracle, Infosys Training academy

Implementation of Devops, Mindtree

EDUCATION

B.E in Computer Science, Anna University, Chennai 2007- 2011

Secured First Class with Distinction -75%

OTHER

Language skills: English, Tamil (Native)

Contact this candidate