Candidates About

 

Sunil Kumar Kaki

Profile Summary

v  IT Professional with 9.3 Years of commitment to excellence in the Implementation of best practices and specializing in Data Integration, Data Visualization and Mainframe technologies.

v  Professional experience in all the phases of Software Development Life Cycle (SDLC). requirement analysis, architecture, design, development, testing, documentation and post implementation revisions using Agile and Waterfall Methodologies.

v  Having 4+ Years of experience in Data Warehousing and implementation of ETL applications using Informatica Power Center 9.x

v  Hands-on experience using Informatica Power Center 9.1 (Repository Manager, Designer, Source Analyzer, Target Designer, Transformation developer, Mapplet designer, Mapping designer, Workflow Manager, Workflow Monitor).

v  Strong experience in Extracting, Transforming, Loading (ETL) and maintaining of Data Warehouses and Datamarts, handling large data loads, automatic error handling, performance tuning for bulk data.

v  Knowledge in Database architecture for OLAP and OLTP applications to model the snowflake and star schema's and report delivery methodologies

v  Proficient in the Integration of various data sources like Oracle, SQL Server, DB2, Netezza Ms-Access, COBOL, Mainframe, Excel, XML, VSAM files and Flat Files 

v  Experience in UNIX shell scripting and automation of jobs 

v  Proficient in SAP Business Objects 4.1/4.0 with  IDT, BI Launch Pad, Info View, Web Intelligence and Tableau 9.2.

v  Proficient in designing and developing universes using Universe Designer Tool and Information Designer tool and creating ad-hoc reports using Web Intelligence.

v  Provided multiple demonstrations on Tableau functionalities and efficient data visualizations approaches to the senior management at the client as part of the BRD.

v  Proficient in design and development of various reports like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.

v  Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.

v  Experience in Creating Complex, optimized SQL Queries along with excellent data analysis capability.

v  Expertise in working with various database systems such as DB2, SQL Server 2008, Netezza, Oracle, Pl/Sql

v  5+ Years of Strong experience in Mainframe Technologies like COBOL, CICS,DB2,VSAM,JCL, Easytrive and IBM Tools & Utilities.

v  Good knowledge & hands on experience in working with most of the Mainframe tools & utilities like File Aid, Change Man, SPUFI, QMF, Control-M, BMC Tools, File Manager, Syncsort  ,DFSORT, ICETOOL.

 

v  Monitoring production batch operations in GUI and Mainframe Control-M tools and support them to fix issues.

v  Participated in performance improvement activities for both batch and online modules.

v  Good working experience in Coordinating and Supporting the Development, Testing and Deployment of Project in Off-Shore/On-Site model.

v  Experience in working with cross-functional groups, different levels of management and liaison between system users, company management and development team.

v  Ability to quickly adapt to different project environments and an excellent team member.

v  Excellent interpersonal and communication and presentation skills along with Time management.

v  Exposure in cloud computing like Service Now and Amazon Web services

v  Certified Service Now Admin

 

Technical Skills

 

Programming Languages: COBOL, CICS, JCL

Scripting Languages: Java Scripting,VB Scripting, Unix Shell scripting,

Databases: Oracle 10g/9i, MS-SQL Server, Netezza, DB2 UDB , VSAM, MS Access.

Data Integration Tools: Informatica Power Center 9.x, IBM Info Sphere 9

Data Visualization Tools: SAP Business Objects 4.0/4.1 and Tableau 9

Cloud Computing: Service Now ITIL tool

Operating Systems: Windows, Linux

Web Development: HTML, CSS, SharePoint Design

 

Education and Certifications:

v Bachelor’s Degree in Computer Science & Engineering from JNTU Hyderabad, India

v Certified Service Now Admin

 

 

 

Professional Experience:

Client: Confidential, San Antonio, TX                                                               May ’17 – Current

Service Now Analyst

Project: Confidential

Responsibilities

·         Involved in reporting requirements from project and Business users to understand business needs and prepared technical specifications.

·         Created various reports in Service Now and scheduled

·         Utilized the Service Now Service Catalog for users to create Service Requests and Service Items.

·         Worked on Service Catalog and implemented new functionality using Business Rules, UI Policies, and Access Lists etc.

 

 

 

 

 

 

 

 

 

Client: Confidential, San Antonio, TX                                                                       Jan ’17 - Apr '17

Business Intelligence Lead

 

United Services Automobile Association (USAA) is a Fortune 500 financial services company focused on providing banking, investing, and insurance to people and families that serve, or served, in the United States military and other selected federal agencies. It offers life insurance, auto and property insurance, banking facilities and investments (Mutual Funds, Brokerage Accounts). It offers various schemes for Retirement planning for its members.

 

Property and Casualty Operational Reporting team provides business partners with information/data, reporting and tools to drive and support decisions. The team’s mission is to provide trusted, quickly and easy reporting, create automated or self-service options for customers, develop robust tools and deliver certified data to address ad-hoc needs.

 

Responsibilities:

 

·         Involved in requirements from initial phase of the project and vendor Interacted with Business users to understand business needs and prepared technical specifications.

