Big Data Software Development

PROFESSIONAL SUMMARY

Around ** years of Software Development and Production Support

experience in SSIS packages, Tableau reporting, Enterprise data lake, Hadoop, Big data technologies, Alteryx workflows, Database and Applications.

WORK HISTORY

BI-Tableau Developer, 01/2022 to 04/2024

TCS- Johnson & Johnson Client - London, UK

Responsibilities

CONTACT

Address: Bridgewater, NJ 08807

Phone: 908-***-****

Email: **.*****@*****.***

SKILLS

Technical Skills

PINKY SHARMA

Hands on experience in Tableau reports design, development, publishing reports, extract refresh and schedules.

•

Built multiple Tableau reports using various source systems like excel sheets, SQL server, Oracle, Redshift, PostGres and Big data(Cloudera) for business to perform analysis on diversion, counterfeit and tempered products.

•

Worked on all phases of BI analytics lifecycle i.e. collecting requirements, data discovery, preparing requirement document, development of reports in lower environment, performance tuning, promote code to higher environments.

•

Worked on data validation and coordinated with business users during UAT testing phase.

•

• Well experienced in Bigdata tools like Hue, putty, WinSCP. Experience in loading data from various sources i.e. excel files, Oracle DB, PostGres DB, Redshift into EDL using Alteryx workflows

•

Experience in loading multiple larger datasets into HDFS and processing datasets using Hive.

•

Worked as data engineer in Starburst POC initiative. Performed data analysis, created data mappings and data sets in Starburst for various source

systems.

•

Experienced in Schedule Recurring Hadoop Jobs with Apache Oozie, Tidal and Control-M.

•

Extensive experience in ETL process consisting of data transformation, sourcing, mapping, and conversion.

•

Strong understanding of DB concepts, SQL server, back-end testing experience by writing and executing SQL queries.

•

Experience in Data Analysis, Data validation, Data Cleansing, Data standardization, data verification and identifying data mismatch.

•

Analyzed source systems, staging area, and core tables which loads to target Systems.

•

• Data Visualization: Tableau 20.1.01

Data Preparation and Workflow

Automation: Alteryx Desktop 2023.1

•

Data Platforms: Starburst Enterprise

platform

Enterprise data lake (Cloudera)

•

ETL and Data Integration tools: SSIS

packages, DTS packages, SAP BPC,

Tidal, Control-M,

•

Scripting, Command Line and other

Tools: Putty

Shell scripting (bash), JIRA,

Confluence, Putty

•

Database Experience: Oracle, SQL

Server. PostGres. Redshift, Cloudera

•

Technical Lead, 08/2016 to 12/2021

TCS- Johnson & Johnson Client - Bridgewater, NJ

Responsibilities:

ETL Developer, 09/2013 to 07/2016

TCS- Johnson & Johnson Client - New Brunswick, NJ

Responsibilities:

• Good experience in working with onsite -offshore team model projects. Good experience and understanding of SCRUM and Agile methodologies used in SDLC.

•

• Experience in Jira and IRIS system for change management. Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.

•

Led a team of 6 developers to successfully deliver high-quality software projects on time and within budget constraints.

•

Developed data pipeline using Sqoop to ingest data from different sources into Hive for analysis and this data is used by Reports. These reports are sent to management for better decision making.

•

Worked on creation of Tableau reports for business to perform analysis.

•

Worked on importing and exporting data from Oracle into HDFS using Sqoop.

•

Implemented parallel data processing workflow and rule engine using data ingestion and transformation tools in Hadoop.

•

• Process, cleanse, and verify the integrity of data used for analysis. Sqoop data from sources like text files, Oracle DB and MYSQL data bases to Data Lake. Apply transformation rules to load data from different sources to Hive and Impala repositories Optimize data for User consumption.

•

Experience in working with various distributions of Hadoop like enterprise versions of

Cloudera (CDH5/CDH6).

•

Deployment of code to development, QA and production environments and Deliver applications. Support business users during User Acceptance Testing.

•

Raise change control in Change Management system to promote code from one environment to other as per process.

•

• Provided weekly and monthly status report to all stakeholders Created/modified new/existing EVDRE templates through excel for easy and quick data retrieval and data load in SAP BPC Data Manager.

•

Designed/modified excel based dynamic input templates with SAP BPC Data Manager.

•

Updated BPC Business Process Flows, Security Definition, Member/Task/Team profiles through SAP BPC Admin Console.

•

Updated Conversion and transformation file as per user requirement through SAP BPC Data Manager.

•

Creating Packages through SAP BPC Data Manager for internal data calculation logic, application optimization.

•

Computer Programmer, 05/2010 to 08/2013

TCS-Humana Inc - Noida,India

Carried out the following activities:

Web Developer, 06/2008 to 04/2010

ConAgra Foods Inc. - Pune, India

Responsibilities:

CERTIFICATIONS

Scrum master (PSM2) and Azure-900 fundamentals

Modified Calculation Script Logic for business related internal currency translation, moving data between different applications, Inter Company Eliminations through SAP BPC Admin Console.

•

Updated Applications Set, Applications, Dimensions in Dimension Library, Security Configuration for Applications as per user requirement through SAP BPC Admin Console

•

Requirement gathering, Impact analysis and creating Technical design documents etc.

•

Creating SSIS packages, SSRS Reports, Database development Triggers, Functions, procedure, queries.

•

• Co-ordination with Offshore, Onsite Team and Client. Delivering all the projects to client following all internal TCS as well as Client processes.

•

TURN creation and Release Co-Ordination for all the components released into Production

•

Conducted root cause analysis on recurring incidents to identify opportunities for improvements in application design or support procedures.

•

Analyzed and mapped data and wrote SQL scripts to extract data from SQL databases.

•

• Resolving daily job issues and providing resolutions.

• Fixing bugs that are encountered FFG, GFG, and RFG areas.

• Providing, terminating access of users.

Provided 24/7 support for web- and client-based applications, file and data feeds and batch processes to prevent impact to business.

•

Optimized system performance through routine maintenance tasks such as database backups, log file reviews, and server health checks.

•

Managed incident tracking system, ensuring accurate records and timely follow-ups on outstanding issues.

•

Supported end-users in navigating complex applications, guiding them through features and functions while troubleshooting issues as needed.

•

• Participated in on-site requirements gathering sessions. EDUCATION

Bachelor of Technology, Computer Science, 07/2007

Kurukshetra University - Haryana,India

Contact this candidate