We provide IT Staff Augmentation Services!

Senior Systems Developer/analyst Resume

SUMMARY

  • Overall 15+ Years of experience in the software and hardware industry.
  • Experienced in developing EDW (Enterprise Data Warehouse) using SDLC, gather requirements from business, convert them into ETL process, develop Informatica mapping, pl/sql stored procedures, Perform DUT/SIT/UAT/DR regression testing activities, create linux batch scripts, establish SOP, maintain SLA’s, continuously improve processes for performance.
  • Colloborate with analysts and business users in creating reports, troubleshoot reporting issues for efficiency and quality.

TECHNICAL SKILLS

ETL tools: INFORMATICA PowerCenter 9.x, IDQ, MDM, PL/SQL,shell scripts, Visio, Erwin, JAVA,C

Reporting tools: Microstrategy, Tableau, Business Objects, QlikView

Databases: Oracle, Netezza, Teradata, SQL Server, DB2

Others: power point, Excel, Word and Visio

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Developer/Analyst

Responsibilities:

  • As a team member developed and maintained company’s Global Enterprise Data Warehouse for Business Intelligence department.
  • Constantly enhanced EDW with new business initiatives which increased EDW from one country to worldwide operations where the processes run for 24 hours daily.
  • The jobs frequency varies every 5 minutes to 24 hours.
  • Developed data Marts for sales, forecasting, stores management, shrink, etc using Informatica (Power Center 9.x) which had data sources from Oracle, SQL server, XML, Flat files, EDI and SAP. Used Oracle, Teradata and Netezza stored procedures for loading, extracting and data transformations.
  • Designed and moved complete EDW from Teradata to Netezza. Upgraded database versions seamlessly without affecting the business.
  • Created Unix shell scripts and microsoft batch jobs for batch processing and implemented them din Control - M for seamless processing and fault tolerance.
  • Collaborated and supported Microstrategy front-end team and business analysts.
  • Designed and processed year end jobs every year manually in production (12 to 16 hours continuous processing approximately 150 jobs) for inventory and calendar changes.
  • Applied performance tuning using explains plan, indexes, material views and Informatica settings.
  • Informtica: Developed mappings using almost all transformations which include grouping, routers, normalizer, complex mappings, SCD (slowly changing dimensions). Created sessions, workflows along with shell scripts for various projects. Extensively used variables and parameters.
  • Teradata experience: Bteq, Mload, FastLoad, TPump, FastExport, SQL Assistant, DDL & DML operations, Stored Procedures and others. Applied appropriate indexes and created materialized views based reporting requirement. Upgrade versions without affecting applications by parallel testing.
  • Netezza experience: Migrated seamlessly data warehouse from Teradata to Netezza by parallel testing. Convert Teradata processes and programs to nzsql, nzload and shell scripts. Performance tune during migration and for new applications.

Environment: Informatica PowerCenter 9, UNIX, Windows XP, Teradata, Netezza, Oracle 11g, SQL,PL/SQL, SqlServer, Microstrategy, Control-M.Jira, Perl

Confidential

Senior Systems Developer/Analyst

Responsibilities:

  • Worked on special pharmaceutical new drug “Diovan” initiation project which follows all FDA regulations and CFRII policies and procedures for drug approval.
  • Project involved analyzing requirement, translate them into effective data model and create data warehouse which would help to analyze prescription data for regulatory.
  • Used informatica (Power Center 8.x) as ETL tool and Oracle as target system. The process involved developing informatica mappings, oracle PL/SQL procedures, shell scripts for batch loading.

Environment: Informatica PowerCenter 9, UNIX, Oracle 9, SQL,PL/SQL.

Confidential

Senior Systems Developer/Analyst

Responsibilities:

  • Lead IPD Data Warehouse project. Converted IPD project from DB2 system to Oracle system.
  • Analyzed business requirements. Identified issues, created project plan and successfully implemented solutions.
  • Developed subject areas, created Informatica mappings & sessions, shell scripts and implemented batches using Maestro.
  • Migrated external sales and historical data from various vendors such as IMS data into CHC data warehouse. Created Ad-hoc reports using SQL, Business objects & Brio.

Environment: PowerCenter 8, UNIX, Windows XP, Oracle PL/SQL, Cognos, Autosys.

Hire Now