Candidates About

 

Mr. Srikanth Gorle

pROFESSIONAL SUMMARY

Ø  10 years of total IT experience with vast exposure in Data warehousing technology, ETL Design and Development, Quality Assurance and Application Value Management.

Ø  Major domain experience areas: Health care, Media and Entertainment, Retail and Telecom and Pharmaceutical

Ø  Expertise on tools like Informatica 9.x, Toad for Oracle SQL, SQL Assistant for Teradata, HIVE and HBASE for Hadoop, Putty Vi Editor Commands, WINSCP and COREFTP, HPQC and also Job scheduler Control-M.

Ø  Very good experience on End-To-End Planning, Estimates, Architecture/Design and Development phases of SDLC.

Ø  Extensively worked on databases like Oracle, Teradata and SQL. Written complex queries to achieve and implement business logics.

Ø  Experience in tuning existing complex queries contributing to performance improvement activity.

Ø  Strong experience in Project Requirement Gathering – having vast exposure on both Waterfall Model (around 4 years) and also on agile methodology (2 years).

Ø  Extensively involved in Data Analysis, ETL Solution Designing and perform unit testing. My ETL Solutions involved exploring the capabilities of Informatica Tool like:

o    XML – reading XML sources as source level objects (both normalized and de-normalized), also worked on XML mid-stream operator (XML Parser) to parse the XML data and finally have experience on XML targets/generators as well.

o    Worked on Power Exchange CDC to implement Near Real Time capabilities.

o    Have exposure working on LDAP processing the Employee ID and managing them in a secured environment.

Ø  Stepping into many roles during Project Build Phase:

o    ETL Technical Team Lead, Project Module Lead

o    Business Analyst, ETL Designer, ETL Developer,

o    Quality Defect Analyst

Ø  Expertise in leading teams and delivering the milestones as per schedules.

Ø  Excellent communication skills in handling with all the stake holders and clients by properly articulating and presenting the problem/solution options available.

Ø  Have strong delivery lead skills and a good team player, problem solver and quick learner. Have strong analytical skills with proficiency in debugging, problem solving.

 

 

 

Education

 

Bachelor of Engineering in Mechanical Engineering from Andhra University, Andhra Pradesh, INDIA

 

 

 

 

 

 

TECHNICAL SKILLS

 

DBMS/RDBMS	Oracle 11g/10g/9i, Teradata and DB2
ETL Tools	Informatica, HIVE, Talend.
Scheduling Tool	Control M
XML Technologies	XML, XSD, SOAP and WSDL
Source/Target Types Handled	Database Tables, Flat Files, Fixed Width Files, XMLs, XSDs, CDC, SFTP, CSV Files, Web Services, Queues and Topics, LDAP and many more.
Defect/Bug Tracking	HPQC, JIRA
Other tools	RSA, Putty, WinSCP, FileZilla, Soap UI, MS Visio, Great BI,
O/S & Environment	Windows XP, UNIX, Linux

 

 

 

Clients/Projects brief

S. No	Project	Client	Technology/Domain	Duration/Period
1	Pinpoint	COX Communications  , GA, US	ETL Informatica, Oracle/ telecom	June 2017- Till date
2	Segmented Services	COX Communications  , GA, US	ETL Informatica, Oracle/ telecom	Jan, 2017 – June,2017
3	EDW Migration	T Mobile, WA, US	ETL Informatica, Hadoop/Telecom	Feb, 2016 – Dec, 2016
4	Consolidated Subscriber Reporting	T Mobile, WA, US	ETL Informatica, Teradata/Telecom	May, 2015 – Jan, 2016
5	JEDI	Johnson &  Johnson  , NJ, US	ETL Informatica/ Pharmaceutical	Sept, 2014 – Apr, 2015
6	As Maintained Database (AMDB)	Dell, TX, US	ETL Informatica/Retail	Oct, 2013 – Sept, 2014
7	TIRKS  Migration	Frontier Communications, GA, US	ETL Informatica, Metasolv M6/Telecom	July, 2013 – Oct, 2013
8	Business Processing and Monitoring (BPM)	Walt Disney, FL, US	ETL Informatica/Media and Entertainment	Oct, 2012 – July, 2013
9	Sales Cost Data Warehouse	GE, OH, US	ETL Informatica/Aviation	Feb, 2012 – Oct, 2012
10	Zone Service Dashboard	GE, OH, US	ETL Informatica/Health Care	July,2011 – Feb, 2012
11	Head Count Cost Center Hierarchy	GE, OH, US	ETL Informatica/Corporate	Oct, 2010 – July, 2011
12	Best Buy Communication Satellite Mobile Messaging	BestBuy	ETL Informatica/Retail	Apr, 2010 – Sept, 2010
13	Honda Customer sales	Honda Motors	ETL Informatica/Sales	Mar, 2007 – Nov, 2009

 

 

 

 

 