·         Implemented BI Reporting suite consisting of a comprehensive set of industry specific dashboards and reports to provide insights deliverables.

·         Emphasized on Data Integrity to good chart aesthetics, used customized templates and also created visualizations from scratch to build new templates for better understanding and better decision support.

·         Resolved in troubleshooting the visualizations for various problems faced during data connectivity and data display.

·         Worked with SAP Business Objects BI 4.2/4.1 Suite tools (IDT, BI Launch Pad).

·         Created multiple universes using IDT, business friendly classes, objects, complex measures by providing different business views by including contexts, aliases and derived tables.

·         Defined Hierarchies in universe to provide the users with drill down option in reports and pre-defined conditions.

·         Created Webi Reports in info view and BI launch pad with slice and dice, drill up and drill down, hyper link functionalities to make business analysis easier.

·         Provided data and analysis extensively for ad-hoc requests which uses multiple sources.

·         Review reports, dashboards and universes to meet best practices.

 

Environment: SAP Business Objects 4.2/4.1 (IDT, UDT, BI Launchpad),Netezza, DB2-SQL, SQL Server,  Oracle

 

Client: Confidential, San Antonio, TX                                                                      Jan ’16 - Dec '16

Informatica Developer

Project: P&C In-force Application migration project.

Description:

USAA is a fully integrated insurance & financial services company in United States of America serving more than 10 million military members. Our client is a US based Insurance major company. In-force application accurately reports the P&C product count of policies In force(PIF) and Vehicle In Force(VIF).Varies views of reporting are delivered weekly and monthly at company level ,Line of Business level, Risk level , Eligibility level and combination of these. This information assists analysts and senior management in defining marketing and pricing business initiatives that maintain USAA's competitive edge and high quality of service. The primary business users of this application are P&C Marketing, Corporate Marketing and P&C competitive analysis. The purpose of the project was to migrate from Mainframe legacy code to marketing datamart. Informatica was the ETL tool used in the new system. I was part of rule mining, requirements gathering, coding and testing of the project in Informatica. The migration was implemented in Informatica Ver9.1. UNIX, Putty, Control-M Enterprise Manager etc were also utilized to implement the project.

 

Responsibilities:

• Preparing technical specification document for the requirements including key project assumptions, technical flow, process flow, ETL design document, logics and Error handling.
• Preparing Source to Target documents after having the discussions from Business leads
• Coordinating with Business team for functional requirements.
• Providing technical and functional knowledge to team members from Onsite
• Involved in ETL low level design and prepared design document for each of the target table
• Created complex Informatica mappings various transformations
• Created re-usable transformations/mapplets and used across various mappings
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created Control M jobs to schedule Informatica Workflows
• Executed workflows using Control M schedule
• Involved in the performance tuning.
• Supported during QA/UAT/PROD deployments and bug fixes
• Leading the nearshore and offshore team.
• Involved in code Reviews as per ETL/Informatica standards and best practices
• Provided support to the system testing and resolve issues raised by system testing team
• Worked with release management team to migrate the ETL code to Test and Production servers from development servers by creating CI list and Request for Change (RFC) of the process

 

Client: Confidential, San Antonio, TX                                                                      Jul ’13 - Dec '15

Informatica Developer

Project: Statistical Reporting System

Description:

Property and Causality insurance companies are required by laws and regulations to prepare extensive

Statistical reports for State insurance departments to help them to meet their regulatory responsibilities.

Each state may designate a statistical agent/Bureau to collect the statistical data. This agent publishes a

Plan of the data elements and codes that insurers must use to submit premium data at coverage level

And loss data at the claimant level for all lines of business written by the company.Failure to comply

With statistical reporting requirement could results in fine and potential loss of license to do the business in State

 

Statistical reporting system will provide the property and Causality insurance premium and loss data to the various statistical Bureaus and Agencies

 

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Involved in the analysis of source to target mapping provided by data analysts.
• Coordinating with Business team for functional requirements.
• Providing technical and functional knowledge to team members from Onsite
• Involved in ETL low level design and prepared design document for each of the target table
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS
• Created re-usable transformations/mapplets and used across various mappings
• Created completed informatica mappings to load dimensions and facts to EDW area
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created Control M jobs to schedule Informatica Workflows
• Executed workflows using Control M schedule
• Involved in the performance tuning.
• Supported during QA/UAT/PROD deployments and bug fixes
• Leading the nearshore and offshore team.
• Involved in code Reviews as per ETL/Informatica standards and best practices
• Provided support to the system testing and resolve issues raised by system testing team
• Worked with release management team to migrate the ETL code to Test and Production servers from development servers by creating CI list and Request for Change (RFC) of the process

 

 

State Farm Insurance, USA                                                                                     Feb ’12 - June '13

Mainframe Developer

Project: Policy Master Record Update

Description:

 

State Farm Insurance is a group of insurance and financial services companies in the United States. The company also has operations in Canada. The group's main business is State Farm Mutual Automobile Insurance Company, a mutual insurance firm that also owns the other State Farm companies.

 

