We provide IT Staff Augmentation Services!

Solution Architect (data Warehouse) Resume

3.00/5 (Submit Your Rating)

CAREER OBJECTIVE:

I have a strong experience in data warehousing and Data space and have good understanding of BigData. I am Looking for Enterprise Data Architect, DW/ETL Solution Architect/Lead, DW Architect, ETL Lead, Senior ETL Lead/developer Roles

SUMMARY:

  • 20+ years of total IT experience in end - end life cycle of software engineering starting from OLTP systems to DW, business Intelligence and Data Projects.
  • 16+ years of strong experience in Data Architecture, ETL architecture, ODS, Data warehouse, DataMart, Data Management, E-R and Dimension Data Modeling.
  • Played many key roles such as Data Architect, Technology Manager (Data), Solution Lead, ETL Lead, ETL Developer etc. and involved in Analysis, design, modeling, ETL development with various ETL and BI tools, help automated Testing team with ETL testing strategy etc.
  • Played major roles in building Four Data marts and three major data warehouses.
  • Have strong skills in Database Concepts, ETL Architecture and DW/DM solutions.
  • Sound knowledge & Experience in ETL Tools Informatica and Ab Initio.
  • Experience in designing E-R Model, Star Schema and Snowflake schema.
  • Good Experience in Real-Time, Near Real-Time, Event based and Batch processing of Data Warehouse and DataMart using both Inmon and Kimball approaches..
  • Strong experience in Agile and Waterfall methodology projects with CICD devOps deployment for ETL Codebase.
  • Highly motivated, exceptional multi-tasking and organizational skills.
  • Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels. Worked on both Waterfall and Agile methodologies.
  • Have strong leadership skills. Played as an Architect, Technical and project Lead roles.
  • Expertise in IT risk, information security, data governance, compliance, IT consulting and Onsite-Offshore coordination skills
  • Good exposure in Cloud platform.

TECHNICAL SKILLS:

Informatica PowerCenter 9.x, PWX for Salesforce, PWX for Oracle CDC, IDQ, Embarcadero DT/Studio, AbInitio (GDE, Co>Operating System), EME,Tibco BE, Tibco BW, MicroStrategy, Business Objects, Cognos, DB2, ORACLE, MS SQL Server, Sybase,ERWin, Java, VB, C, and C++, COBOL, Windows, UNIX, (shell scripts), HTML, JSP, Servlet, JDBC, and ASP, EJB, RMI.JNI, DOM, Websphere, Weblogic, JWS, IIS, JavaScript, Python, postgresql, PERL VBScript, Confidential, Tidal.Doors, TOAD, PL/SQL, Linix, AIX, AWS, Cloud, Bigdata, Data Visualization, Tableau, Hadoop. Confidential, Control-M,Tidel, Master Data Management (MDM)

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect (Data warehouse)

Project Skills: Informatica PowerCenter, PWX for Salesforce, PWX for Oracle CDC, Oracle, Informatica IDQ, Dev Ops - CICD, Doors, XML, Agile, UNIX, Rally

Responsibilities:

  • Involved in Data Planning, Infrastructure requirements..
  • Analyzed requirements from upstream / downstream systems perspective and came up with a ETL Design & DQ Design.
  • Identified Re-usable components using Informatica and planned for development and integration.
  • Recruited Required Resources Build the ETL and DQ Team, mentor them to deliver the high quality code as per the solution design.
  • Track and absorb all the ongoing release changes from various source systems and minimize the risk and reduce the rework and focus on the deliverables.
  • Prepare Agile showcase, Define and Accept technical framework stories, attend stand-up, story grooming, retrospective, project planning and estimation and architecture discussions.
  • Develop complex POCs and Spike and define the solution and give it to the Development Team and review the code in DAT session and verify the deliverables and give feedback.
  • Involved in Reviewing the Mapping Document, Load Rules and Testing Strategy.
  • Performed POC on Informatica PWX for Oracle CDC and extracted Data from 12 Oracle source systems.
  • Performed POC on Informatica Salesforce Connector for CDC and real time data extraction.
  • Performed POC on IDQ - Informatica Integration for At-Rest and in-flight data Quality requirements.
  • Planned the retirement strategy for current state systems and dependencies.

