Software Developer Resume Boston - MA - Hire IT People

PROFESSIONAL SUMMARY:

4 years of IT experience in Data Warehousing and Data Base technologies with entry level knowledge in Business intelligence and Data Science.
Excellent experience with analysis, design, development, customizations and implementation of Data Warehousing, Data Integration & information management applications.
Strong Ab Initio skills including various Ab Initio modules like GDE, EME, Conduct>IT, Express>IT etc.
Well versed with various Ab Initio parallelism techniques and both batch and continuous flow processing.
Proficient in analyzing and translating business requirements to technical requirements and architecture.
Familiar with scheduling tools like Control - M and AutoSys to run and monitor ETL jobs.
Good experience in UNIX and shell scripts
Knowledge on the phases of Agile methodology.
Strong Relational database development skills using SQL, PL/SQL, Oracle, Teradata.
Familiar with other ETL tools like Oracle Data Integrator, Talend, SSIS etc.
Experience implementing projects using BI tools such as Tableau, Spotfire, QlikView, QlikSense and Excel Power Pivot.
Hands on experience in project planning, estimation, resource planning and project management.
Extensive people management and leadership skills.
Result-focused with strategic foresight, clarity and exceptional documentation.
Self-motivated individual with good communication and interpersonal skills, as well as team player.

TECHNICAL SKILLS:

ETL/ELT Tools: Ab Initio, Talend, Oracle Data Integrator, SSIS

Databases: Oracle 12C, MySQL, Microsoft SQL Server 2014, Teradata v13.0

Data Modeling: Rational Rose

Programming: C++, PL/SQL

Operating System: UNIX/Linux

Reporting: Tableau, Spotfire, QlikView, QlikSense, Excel Power Pivot

Other Tools: SPSS, Microsoft Azure, Visio, Control M, AutoSys

WORK EXPERIENCE:

Confidential, Boston - MA

Software Developer

Responsibilities:

Lead Designer and the Primary Ab Initio Developer on the Confidential Project.
Plan, Estimate, Co-ordination with teams, Code Review, Work status tracking, Client communication, Production release & implementation.
Have discussions with the client and freeze the high and low level requirements
Help the team understand the requirements and guide them in the development and testing phases.
Mapping new XML elements to the old XMLs and creating mapping document for the same
Being involved in all the phases of the project and making sure that deadlines are met with utmost quality deliverables by adhering to quality procedure as laid out by the client.
Utilized continuous flow processes with multi queues and Conduct
Supervised the analysis, development and testing of ETL jobs.
Generating SQL code to dump ETL output into target database.
Developed several generic ETL jobs to be used across various projects to help all teams to access data faster.
Getting actively involved in all the phases of project.
Create and maintain the defect report sheet.

Confidential

Associate Software Developer

Responsibilities:

Served as the primary offshore Ab Initio developer on all three projects simultaneously.
Analyzed different source systems and created Source to Target Mapping documents.
Implemented ETL jobs using Multi File Systems to process data in parallel thereby optimizing the jobs.
Research performance issues and optimize graphs for better performance and resource usage using parallelism techniques and lookups.
Designing Data Warehouse schemas based on dimension modelling techniques and writing CREATE statements to build fact and dimension tables.
Created numerous queries involving various types of joins, subqueries, CTE’s etc for diverse business requirements.
Reviewed Data/Process Flow designs and codes of team members to ensure high quality of deliverables.
Scheduled batch graphs and plans using Control M and Autosys.

Confidential

Associate Software Developer

Responsibilities:

Converted critical code from Teradata stored procedures to Ab Initio ETL jobs.
Prepared/reviewed low level design documents and data validation sheets Created generic ETL jobs to extract data from legacy systems to stage before cleansing and loading it into data warehouses.
Coordinated with Teradata DBAs for optimizing SQL code.
Developed design documents and migration sheets to promote the changes to production.
Performed unit and integration testing to validate the target tables.
Writing SQL scripts to create/update/populate target database objects like tables, views etc from various source databases.
Writing FastLoad, MLoad and TPump scripts in Teradata to populate target tables from ETL output flat files.