State Farm has a dedicated Property & Casualty application team that takes care of maintaining all the legacy applications. Property and Causality being the main forte of State Farm’s business the maintenance of all the applications coming under the Auto Systems umbrella is absolutely crucial. Policy Master Record (PMR) Update is one of the many applications that are part of State Farm Auto Systems. PMR Update is legacy batch application which takes care of holding and maintaining all the State Farm Auto policies information.

 

Responsibilities:

 

§  Responsible for translating Business requirements into technical specifications.

§  Detail Design Document preparation.

§  Code analysis and documenting the business rules..

§  Interaction with SME for the KT sessions for gather knowledgeable on applications

§  Coding and unit testing

§  Creating the Flowchart and coding of application programs using Cobol and DB2.

§  Developed JCL’s, procedures as per the client standards and Execute the batch module using JCL.

§  Submitting the batch jobs (JCL) via IBM Control-M tool and create the required batch dependencies.

§  Modified the existing online programs using CICS.

§  Preparing UTP and UTR and Prepare the components to move them to production environment

 

 

 

 

 

HSBC, Brazil                                                                                                            Dec ’09 - Dec '11

Mainframe Developer

Project: HSBC Core Banking

Description:

One HSBC Project is aimed at Standardizing all the Core Banking Systems across HSBC. The project will replace 55 separate core banking systems, 24 credit card systems, 41 internet banking systems and 40 desktop standards with the Single One HSBC Platform.  One HSBC will be able to support 10 million accounts. One HSBC aims to improve customer services by giving the bank a single view of customers while reducing costs through streamlining IT and operations. The platform will also reduce the cost of setting up new banking operations.

There are 10 modules in One HSBC core banking.

Account maintenance, Account Value, Fees and Interest. Product and parameters, Bulk Input, Exception Management, Taxation , Cheque Management, Statement, Advice and report, Operational Account.

All the above modules or work streams are inter linked each other.

Bulk Input one of the above module which I extensively supported .In a short, Bulk Input is one of the core components of HSBC Core Banking. Bulk Input component provides functionalities related to processing of Bulk Value and non value Transaction coming from different sources and guiding them to various destinations. Bulk input is one of the system utility components that provides services for the receipt and processing of transaction files. 

 

Responsibilities:

 

·         Involved in preparing technical specifications.

·         Involved in Preparing UTP and UTR.

·         Involved in Coding and Unit Testing.

·         Prepared JCL’s for total work stream.

·         Involved in Batch Support.

·         Code Reviews.

·         Mentoring the New Joiners

·         Involved in SIT, UIT Defect Fixing.

·         Trams AG sync up activity.

 

HSBC, Mexico                                                                                                       Oct ’08 - Dec '09

Role: Mainframe Developer

Project: HSBC Mexico Upgrade

Description:

GCD (Global card development) project for HSBC.here we are doing global enhancements for the HSBC credit card system. Part of GCD HBMX Upgrade is one of the up gradation projects.

         Currently HBMX is using the Whirl version 2.0 since October 2004, since then, a lot of enhancements and customizations have been made in order to support the growth and business strategy for the Mexican market.

 Besides this, every year many new requirements are received in order to continue supporting the growth and most of these requirements are local, some of them are regional based on the recommendations from the schemes and few of them are result of some global fixes as a part of HBMX Upgrade

 

Responsibilities

·         Part of base team, involved in analysis of the components those were impacted.

·         Preparing the functional and technical specs 

·         Involved in coding of impacted components and review.

·         Involved in unit testing of components which are coded and review.

·         Component level analysis for custom Enhancements

·         Control record documentation for Custom Enhancements

·         Preparation of Conversion strategy

·         Identify files impacted by CUSTOM

·         Coding and unit testing conversion routines

·         Data mapping between gold 2.0 to 4.3 by using data mapping tool (DMT).

·         Data validation for the converted files by using data validation tool (DVT).

·         Involved in internal mocks

·         SIT/UAT Defect Support

 

 

HSBC, USA                                                                                                           June ’08 - Oct '08

Role: Mainframe Developer

Project: HSBC Compliance 8.2

Description:

This Project is Fall Compliance, here On Account of changes in regulations; business rules etc. of ICA (schemes) viz. VISA and MasterCard, the software systems like Vision PLUS which are catering to credit card services undergo code modifications or addition. The schemes release these mandatory changes twice a year. Subsequently FDI code gets modified with corresponding changes. And FDI then releases these fixes/ changes to impacted business units in order to make them Compliant with VISA/ MasterCard.

 

The project of taking the compliance fixes (code changes) into various layers of WHIRL architecture is called Compliance in GCF

 

Responsibilities

 

·         System Analysis.

·         Preparation of High Level & Low Level Design Documents.

·         Program Coding.

·         Reviews.

·         Testing.

·         System test, UAT Support

 

 

CAREER PROFILE

 

Period	Organization
Jan 2012 – Till Date	Tata Consultancy Services Pvt Ltd
June 2008 – Jan 2012	Capgemini India Pvt Ltd