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