Home

Siva Kumar - Data Analyst

[email protected]

Location: Princeton, New Jersey, USA

Relocation: Yes

Visa: H1B

Sivakumar Bojan Mobile: +1 848-328-0954 Email: [email protected] Qualification Summary: 17+ years of experience in Data warehousing and Business Intelligence with Relational data sources along with 10+ years of data visualization using Tableau, Cognos, Business Object,and 4+ years of experience in Data warehousing data modeling - Star Schema, Snowflake Schema, and 2+ years of experience using Snowflake DB. Experience in managing complex projects from inception to completion and dealing with sensitive and confidential information and matters. Good experience in AWS with ETL tools, Data Analyst. Extensive experience in developing prototypes of BI dashboards using mockups POC s for KPI trend analysis and working with onsite and offshore teams to manage Extract, Transform, Load (ETL) processes to feed BI dashboards. Worked with ticketing and release management systems such as JIRA and ServiceNow, for sprint releases and resolving issues. Excellent troubleshooting and debugging skills and experience in writing and debugging complex SQL Extensive experience in Agile methodology, experience in gathering Requirements, Analysis, Design, Development, Deployment, Testing and SupportETL pipeline and Report. Tremendous experience in interacting with clients, stakeholders and documenting the requirements and partner with other teams on broader changes to the Core KPI related dashboards. Written complex SQL Queries for analyzing data in different databases like SQL Server, Oracle, Teradata and DB2. Expertise in troubleshooting ETL workflows, SQL issues, Access issues and Server Issues, monitor batch cycles, analyze failures, fixing the issues or escalate the problem. Provided production support to the existing Tableau reports and involved in performance tuning to optimize the functionality of dashboards. Had experience in data modelling using Star Schema Modeling, Snowflake modeling, fact and dimension tables, physical and logical modeling. Experienced at creating effective Test data and development thorough Unit test cases to ensure successful execution of the data. Good understanding of Business Requirements and Process Management added with my proficiency over DWH concepts and reporting tools, helped me translate end user needs into perfect software solutions. Experience in all phases of Software Development Life Cycle (SDLC). Very Good experiences in different kind of projects like 1. Development 2. Enhancement 3. Data Migration / Application migration 4. Platform/Admin support 5. Release management from lower to higher environment project 5. Automation project 6. Testing project 7. Production support and Application support (L1, L2 and L3 support) project. Played Onsite Lead role in USA 1.8 years in Onsite-Offshore Delivery model. Interacted with Client Program Manager, Business analysts, Dev leads and other stakeholders to document and understand business requirements, functional requirement, and design specifications for new applications in addition to enhancements to existing applications. Right blend of functional and technical knowledge with ETL Tool: Talend, Informatica, Airflow (under AWS / Google Cloud Platform), Storage: AWS S3 bucket, Azure Blob/Containers, Google cloud platform - cloud storage), Database: Snowflake Database under AWS/Azure platform, Oracle, PostgreSQL/Greenplum, SQL, Teradata, DB2, Server: Linux/Unix server (FTP/SFTP). Reporting tool: Tableau, Cognos, BOXI, OBIEE, Others: Data Modeling SharePoint for document repository, Service Now as ticketing tool. Experience analyzing and interpreting data and insights, performing data blending and UAT testing for BI dashboards. Experience in Effort Estimation, team management, work allocation, tracking of tasks, status reporting and onsite-offshore coordination. Right blend of technical knowledge with Talend Admin. Self-directed with a high energy level. Accepts responsibilities and job duties eagerly. A skilled problem solver and an efficient team player and Lead with good communication skills, work ethic and ability to work well in a team or individual. KEY SKILLS: Functional: Team Building, Project Management, Team Leader, Strategic/Tactical Planning, Data Analyst, Data Engineer, Business Analysis and Development, Excellent Communication, and Interpretation skills Technical: ETL Tool: Talend, Informatica, Airflow (under AWS / Google Cloud Platform), Storage: AWS S3 bucket, Azure Blob/Containers, Google cloud platform - cloud storage), Computing: AWS EC2, Azure VM resources, Data Lake storage: AWS Athena, Data management: Amazon Relational Database Service, GCP Big query Database: Snowflake Database under AWS/Azure platform, Oracle, Greenplum, SQL, Teradata, DB2, Server: Linux/Unix server (FTP/SFTP). Reporting tool: Tableau, Cognos, BOXI, OBIEE, Others: Data Modeling, SharePoint for document repository, Service Now as ticketing tool. Professional Experience: 01 Capgemini America INC Senior Data Analyst May2022 Till Date CLIENT: NBC Universal, USA Project:NBC_RTS & QA Managed Svcs2022 Description Enhancement on existing applications and Production support for medium and highly complex applications which loads data from different sources into target system. Responsibilities: Performs enhancement on existing applications based on user/business requirement along with L1 and L2 support for the applications and platform incidents as needed. As Data analyst for this project, responsible include extracting data using special tools and software, responding to data-related queries, setting up processes to make data more efficient, analyzing, and interpreting trends from the data, and reporting trends to add business value. Also, Performs L1, L2 and L3 support for applications and making sure data accuracy and on time data to business etc. Actively participated in the implementation of a POC to automate our Mongo DB cluster setup Monitored hosted applications through Mongo DB operator. Monitor production systems reliability, availability, and maintainability and escalate critical issues for resolution. Supporting the production environment which involves solving issues as they appear. As a Talend admin, Monitoring the Talend services on regular basis and make sure environment available. Talend Admin related activities which includes creating user/project, providing access to the projects etc. On Ticket basis, finding the RCA for the issues caused in TAC or in Talend jobs and resolving the same if any platform related issue. Manage wing-to-wing ticket responses Manage and resolve production incidents. Covers system outages, job failures, system defects, data defects and end user support. Software / Languages/ Special Tools:Talend, Airflow (Under AWS / Google Cloud Platform), Snowflake (Under AWS / Azure), Mongo DB,AWS S3 (Storage), AWS EC2 (computing purpose), AWS Athena (Data Lake storage), Amazon Relational Database service (Data management), Azure blob/container (Storage), Azure VM resources, GCP Cloud storage (Storage), GCP Big query (Data management), MS SQL Server, Linux, FTP, SFTP. 02 Capgemini India Senior Manager (Technical) Sep 2021 Apr 2022 CLIENT: BHGE a GE company Project: ICV UAE Phase II and ICV Qatar Program. Description The ICV (In-Country Value) program drives, measures, and monitors the added value brought to United Arab Emirates and Qatar by a supplier. ICV Dashboard provides a single solution to record & track the actual ICV score on a quarterly basis. Responsibilities: Involved RFP process, Interacted with Business Analysts/Users for Requirement gathering and Prepared Requirement analysis document, Low-Level and High-level design document accordingly. Design, Approach, Development, Testing, deployment, and postproduction support. Prepared project status report, attending daily call with Client and multiple stake holders to provide status etc. Performed both Technical and managerial Lead for 15 members Team. Involved effort estimation. Being an Offshore Manager, understand, transfer requirements to team, and delivered the project in time with minimal defects and overseeing the activities of Senior associates and Programmer Analyst. Software / Languages/ Special Tools:ETL Tool: Talend, Database: PostgreSQL/Greenplum, Oracle, SQL, Server: Linux/Unix server (FTP/SFTP). Reporting tool: Tableau, Cognos, BOXI, OBIEE, Others: Data Modeling, SharePoint for document repository 03 Capgemini India Manager (Technical) Jan 2020 Aug 2021 CLIENT: BHGE a GE company Project: Release Management Project / Talend Ingestion. Description Release Management Project: Release Management Team responsible for Migrate the code (Talend code and Green Plum) which developed by different project Teams from lower environment to Higher environment (DEV to QA and QA to PROD). Talend Ingestion: Load data from different source system (Like Oracle, SQL, MySQL, DB2, Teradata, SFTP/FTP server, BOX and SharePoint etc. to Greenplum database (Data Lake mirror layer environment) by using common framework. Responsibilities: Set up for data ingestion from different source system to Green Plum database as per business requirement. Also, taken care Issue/bug fixes on all 3 environment DEV/QA/PROD Software / Languages/ Special Tools: ETL Tool: Talend, Database: PostgreSQL/Greenplum, Oracle, SQL Server: Linux/Unix server (FTP/SFTP). Reporting tool: Tableau 04 Capgemini India Manager (Technical) Jun 2019 Dec 2019 CLIENT: BHGE a GE company Project: Quality analytics. Description The Quality analytics dashboards have been developed for deep insights of the costs associated with avoiding, detecting, and repairing defects. The dashboard s provide perspective of errors or non-conformances related to process and/or procedures negatively impacting the Operating Margin. Responsibilities: Involved RFP process, Interacted with Business Analysts/Users for Requirement gathering and Prepared Requirement analysis document, Low-Level and High-level design document accordingly. Design, Approach, Development, Testing, deployment, and postproduction support. Prepared project status report, attending daily call with Client and multiple stake holders to provide status etc. Performed both Technical and managerial Lead for 15 members Team. Involved effort estimation. Being an Offshore Manager, understand, transfer requirements to team, and delivered the project in time with minimal defects and overseeing the activities of Senior associates and Programmer Analyst. Software / Languages/ Special Tools:ETL Tool: Talend, Informatica, Database: PostgreSQL/Greenplum, Oracle, SQL, Teradata, DB2, Server: Linux/Unix server (FTP/SFTP). Reporting tool: Tableau, Cognos, BOXI, OBIEE. 05 Capgemini India Manager (Technical) Sep 2018 May 2019 CLIENT: BHGE a GE company Project: BHGE Application migration project. Description BHGE currently has multiple applications on legacy BI technologies. BHGE intends to migrate these applications to Greenplum, Talend, Tableau and OBIEE and then migrate to AWS cloud environment. Responsibilities: Prepares data migration plans including identifying migration risk, milestones, and quality. Migrate/convert data from legacy applications to a new target application environment. Develops best practice, processes, and standards for effectively carrying out data migration activities. Building test and data validation scripts to test the data migration. Responsible for managing the reconciliation of the dry runs and production data loads including signoff with the Process Owners Reference clean-up involves identifying duplicates, correcting citation errors, etc. Responsible for assuring that the migrated references meet the business' new formatting standards. Define relationships & perform mapping between legacy data and new Platform. Performs data migration audit, reconciliation, and exception reporting with data owner. Provide technical assistance to in resolving user reported problems. Support creation of initial data migration rules (source, relevancy, cleansing); reviews and approves the DRS. Reviewing existing data migration strategy and provide recommend changes, delivering an updated data migration strategy document. Experience dealing with sensitive regulated data (banking, life sciences, etc.) Performed both Technical and managerial Lead for 15 members Team. Software / Languages/ Special Tools: ETL Tool: Talend, Informatica, Database: PostgreSQL/Greenplum, Oracle, SQL, Teradata, DB2, Server: Linux/Unix server (FTP/SFTP). Reporting tool: Tableau, Cognos, BOXI, OBIEE 06 Capgemini India Senior consultant Aug 2016 Aug 2018 CLIENT: GE Digital Project: GE SWCOE Data Lake and Predix Platform Support. Description Talend Platform support. Monitoring the Talend services on regular basis and make sure environment available. Admin related activities which include creating user/project, providing access to the projects etc. Responsibilities: As a Talend admin, Monitoring the Talend services on regular basis and make sure environment available. Talend Admin related activities which includes creating user/project, providing access to the projects etc. On Ticket basis, finding the RCA for the issues caused in TAC or in Talend jobs and resolving the same if any platform related issue. Manage wing-to-wing ticket responses Manage and resolve production incidents. Covers system outages, job failures, system defects, data defects and end user support. Provide "Break Fix" solutions by fixing appropriate software code. Monitor all production jobs. Role includes defect fixing, participating in defect review meetings, and sending status report. Software / Languages/ Special Tools:Talend, PostgreSQL/Greenplum and Linux 07 Capgemini India Senior consultant May 2013 Jul 2016 CLIENT: GE Health care Project: ITEST (Integration Testing). Description ITEST is an integration testing project. If any requirement changes happened in ERP side, then the impact of the changes should be identified and make necessary changes in upstream and downstream BI applications. But it should be tested / implemented before moving the changes into PROD to avoid unnecessary mesh up in production environment. Hence create separate environment for the same called ITEST which is replica of production environment. Responsibilities: Leading 10 members Team. Requirement gathering and understanding the process flow from the client. Prepare Cost and effort estimation. End to end set up for the required upstream/Downstream applications which include both ETL and reporting environment. Job Execution to load the data. SIT testing and release the application for user testing. UAT support activities Involved project management activities like resource planning, Maintain effort tracker, updated the status of the project to client on daily basis etc. Update all the project related documents in Ge-Library Have a constant follow-up whether the defect for each task is been logged on to the defect tracking system. Conducting defect prevention meeting with Team in a periodic basis and take the necessary action to provide quality data. Software / Languages/ Special Tools:Informatica, Cronacle, Cognos, BOXI, OBIEE, Teradata, SQL, Citrix, SQL Developer, Ssh client 08 Capgemini India Technical Lead Sep 2010 Apr 2013 CLIENT: GE Health care Project: GAMS (Global Application Maintenance and Support) Description In order to support existing production applications used across Technology Infrastructure, the GAMS organization has been formed to focus on application break fix work. Also, minor enhancement taken care on the applications (when technical change required). Responsibilities: Leading 10 members Team. Execute and manage day-to-day operations via ticketing tool. Manage wing-to-wing ticket responses. Manage and resolve production incidents. Covers system outages, job failures, system defects, data defects and end user support. Provide "Break Fix" solutions by fixing appropriate software code. Monitor all production jobs (including routines and interfaces). Respond to predefined Performance and Availability alerts on an application(s) or interface job(s) when sensed as down or slow . Provide and update documentation to reflect break/fix requests. Establish and maintain a standardized documentation process and create missing support documentation and test scripts. Report status and metrics on a regular basis. Problem Management: Track, record, and process all recurring tickets against the application. Via the tools and process General Maintenance Requests (GMR) or Delta releases are used for any minor technical change required on the application Software / Languages/ Special Tools:Informatica, Cronacle, Cognos, BOXI, Teradata SQL Assistant, SQL, Citrix, Ssh client 09 Capgemini India Senior Software engineer July 2008 Aug 2010 CLIENT: MetLife, USA Project: Mortgage Loan Description The purpose of this project is to load loan and Borrower information into staging and Mart with extraction file sent to CCM. We will receive daily files which will contain delta information. The data from these files will be loaded in the stage table. In staging only basic edits will be performed-Format check, required field check, etc. Error record will be rejected and written into an error table. Apart from daily file. We will have six reference files. This will be provided initially. The reference data from these six reference files will be directly loaded into mart lookup table. Responsibilities: Requirement gathering and understanding the process flow from the client. Analyzing user requirement and Prepared Requirement analysis document, Low-Level and High-level design document accordingly. Update all the project related documents in VSS (Project tracking tool) Developed informatica objects (Like Mapping, Mapplet, workflow, Worklet, Tasks etc.) based on the prepared design document. Job Execution to load the data. SIT testing and release the application for user testing. UAT support activities. Involved project management activities like resource planning, maintain effort tracker, updated the status of the project to client on daily basis etc. Have a constant follow-up whether the defect for each task is been logged on to the defect tracking system. Conducting defect prevention meeting with Team in a periodic basis and take the necessary action to provide quality data. Software / Languages/ Special Tools:Informatica, DB2, SQL, Visual Source Safe, TOAD, Putty. 10 Infosys India Technical Lead Aug2006 May2008 CLIENT: Bank of America Project: Accumulator Description The project was concerned with consolidating the bank s data from disparate sources into subject wise data marts. To this end, data was sourced from the different sources and first accumulated into a central repository called ACCUMULATOR . From the accumulator, data is then split according to different subject areas and populated into the corresponding subject specific data marts Responsibilities: Requirement gathering and understanding the process flow from the client. Analyzing user requirement and Prepared Requirement analysis document, Low-Level and High-level design document accordingly. Update all the project related documents in VSS (Project tracking tool) Developed informatica objects (Like Mapping, Mapplet, workflow, Worklet, Tasks etc.) based on the prepared design document. Job Execution to load the data. SIT testing and release the application for user testing. UAT support activities. Involved project management activities like resource planning, maintain effort tracker, updated the status of the project to client on daily basis etc. Have a constant follow-up whether the defect for each task has been logged on to the defect tracking system. Conducting defect prevention meeting with Team in a periodic basis and take the necessary action to provide quality data. Software / Languages/ Special Tools:Informatica, SQL, Oracle, TOAD, AQT, Putty Education: Bachelor of Engineering (BE) Periyar University, Tamilnadu, India (2000-2003) Diploma in Electrical and Electronics engineering (DEEE) NPA Centenary Polytechnic, Tamilnadu, India (1995-1998) Professional Certifications: Talend developer Certification -Talend Informatica Power center -- Informatica SQL- Oracle Connect Manager Program- Capgemini Keywords: quality analyst business intelligence sthree database information technology microsoft