My DAILY WORK DETAILS – Project SDLC

 

 

My Role in Project Requirement Gathering

 

Have vast exposure on both Waterfall Model (around 7 years) and also agile methodology (2 years).

 

Waterfall Model:

·         I have effectively worked on various project phases in both Fixed Bid and Embedded types of projects. Most of my IT industry projects followed Waterfall Model and have good experience and hold on the SDLC.

·         Driven the projects end-to-end flowing through all the phases technically and also with good management skills.

 

Agile Methodology:

·         Extensively worked on Sprints spread across many Iterations in Agile Project (T Mobile and J&J in CapGemini). Used JIRA tool and Rally to break the activities into small work packages to facilitate task delegation to the team members.

·         Effectively monitored the tasks that were carry forwarded from previous sprints to further until its completion. Ensured the story points in the JIRA tasks and Rally Tasks are in sync with the summarized effort numbers.

·         Weekly monitored and generated reports out of the tasks completed and reviewed it with the management for feedbacks and comments.

 

Other Tasks:

·         Involved in driving initial meetings and discussions in order to understand the basic needs/objectives of the project. Scheduled meetings with Stakeholders, Clients, End Users, Customers, and Business Analysts etc to gather requirements.

·         I have hosted war room sessions to discuss, identify and decide the roles and responsibilities of each stakeholders. Also to timely follow-up for the action items and have them tracked effectively until completion.

·         Identified the team or people behind the information sources and to consolidate all the project requirements. I have identified the potential assumptions and have them verified against each requirement KPIs.

 

Requirement Gathering:

·         Categorized as Technical and Business requirements, noted them and analyzed in terms of requirement gathering. First step I have gathered the Business needs of the Project, Reason behind the project, and Main objective of the project.

·         To relate and connect the Business needs to the technical aspects available to our capabilities. Initiated and conducted technical POCs related to the decisions made during the meetings and provide supporting documents for review. Submit various proposals based on the prior experiences considering the cost and efforts involved.

·         To make sure we have all the necessary inputs for our Ball Park estimations supporting effort figures closely to the actuals. Ensure there are no blockages or any technical hick-ups related to configurations and accesses/licenses.

·         Maintain and manage all the project related documents in the SharePoint and have them officially approved initiating an approval through SharePoint workflow. Walk through the BRD document back to the Clients or with the Authors to ensure and confirm our understandings are as per their expectations. I have identified the risks and also have them noted with mitigations to be further agreed and signed by Stakeholders.

 

Ownership taken during Data Analysis, Design and ETL Solution

 

Owned and worked on the design portion of the BI Data Flow, to decide the solution approach.

 

·         To review and to work on the peer comments to have discussions finalizing the ETL Solution (both technical and business related). Proactively ensure if there are any data volumetric challenges and consider them as an input to the design phase.

·         Addressed various kind of issues during data analysis phase - Integrity Issues, Data Issues, Process Improvements, Access Issues, and Data Security Issues etc. To note down all the risk factors along with their mitigations and have them validated in advance.

·         Collate and integrate the ETL Solution proposed and have them reviewed and approved by the management and architects. Ensure we have all the necessary details and points in BRD Document and have it reviewed. Also to conduct POC (Proof of Concept) for any kind new technical approach or solutions provided.

·         To check the new capabilities of a Tool or an Application in order to have it used during the requirement implementation (Build Phase). Prior concluding on a particular technical approach, ensure that we have put all necessary efforts in exploring all possible options available. To document the need and the reason behind the architectural decisions made and also to support the design proposals.

 

 

Project Build Phase: My day-to-day activities

 

Stepping into many roles during Project Build Phase:

Technical Team Lead

Project Module Lead

Business Analyst

ETL Designer

ETL Developer

Quality Defect Analyst

 

·         Building HLD document having reference to many other supporting documents. To come up with the list of all the object inventories that would be used in the Project Build Phase. Include the assumptions made during the requirement phase and provide more details over it.

·         Creating LLD or SSD documents considering the available information and approved documents. Provide a complete and detailed column to column mapping business logic along with pictorial representation for ease of build to the developers.

·         Provide all necessary KT to the peers and to the team to kick start the development phase.  Ensure we have the right and correct Object Inventory prior the development phase.

·         Draw process improvement plans and have them followed during all the project phases. To provide and conduct necessary trainings and KT sessions to the team mates and junior resources on new capabilities.