Confidential

Solution Architect (Data Warehouse)

Project Skills: Informatica Powercenter Cloud, Informatica PowerExchnage Salesforce, TIBCO BE,BW, Oracle,JMS, XML, Agile, Event Driven SOA Architecture, Dev Ops - CICD, Doors, XML, Agile, UNIX, Rally

Responsibilities:

  • Involved in Estimation, Data capacity, resource and infrastructure planning.
  • Involved in Recruitment, team building and orientation process.
  • Deliver the solution for XML processing for various events and File based data for both individual and bulk transactions.
  • Involved in Designing Informatica Powercenter Cloud Design and solution for Batch processing.
  • Identify repeated business logic and designed the mapplets.
  • Put together a Design for Event based architecture using TIBCO BE & BW.
  • Involved in Building the Initial prototype to process highly reusable and generic contract (XSD) processing.
  • As an agile advance Team member, worked closely with business and data model team, DBAs to understand all the upcoming sprint requirements and provide the solution for development teams for the subsequent sprint.
  • Identified reusable and optimized way of coding in TIBCO suite for event driven architecture and delivered the coding by subject area in order to avoid the redundant coding at individual events.

Confidential

ETL Architect/ETL Lead

Project Skills: Ab Initio, Unix Shell script, Oracle, Confidential, Business Objects

Responsibilities:

  • Involved in high level system design and ensure the team implements the defined solution in Ab Initio ETL code.
  • Developed graph for 45 dimension table loads and 5 fact table load with many reusable approach
  • Developed various utility xfr for cleansing and validation and data cleansing functionality
  • Involved in designing and developing audit and exception process
  • Developed graphs to meet the security standards like calling oracle package within Abinitio to truncate and enable/disable constrains.

Confidential

ETL Architect/ETL Lead

Responsibilities:

  • Involved in requirement gathering, design and development of many production enhancement release works.
  • Analyzed the performance issues and ongoing production failures that has 900+ Confidential jobs and provided solution.
  • Analyzed the existing security standards in ETL environment and worked on security related release to meet the sox audit standards.
  • Analyzed the issue related to resource contention which was causing frequent production failures and identified the solution and implemented.
  • Work closely with business and 30+ source systems and various Confidential users and capture all the ongoing changes and releases.

Confidential, NewYork

Ab Intio Developer /ETL Lead

Responsibilities:

  • Involved in Requirement Gathering and preparing Detail Design.
  • Performing transformations of source data with Transform components like Join scan Sorted, Dedup Sorted, Reformat, Filter-by-Expression, Rollup etc.
  • Developed Xfr for various components like scan, rollup, join, reformat Components of Ab Initio.
  • Developed 8 parameterized graphs witch will cater for transformation of 48 tables.
  • Generated Dmls from COBOL copybooks for various graphs.
  • Analyzed many COBOL and C programs.
  • Develop and modify several application scripts in UNIX in order to pass the environment variables and to implement run controls for various graphs.
  • Developed wrapper scripts for loading fact tables and load status tables.
  • Responsible for the automation of Ab Initio Graphs using Korn shell scripts.
  • Developed many design and unit test documents for Ab Initio Graphs.
  • Developed Confidential Jobs and boxes to automate the developed graph.
  • Loading data into Weekly and Monthly tables and do the quality check of the loaded data before giving access to Business users.
  • Onsite-Offshore Coordination.

Confidential

Team Lead/MSTR Development

Environment: Windows-NT, SqlServer 7.00, Erwin, PL/SQL, MicroStrategy 7.1.2

We'd love your feedback!