Project Lead/Software Engineer Resume New York, NY - Hire IT People

SUMMARY:

Forward - focused, driven technology professional with knowledge of data warehousing, ETL, Big Data, Business Intelligence and finance.
Tremendous data warehousing and analytical skills, detailed oriented with global IT experience.
Recognized as being an accomplished team player. Displays dedication and determination in all endeavors with diligent attention to detail for optimal end results.
12+ years extensive experience in IT Industry with thorough understanding of Data Warehousing and proficiency in ETL.
Knowledge of Big-Data and Hadoop Ecosystem including Spark, Hive, Confidential, Flume, Sqoop & No Sql Database HBase.
Key player in Engineering Excellence team to orchestrate Continuous Integration using Jenkins, Bitbucket and uDeploy.
Strong Experience in Finance Industry accompanied by 2 levels of CFA (Chartered Financial Analyst).

PROFESSIONAL STRENGTHS INCLUDE:

TECHNICAL S KILLS:

ETL: Abinitio (Co-Operating System 3.x), Talend

Big Data Technologies: Hadoop, Hive, HBase, Sqoop, Flume, Confidential, Spark (CoreApI’s & Data Frames)

Data Modeling: Start Schema, Snowflakes, Data Marts

BI Tools: Business Objects.

Languages: Python, UNIX Shell Scripting, PL/SQL

Databases: Sybase, Oracle, MySql

PROFESSIONAL EXPEREICNE:

Confidential, New York, NY

Project Lead/Software Engineer

Responsibilities:

Handle complete software development life cycle of Inview Banker & Financial Module including Design, Development, Coding, Code Review, Testing and Deployment using different technologies - ETL tool Ab Initio, oracle PL/SQL and UNIX shell scripts.
Develop code to push Real Time Messages into Hadoop Ecosystem using Abinitio- Confidential .
Responsible for Engineering Excellence Initiative and to conduct POC’s using Talend as an alternative for Abinito.
Responsible for Batch optimization & Data Analysis, performance tuning of Ab Initio Graphs, Materialized Views, SQL/PL SQL scripts, and Data Quality checks.
Handle migration of Inview Banker, Financial &Analytics Module from Sun Solaris to Red Hat LINUX environment, including migration of Ab Initio code onto Co-operating system 3.x.
Design technical data mapping specifications template and prepare high level functional design for feeds provided by the banking and investment product processors (e.g. Pershing, Fitek).

Confidential, NJ

Programmer Analyst

Responsibilities:

Responsible for Ab Initio g raph d esign, development and Performance tuning using Ab initio GDE 3.0.2, 2.15 .
Responsible for designing and developing unix shell scripts (wrapper) for Automating ETL process, Autosys JIL File to schedule the jobs using Autosys .
Responsible for Data Analysis, Data Quality of data in Oracle 10G.
Responsible for validating cubes, catalogs, dashboards and adhoc reports, report generation and analysis
Responsible for Designing the ETL process for the project and created the system delivery and technical design document.
Used EME as a Version Control tool
Fine tune transformation, validation & processing rules to improve data quality metrics .

Confidential, NY

Technology Lead

Responsibilities:

Project Lead & onsite coordinator for complete migration of regional applications.
Month end support of business for reconciliation of financial data against financial reporting system.
Design & Code ETL Abinitio graphs .
Developed reports using Business Objects for complex profitability module.
Data Modeling using Star Schema.
Conduct data analysis using SQL / Excel for requirements analysis and assist data quality teams.
Monitor deterioration in data quality of incoming feeds through dashboard and by analyzing feed processing results. Conduct root cause analysis of the errors found in feed processing and report them

Confidential

Software Developer

Responsibilities:

Used AB Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases
Tuning of AB Initio Graphs for better performance.
Developed Complex AB Initio Confidential s to derive new fields and solves rigorous business requirements.
Provided UAT & level2 production support to business stakeholders and clients.
Automated the Data Loads using UNIX shell scripting for Production, Testing and development environment.