·         Conducted constant meetings and discussions with the Client to report and resolve the issues during Build Phase. To implement the best practices like reusability, ETL standard adherence, Peer Review, Code Migration Checklist etc.

·         Include and involve testing teams during various project phases facilitating them for test case preparations. Exclusive data mocking to test and check the Ideal Case Scenarios.

·         To perform negative testing and include them as part of the regular test cases.

·         System configuration related best practices implementation like parameterization and comments addition etc. Timely monitor the progress of the project tasks and regular task health check and progress reports.

·         Ensure we follow all the standards in terms of process in order to avoid configuration related defects (Example: To follow Code Checklist). Timely demonstrate the deliverables to the client or stakeholders in order to check if the approach followed is as per their expectations.

 

 

 

Out of Box Activities

 

Playing a dual role as Technical Lead and Project Manager, I have contributed a lot in team building activities and also in grooming resources for maximum utilization.

 

·         Having all the Project related documents saved in the SharePoint for reference. Manage Technical Project Documents as assets enabling the industrialization implementation. These will or may be used for similar upcoming projects as valuable inputs.

·         Cross training resources to improve them technically and also to obtain complete resource utilization. Ensure to document the 'Lessons Learnt' during the project tenure and have the document reserved as the Organization Asset for further reference.

·         Creating SR to Informatica Inc. - related to any Power center product issues (SFTP - Parameterization Failure, Special Chars Handling).

 

 

 

 

 

 

professional experience

 

1. Project Name:	Pinpoint DSM
Client	COX Communications, USA.
Role	ETL Lead
Environment	Informatica, Oracle
Team Size	10
Duration	June 2017  to till date

The purpose of the OSCAR Upgrade program is to set up a PEGA 7 infrastructure enabling future multi-channel implementations of customer offers.  The Project targets to deliver personalized propositions to Cox customers via the web and Care channels, using the Pega 7 Decision Strategy Manager Framework

 

Some of the key functionality that will be provided in this project includes:

·         Offer decisions for all COX customers.

 

 

 

 

 

• Requirements Gathering & Understanding
• Experience in creating High Level Design Document, Low Level Design document.

• Validation of Reports against data in the tables.
• Defect Tracking & Code Drop.
• Conducted functional testing and regression testing
• Onsite/Offshore/Client Co-ordination
• Interaction with Client, Developers, Onsite Coordinator 
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• UAT support
• Working as an Onsite coordinator to coordinate with onsite and offshore team members to assign and to finish the task as per the schedule dates.

·         Updating and tracking sprint activities in Version One tool for scrum management.

·         Providing projects status on daily basis, Weekly on status calls to Delivery Managers

·         Prepare the lesson learned documents based on the previous defects  

          

 

 

2. Project Name:	Segmented Services
Client	COX Communications, USA.
Role	ETL Lead
Environment	Informatica, Oracle
Team Size	10
Duration	Jan 2017  to June 2017

CEX Segmented Services 2017 Enterprise Launch project builds on a 2016 pilot work in 4 markets to expand it into a nationwide launch in order to prioritize Cox “targeted” customers for top customer experience called treatments. Treatments that were defined to be in-scope for this project include:

·         Priority call queuing

·         Priority call routing to top agents

·         Priority trouble appointment scheduling

·         Routing trouble calls to top field technicians

·         Priority go backs.

 

Some of the key functionality that will be provided in this project includes:

·         Customer identification as “targeted” with a long term goal of segmenting “targeted” customers in several groups with each group receiving all or some of the treatments.

·         Offering “targeted” customer’s priority time slots during trouble ticket appointment scheduling.

·         Building order entry controls that will provide the guardrails needed to insure accurate order entry for trouble call related tickets of “targeted” customers.

 

 

 

 

• Requirements Gathering & Understanding
• Experience in creating High Level Design Document, Low Level Design document.

• Validation of Reports against data in the tables.
• Defect Tracking & Code Drop.
• Conducted functional testing and regression testing
• Onsite/Offshore/Client Co-ordination
• Interaction with Client, Developers, Onsite Coordinator 
• As a lead responsible for developing and guiding the team for ETL mappings towards data load using ETL tool Informatica Power Center 9.0.1
• Extensively used Informatica Client Tools: Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer to develop mappings.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Extensively involved in the Design and development of ETL Process flow.
• UAT support
• Working as an Onsite coordinator to coordinate with onsite and offshore team members to assign and to finish the task as per the schedule dates.

·         Updating and tracking sprint activities in Version One tool for scrum management.

·         Providing projects status on daily basis, Weekly on status calls to Delivery Managers

·         Prepare the lesson learned documents based on the previous defects  

          

 

3. Project Name: