We provide IT Staff Augmentation Services!

Data Analyst / Tech Lead Resume

5.00/5 (Submit Your Rating)

New, JerseY

CARRER OBJECTIVE:

To be efficient, capable and leading software professional working on cutting edge technologies in thriving on excellence and challenges. To seek a Competitive edge and a challenging work environment in the field of Business Intelligence of Information Technology.

PROFILE SUMMARY:

  • 18+ years of IT experience with 12+ years of strong experience in designing and developing Business Intelligence solutions in Domains like Finance, Investment Banking, Retail,.
  • Strong experience in Data Warehouse & Big Data Environment.
  • Gone through complete implementation cycle of Data marts multiple times. The activities include Business Requirement Analysis, Logical design / Data Modeling, Physical Database Design, ETL Build & Reporting, Integration Testing, User Accepting Testing, Production Deployment & Maintenance Transition.
  • Good experience in developing Logical and Physical Data Models (Star Schema & 3NF).
  • Experience in Data warehouse Technical Architect for ETL (Informatica Power Center (5.1,6.2,7.x,8.x,9/x), PL - SQL
  • Worked extensively in Data Cleansing, data Mining, ETL Performance Tuning of Informatica mappings and sessions.
  • Experience in Hadoop BIG Data Environment . Worked in PIG scripting, HIVE, JAVA Tools, Map reduce and SPARK
  • Good Experience in developing UNIX shell scripting and automation of ETL processes and loading data in Hadoop Lake environment.
  • Well conversant with Amazon AWS Cloud environment .
  • Excellent communication and interpersonal skills, excellent team organizing skills.
  • Strong problem solving and analytical capabilities
  • Ability to understand customer needs and manage expectations.
  • Demonstrated ability to work effectively in a fast-paced, high volume, deadline-driven environment
  • Ability to balance multiple demands and work both independently and as part of a team to develop solutions

TECHNICAL SKILLS:

BIG Data: PIG, HIVE, SPARK, Map Reduce

RDBMS: Oracle 11g/10g/9i/8i,7.x, Sybase, DB2, SQL server

Reporting Tools/Technology: Business Objects

Programming Languages: C++, Python, JAVA, Oracle PL/SQL, Unix Shell scripts, AWK,PERL

ETL Tools: Informatica PowerCenter (5.x,6.x,7.x, 8.x,9.x)

Operating Systems: Unix (SUN Solaris, HP), Linux, MS Windows NT, 2000/2003 server

Querying tools: SQL Plus, TOAD, DB Artisan

Data modeling: Erwin 4.x, oracle designer

Project Management Tools: MS Project

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Data Analyst / Tech Lead

Responsibilities:

  • Requirements gathering
  • Data Architecture, Source system data analysis, creating transformation logic
  • ETL Tech lead . Architecture of ETL process
  • Daily Stand up meetings and status review.
  • Informatica, Mappings design and SQL server Stored Procs & Unix scripting development and deployments co-ordination
  • User support . Create complex queries based on user requirement
  • Process tuning

Environment: sql server 2012, Informatica Power center 9.x, Unix, Goldengate, ERWIN

Confidential, North Carolina

Project Manager / Tech Lead

Responsibilities:

  • Data Architecture
  • ETL Tech lead, Requirements gathering
  • Release Planning .: Project Plan preparation according to SDLC
  • Daily Stand up meetings and status review.
  • Work allocation to different teams . (Architect/ETL/Reporting/QA). Team Size 10
  • Working with Technical teams and co-ordination between them. Solving technical issues.
  • Informatica, Oracle Pl/SQL Stored Procs & Unix, Reporting development and deployments co-ordination
  • Providing status to upper managements.
  • Creating status dashboards through the entire release cycle

Environment: Oracle 11g /Unix, Oracle, Informatica Power center 9.x, Cognos

Confidential, Wilmington, DE

Project Manager & Technical lead

Responsibilities:

  • Setting up Agile environment for the releases
  • Arranging daily Stand up meetings and following the SCRUM ceremonies
  • Arranging meetings between user communities to update the Backlog
  • Prioritizing the requirements and planning the deliverables for the release
  • Working with Technical teams and solving issues
  • Following Agile Scrum ceremonies. Team size 10
  • Co-ordination of the activities.
  • Providing status to upper management

Confidential, New York

DW Consultant

Responsibilities:

  • Data analysis for the external systems. Develop data cleansing rules & data quality checks.
  • Conforming the data definitions for reference data and hierarchies.
  • Redesign the Stage and ODS layers
  • ETL architect, extract specifications, mapping documents for Informatica mapping build.
  • ETL Performance tuning.
  • Design efficient data storages for historical data by snapshotting the tables
  • Informatica upgrade of 6 and 7 version workflows to 8.6.1 environment.
  • Unix shell scripting .
  • Unit testing, Integration testing

Environment: Oracle 11g /Unix, Sybase, Informatica Power center 8.6 .1

Confidential, Charlotte, North Carolina

DW Consultant

Responsibilities:

  • Data Profiling for the external systems data . decide data cleansing rules & data quality checks.
  • Identify the non confirming data, hierarchies & domains & decide the logic to correct it for overall integration.
  • Master data management: Consolidation of all reference data, Fixing of hierarchies across sub-business & newly acquired systems.
  • Creation of functional requirements documents, data dictionary & gap analysis .
  • Data architect, dimensional Modeling, designing logical models & physical db structures
  • DB space estimations, setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Design of History loading strategy & archival strategy
  • ETL architect, extract specifications, mapping documents for Informatica mapping build

Environment: Oracle 10g /Unix, Informatica Power center 8.6

Confidential, New York City

DW data analyst / Architect

Responsibilities:

  • Data Architect & design: Data analysis from various heterogeneous source systems, preparation of extraction specification,
  • Data gap analysis, creation of data dictionary, mapping documents & functional documents.
  • Master data management > Consolidation of all reference data
  • Dimensional Modeling (Star schema, Facts, dimensions, Slowly changing dimensions, snowflek), designing logical models & physical db structures
  • ETL architecture, Loading strategy design
  • Business Objects ad-hoc reports as per user specification.
  • Source Data Integration across various heterogeneous systems into one Enterprise wise data warehouse.

Environment: Erwin, Sybase, Oracle 10g /Unix, DB2, Informatica Powercenter 8.6,, PL/SQLBusiness Objects(xi)Project #7: ODW Applications Development for Private Banking Domain

Confidential, New York City

DW Architect

Responsibilities:

  • Data analysis & design: Data analysis from various heterogeneous source systems, preparation of extraction specification, data Profiling.
  • Data validations & cleansing rules logic design
  • Master data management about Customers, Accounts, Investment Product hierarchies, Geographical sales hierarchies, Employee hierarchies & so on .
  • Data gap analysis, creation of data dictionary, mapping documents & functional documents
  • Designing data change detection strategy (CDC), Data cleansing rules.
  • Designing of data staging layer & ODS layer .
  • Dimensional Modeling, designing logical models & physical db structures
  • Logical data Model design & setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Design of History loading strategy & archival strategy
  • Integration of all project components, User Acceptance Testing & deployment.
  • Meta data management starting from source to reporting Layer.
  • Source Data Integration across various heterogeneous systems into one Enterprise wise data warehouse.

Environment: Erwin 4.0, Oracle 10g /Unix, Sybase, Informatica Powercenter 8.6,, PL/SQL, Packages, Stored Procedures, Functions, SQL*Loader, Sybase, UNIX Shell Scripting, Business Objects(xi),Flatfiles

Confidential, New York City

DW-ETL Consultant

Responsibilities:

  • Understand the End users reporting requirement & their existing SOX non complaint applications
  • Collect and document the functional business requirements .Analyze the existing MS Access Silo applications
  • & prepare the ETL development specs for the same.
  • Identify the data mappings & Gaps from the EDW tables .Identify all required fields for the users Computations & reports.
  • Logical data Model design & setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Decide ETL load strategies, Staging loads, ODS Loads, Historical loads, Type 2 dimension loading Change Data Capture (CDC) .
  • Build the ETL process using Informatica Power center(7.x)
  • Development of Complex Informatica Mappings .Oracle (PL/SQL, Packages, Stored Procedures, Functions, Triggers, SQL*Loader, External Tables)
  • Informatica mappings & sessions Performance Tuning
  • Unix / AWK Scripting for batch job automation.
  • Maintain ETL Mapping Documents, Data Dictionary & the version control for the mappings
  • Unit Testing, Integration Testing, Regression testing
  • QA Activities, Code reviews, Maintain best coding practices.
  • Front end user administration interface using Java UAT & migration between dev - QA to Prod environments

Environment: Erwin 4.0, Informatica Power Center 8.1,Oracle 10g, Unix, PL/SQL Store procedure, SQL*Loader, UNIX Shell Scripting, Java, Business Objects

Confidential, Danbury /Norwalk, CT

ETL Technical Lead Analyst

Responsibilities:

  • User requirement analysis, Design & Development of Analytical Environments for various departments
  • Logical-Physical data Models. dimensional Modeling. setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Meta data management starting from source to reporting Layer
  • ETL design: data Profiling, Data extraction from various heterogeneous source systems, data change detection, Data cleansing & data staging into ODS layer.
  • ETL build with in corporation of all business logic & rules . Data load into all dimensions & Facts of the Data Mart using Informatica, Oracle 9i PL/SQL Packages, Stored Procedures, Functions, SQL*Loader, external tables .
  • Complex Informatica mappings development & tuning .
  • Informatica repository administration
  • Unix scripting, Batch job Automation
  • Testing: Integration, User Acceptance & deployment.
  • Automation of the data refresh cycle on a regular basis.
  • BO Universe creation & Reports development. According to user requirements.
  • Continuous Data mart maintenance for Batch jobs . Maintenance for Daily/weekly & fiscal monthly data refresh cycles.
  • User support & response to user queries.
  • Regular DB Back ups . Import/Export of DB between various environments.

Environment: Oracle 9i, PL/SQL, Pro*C, UNIX Shell Scripting, Business Object(6.x),Informatica PowerCenter (7.x), SAP R/3

Confidential, Louisville, KY

DW Tech Lead, ETL developer (ETL & Reports)

Responsibilities:

  • Requirement Analysis
  • Source system analysis, Extract Specs preparation
  • Logical Design & Data Modeling in STAR Schema .
  • Physical Database design (Tables, Indexes, Materialized Views & Summary Tables, Space estimations. Customization of data by adding calculations, summaries and functions.
  • Complete ETL design including Oracle, PL-SQL, SQL*Loader, stored procedures, functions
  • ETL development, enhancements & continuous development
  • Developed report generation use cases
  • Digital Cockpit generation using J2EE Technology
  • Maintenance & enhancement to the Data Mart

Environment: UNIX shell scripts, Oracle 8i,PL-SQL, SQL*Loader,Informatica5.1 Power Mart, Erwin 3.5, J2EE for report generation

We'd love your feedback!