We provide IT Staff Augmentation Services!

Data Engineer/ Data Architect Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • ver 13 years of experience in DWBI, as a Solution Designer, Data Architect, Big Data Solution Designer, Business System Analyst. He is expert in providing solutions for wide variety of business requirements including ETL/ELT, Hadoop & Master Data Management. Vijay is certified AWS Solution Architect Associate, certified Cloudera distribution on Hadoop & Spark developer, certified scrum master and Oracle Database SQL Certified Expert. He has been involved in all phases of SDLC and played project delivery, project management roles with strong leadership skills.

TECHNICAL SKILLS:

ETL Tools: Power Center 7.x/ 8.6/9.1/9.5/10.1, SSIS 2008 & DataStage

Big Data: Ecosystem Hadoop, Spark/Scala, Hive, Sqoop, Oozie, MapReduce

Database: Oracle 9i/10G/11G/12, Oracle GodenGate (CDC), MS SQLServer 2008/2012, Teradata, Netezza 9, DB2 & MS access

Languages: SQL, PL/SQL, Python 3, C & C++

Cloud: AWS expert, have knowledge on GCP

Data Quality: Informatica Data Quality (IDQ), Enterprise Data Quality (EDQ)

OLAP Tools: Business Objects XI R3 & Cognos 10/11

Visual Analytics: Tableau 8, QlikView 11, SAP Lumira.

Data Modeling Tool: ERwin 7.3/8.2/9

Operating Systems: UNIX - HP Unix/AIX 6, Windows 7/8/10

Productivity Tools: MS Office, VISIO, MPP & Git

Defect Tracking Tools: Mercury Quality Center 7, Remedy on Demand & Service Now

Scheduling Tools: AutoSys 3.5, Crontab, Control-M 9, Tidal 6.2

SQL Tools: Oracle SQL Developer 2.1/4, Toad 9.7, WinSQL 8

BPM Tools: Pega 7.1

WORK EXPERIENCE:

Confidential

Data Engineer/ Data Architect

Responsibilities:

  • Discuss with business to understand requirement of new functionalities to be added in Data Lake (EDL - Hadoop) to increase usability of application.
  • Analyze relevant data in existing applications related to requirement
  • Create Business Requirement Documents.
  • Create high level and detailed design documents.
  • Coordinate with development team.
  • Coordinate with testing team to test newly added functionality and existing functionality
  • Coordinate with Business for User acceptance testing.

Environment: HDFS 2.6.x, HIVE B-Line, Spark 2, SQOOP, Ambari, Scala, Tidal, Git.

Confidential

ETL Solution Architect/Data Architect

Responsibilities:

  • Understand PeopleSoft and HCM applications HR data pertaining to Rogers and their functionalities.
  • Requirement gathering & data analysis of new HCM data
  • Designed and built HCM data mart for new HR data to fit in existing HR application data.
  • Used different data lineage techniques to capture the impact of HR application migration.
  • Co-ordinated with development team to modify impacted warehouse tables and jobs to be able to process and accommodate new data.
  • Prepared plan and scripts to update existing data as per new HCM definition.
  • Guided QA team to understand business requirements to prepare test plan, test cases to test all positive & negative business scenarios.
  • Responsible for gathering functional and non-functional requirements
  • Responsible for requirement and data analysis.
  • Profiled source data to ensure fulfillment of business requirement.
  • Prepared Solution Design and Detailed Design Documents as per Rogers standards to fulfill functional and non-functional requirement.
  • Built Hybrid solution with combination of Analytics and Master Data management using Informatica and Enterprise Data Quality tools.
  • Built jobs to standardize address with EDQ tool LOQUATE component.
  • Co-ordinated with development team, provided clarifications, technical support and guidance, code review, performance tuning and unit testing.
  • Developed the traceability matrix.
  • Guided QA team to understand business requirements to prepare test plan, test cases to test all positive & negative business scenarios.
  • Effectively handled the scope creep and Initiated Change request for new requirements.
  • Being a bridge between businesses, development team, testing team, down-stream system teams, operations team for production implementation and PMO.

Environment: Informatica 9.5, Oracle 12G/Exadata, GoldenGate, EDQ, Control-M

Confidential

Pega Senior System Architect

Responsibilities:

  • Participating in requirements discussion with business team & sharing Business knowledge with the team members in offshore.
  • Providing application demos to business for each module and getting feedback from business.
  • Application design
  • Conducting design review sessions and reviewing the design with Architects.
  • Reviewing the code developed by offshore.
  • Participating in code reviews with ESAS (Enterprise shared architecture services) team.
  • Participate in defect triage meetings.
  • Participate in deployment activities to different environments for SIT, PAT and PROD phases of the project.
  • Providing support to the project in SIT, PAT and PROD phases.
  • Preparation of various technical and functional documents (where applicable depending on the request types) Requirement Specification document, High Level Analysis and Approach document, High Level Design Document, Detailed Design Document.

Environment: Pega RULES Process Commander V7.1, WAS, Oracle 11g, SQL, SOAP, XML, HTML

Confidential

Solution Architect/Data Architect

Responsibilities:

  • Collected Business Requirements thru JAD sessions and prepare business requirement document.
  • Profiled source data to verify the match of business requirement.
  • Prepared Solution Design and Detailed Design Documents as per Rogers standards.
  • Prepared Source to Target mapping documents by incorporating all logics at minute level, along with corresponding SQL for development team to implement the solution.
  • Understand existing survey files and leveraged as many components as we can.
  • Co-ordinated with development teams, provided clarifications, technical support and guidance, code review, performance tuning and unit testing.
  • Developed the traceability matrix.
  • Guided QA team to understand business requirements to prepare test plan, test cases to test all positive & negative business scenarios.
  • Effectively handled the scope creep and Initiated Change request for new requirements.
  • Being a bridge between businesses, development team, testing team, down-stream system teams, operations team for production implementation and PMO.

