We provide IT Staff Augmentation Services!

Consultant Resume

SUMMARY:

  • Over 14+ years of IT experience in Business Requirements Analysis, Application Design, Development, Testing, Implementation and Support of Data Warehouse, Database, Mainframe and Client/ Server applications.
  • 8+ years of ETL development and ETL Quality Analysis experience to build and test Data Warehouse/ Data Mart systems using ETL Informatica Power Center 10.1.0 (current working version)/ 9.6.1/ 9.5.1/ 9. x & Power Exchange 10.1.0 (current working version for CDC Real time), 9.6.1 & Data Stage.
  • Experience in Bill Inmon (Relational) and Ralph Kimball (Dimensional) models (Star, Snowflake schema) and Data Modeling experience using Erwin.
  • 8+ years of experience in Federal projects like DOD (Dept. of Defence), CBP (Customs Borders Protection)/ DHS (Dept. of Home Land Security) and financial FRB (Federal Reserve Board).
  • Other domain areas like Banking, Health Care, Insurance, Pharmaceutical, Utility, Retail, State welfare.
  • Design and implementation and Good Knowledge on Data Warehousing (EDW/ Data Mart/ ODS)/ Relational Databases concepts & ETL tools (Informatica)/ Reporting tools (Tablueau & BO).
  • Strong relational database development skills and excellent knowledge in Relational Databases like Oracle 12c/ EXADATA/ 11g/ 10g, SQL Server 2016, DB2, NCR Teradata and extensively used SQL, PL/ SQL Stored Procedures. Experience in RAD relational database development and test tools like SQL Developer and TOAD (Oracle & DB2).
  • Experience in using NCR Teradata tools such as BTEQ, FastLoad, MultiLoad, FastExport, Teradata Assistant and Queryman.
  • Recently completed extensive practical oriented training on Visualization reporting tool TABLEAU and acquired very good working knowledge on Tableau 9.3/ 8.3 (Tableau Desktop & Tableau Server).
  • Experience in various BI/ OLAP Reporting tools like Tableau, Business Objects, Micro Strategy, Cognos.
  • Strong experience on various UNIX systems and Shell Scripting & Crontab.
  • Knowledge in various tools like PVCS, Auto - sys and Control-M.
  • Experience in creating Test Plans, Test Scripts. Participated in Unit, Integration, Volume and System testing and Created SQL scripts to verify TARGET data loads in all Data Warehouse projects and have working knowledge on automated tools Quality Center and QTP.
  • Brain Bench Certification for Java (Score 3.18/ 5).

TECHNICAL SKILLS:

Data Warehouse tools: Informatica Power Center 10.1.0/ 9.6.1/ 9.5.1/ 9. 1, Power Exchange 10.1.0 (CDC Real time), DataStage 7.x, Tableau 9.x/ 8x, Business Objects XI, Micro Strategy 7.x, Cognos.Databases Oracle 12c/ EXADATA/ 11g/ 10g/ 9i, DB2, SQL SERVER 2016, NCR Teradata.

Operating Systems: Z/ OS, OS/ 390, UNIX (Linux, AIX, SUN Solaris, HP-UX, SVR4), WINDOWS.

Programming Languages and Scripting: SQL, PL/ SQL, COBOL-II, Shell Scripting, VB script/ Java script. Experience on Mainframe technologies and extensively worked on Mainframe COBOL & Other COBOL versions like Acu COBOL, Microsoft COBOL, JCL, Client/ Server technologieS, Currently doing on-line cources like Big Data, Hadoop and Phython and updating skills on new and current technologies.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

Responsibilities:

  • Design and implementation and Good Knowledge on Data Warehousing (EDW/ Data Mart/ ODS)/ Relational Databases concepts & ETL tools (Informatica)/ Reporting tools (Tablueau & BO).
  • Strong relational database development skills and excellent knowledge in Relational Databases like Oracle 12c/ EXADATA/ 11g/ 10g, SQL Server 2016, DB2, NCR Teradata and extensively used SQL, PL/ SQL Stored Procedures. Experience in RAD relational database development and test tools like SQL Developer and TOAD (Oracle & DB2).
  • Experience in using NCR Teradata tools such as BTEQ, FastLoad, MultiLoad, FastExport, Teradata Assistant and Queryman.
  • Recently completed extensive practical oriented training on Visualization reporting tool TABLEAU and acquired very good working knowledge on Tableau 9.3/ 8.3 (Tableau Desktop & Tableau Server).
  • Experience in various BI/ OLAP Reporting tools like Tableau, Business Objects, Micro Strategy, Cognos.
  • Strong experience on various UNIX systems and Shell Scripting & Crontab.
  • Knowledge in various tools like PVCS, Auto - sys and Control-M.

Hire Now