Sridhar B. Email & Phone Number

Phoenix, Az, Us

Dearborn, Michigan, Us

New York, Ny, Us

• Responsible to implement ETL jobs using Spark - Scala• Optimizing Hive queries by tuning configuration parameters• Worked on Datastage jobs in migrating data from Netezza to YellowBrick.• Create Netezza backend SQL code to populate temporary and staging tables.• Extracting data from HIVE and load back to Netezza• Implement E2E solutions on big data using Hadoop frame work.• Modifying and creating new control-m jobs• Interacting with Product owners for gathering requirements.• Enabled product owners to run campaigns on RPI (Red Point Interactive) tool.• Coordinating with offshore teams to handle production incidents.• Used ETL to load data from various source systems to Netezza mart tables.• Efficiently monitoring Datastage jobs in Control-M and working on high priority incidents• Used QualityStage to develop name-match process and remove data redundancy. • Used Quality stages for cleansing the data using Standardize stages, Match stages and Survive Stages.• Created UNIX scripts to use NZload, NZunload, YBload, YBUnload utilities to load and unload data from Netezza and Yellowbrick• Working as a Primary support member to fix daily, weekly and monthly cycle issues and make sure Product owners always have updated and accurate data to run campaigns.

Arlington, Virginia, Us

• Worked on IBM Info sphere Information server and its components• Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage.• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.• Implemented pipeline and partitioning parallelism techniques and ensured load balancing of data.• Implemented Parallelism through different partition methods to optimize performance.• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.• Developed UNIX shell scripts to automate file manipulation and data loading procedures.• Used Unix shell scripting for file manipulation.• configured ODBC drivers to connect to the database• Responsible for production support to monitor server health and jobs execution.• Performance tuning of slow running jobs • Redesigning of jobs with native database connectors available for version upgrade

Dearborn, Michigan, Us

• Extensively used ETL to load data from different source systems having different formats to target DB2 and Teradata.• Involved in ETL design and implementation of Scd type 2 data warehouse. Leading a module at offshore for design and implementation of the same.• Monitoring the entire Batch cycle of application and working on high priority incidents and Problem Tickets• Implementing manual work-around where manual effort required until fix went to live. • Have direct meetings with Business users to understand the all issues they reported/facing and provide them short and long term workaround.• Implemented performance tuning on Data stage jobs which are running with poor performance in production.• Effectively used standardized stage in standardizing the source data by using the existed rule sets like name, address etc.• Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information• Effectively worked on AVI stage to validate the address information coming from the source and generated the valid and invalid address reports.• Created Unix scripts to automate the process for long running jobs and failure jobs status reporting.

• Worked on IBM Info sphere Information server and its components like DataStage Designer, DataStage Director, DataStage Administrator & Quality Stage• Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage.• Involved in design of dimensional data model – Star schema and Snow Flake Schema• Worked extensively on Data Profiling and Data Encryption.• Implemented multi-node declaration using configuration files (APT_ConfigFile) for performance enhancement.• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.• Active participation in decision making, QA meetings and regularly interacted with the Business Analysts and SMEs to gain a better understanding of the Business Process, Requirements & Design.• Used TOAD for writing SQL routines and functions• Used Unix shell scripting for file manipulation.• configured ODBC drivers to connect to the Oracle database• Involved in the implementation of this application, which involved the Extraction, Transformation, and Loading of data into an DB2 database for various Dealers.• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution. • Repartitioned job flow by determining DataStage PX best available resource consumption.• Extensively worked on the version management of the jobs in the project.• Performed unit testing and system integration testing in dev and UAT environments

Master'S Degree, Software Engineering

Master'S Degree, Computer Science

Bachelor'S Degree, Information Technology