Environment: Informatica 9.5, Oracle 12G, Oracle GoldenGate (CDC), UNIX (AIX)

Confidential

ETL Architect/Data Architect/ Tech Lead/Administrator/Sr. Developer

Responsibilities:

  • Understand current AZ CRM application and Sales Force architecture (SFDC).
  • Profile SFDC data and validate against existing CRM application to confirm the consistency between two source systems.
  • Solution to integrate current EDW with SFDC
  • Data model for proposed solution.
  • Coordinate with different system/teams on GAP analysis between old & new CRM applications in term of data analytics.
  • As an application lead, coordinated with Infrastructure vendor to have better solution in place to migrate application code and corresponding data to new servers located in new data center from current one (followed LPAR approach for Unix & Image transfer approach for Windows).
  • Prepared different estimates & project plans based on different approaches.
  • Consulted Informatica and Business Objects product support teams to assess the pros and cons of each & every approach
  • Coordinated with SAN team to copy application code & data to new servers with no impact to current support & other projects
  • Reconfigured the Informatica, Business Objects and its components in new server
  • Remediated Informatica & Business objects code, Unix Shell & Perl scripts to work as is in new server.
  • Tested the critical jobs & reports to confirm migration accuracy
  • Coordinated with different teams and involved them at right time to complete the migration with in the predefined time.
  • Involved in UAT to clarify all user queries and get the signoff to go live the new servers.

Environment: Informatica 9.1, UNIX - AIX 6.1, Oracle 10G, Business Objects XI R3, Windows 2003, AutoSys, SSIS 2008

ETL Tech Lead / ETL Administrator

Responsibilities:

  • Provided different upgrade approaches along with its pros & cons and suggested the best solution for existing environments.
  • Proposed hardware upgrade to support 9.1 and coordinate with Infrastructure team to have it done before upgrade starts.
  • Did code impact assessment due to new version upgrade.
  • Liaise with Informatica product sales team & Confidential procurement teams to obtain right license.
  • Prepared estimates & project plan for different approaches thru MPP and tracked & reported project status using MPP
  • Upgraded Informatica from 8.6.1 to 9.1, updated configuration & security parameters as per new version.
  • Ran Configuration Support Manager and performed health checks and prepared disaster recovery document and performed mock up drill to ensure it can be restored at any point of failure.
  • Coordinated with different teams to have no impact to their projects due to this upgrade.

Environment: Informatica 9.1/8.6.1, UNIX - AIX 6.1, Oracle 10G.

ETL Tech Lead / Sr. Developer

Responsibilities:

  • Closely worked with business to understand what KPI’s to be consider in dashboard.
  • Coordinated with reporting team to understand their design and requirements to in corporate most of their logic in ETL to get better performance in Xcelsius tool.
  • Created an optimized data model to get best performance in the dashboard.
  • Prepared high level design documents by fulfilling all user requirements.
  • Involved in all phases of SDLC process from requirement gathering till code deployment.
  • Reviewed all deliverables from offshore before delivering to client. Ex:- LLD documents, ETL code, Unix scripts….. etc
  • Coordinated with testing team for them to have better understand of requirements to prepare test script for each scenario for better testing.
  • Involved in UAT to clarify all user queries and get a sign off to migrate the code to production.

Environment: Informatica 8.6.1, Business Objects XI R3 suite (Xcelsius), Oracle 10G, Erwin.

Sr. Developer

Responsibilities:

  • Closely worked with business to understand their requirements and challenges in the current application.
  • Proposed & worked on continuous service improvement opportunities to enhance the system to become more stable.
  • Coordinated with offshore team to process different data sets upon data availability & initial data quality checks as per predefined dependencies.
  • Taken care of load failures in automated and manual loads.
  • Resolved issues raised by business users within the predefined SLA’s.
  • Processing the alignment & yearend data separately to avail old data reporting feasibility based on old alignments.

Environment: Informatica 8.6.1, Business Objects XI R3, Oracle 10G, UNIX, Windows 2003 server professional.

Developer

Responsibilities:

  • Understand the application & code resides in HP UNIX servers and identify the performance improvement parameters in terms of hardware & folder structure.
  • Verified and validated file system on the new IBM AIX Servers.
  • Liaised with Informatica to obtain appropriate Informatica software license and installable files for IBM AIX platform.
  • Installed and Configured of Informatica in new servers at current version level in the HP server(s) and remediate the code
  • Configured & remediated the Business Objects in new servers after the image of existing OS, application software code & data restored new servers.
  • Migrated the Shell & Perl scripts and ETL Mapping from HP Servers to IBM AIX Servers and configure & remediate to work as-is in new environment.
  • Coordinated with DBA’s on DB installation, configuration and data migration from existing HP Servers to IBM AIX Servers.
  • Tested the application by running jobs in both old & new systems and validate data.
  • Tested the report application by refreshing the existing reports, created new reports, universe and validate all functionalities between two servers.
  • Involved in UAT to clarify user queries and live new servers.

Environment: Informatica 8.6.1, Business Objects XI R3, Oracle 10G, HP-UX, IBM-AIX Unix, Windows 2003 server professional.

We'd love your feedback!