SUMMARY

• Over 18+ years of experience in Information Technology with expertise in Cloud computing, Big Data technologies, Data base Administration, Data Warehousing, ETL development and BI reporting.
• Implemented Enterprise Data Warehouse and Data Mart solutions using Snowflake, Hadoop, Control M, Oracle, Informatica, Teradata, Tableau, Aptitude, Tableau and PowerBI.
• Strong experience in Designing data pipelines and data solutions in on - prem and cloud environments
• Vast experience in building Data Marts, operational data sources, Prototypes for various OLAP applications.
• Design, build and load data into snowflake database from various data sources
• Participate in design meetings for creating data model and provide guidance on best data architecture practices
• Implemented data pipelines using Azure Data Bricks for Data Ingestion and Loading to Azure Storage
• Knowledge in multi cluster, auto scaling and auto suspension of the snowflake warehouse.
• Worked on Big Data Cloud Implementations with AWS, Azure, Cloudera and Hortonworks.
• Experienced leader with team building practices utilizing Agile and JIRA stories
• Expertise in building scalable and high-performant applications meeting business critical SLAs
• Experienced with Cluster Design, Configuration, Installation, Patching, Upgrading and support on High Availability Applications.
• Extensive Experience in Handling Huge volume of data in/out from Hadoop/Oracle/Teradata and Snowflake
• Worked and supported Database Security, Performance Tuning, Database Optimization, Database Recovery, Automation of the Database Start up and Shut down.
• Worked on SQL and Application database tuning including: Parallel processing, Indexing, Query tuning, Database performance tuning and Database monitoring.
• Extensive development experience in Procedures, Functions, Package, Triggers, Database Objects, Collections, Partitioning, Oracle XML, Queues and Bulk processing.
• Designed and Developed complex aggregate, join, look up transformation rules (business rules) to generate several Detail, Summary and dimension tables
• Adaptable to work both as a team member as well as independently.
• Experience and desire to work in a Global delivery environment with strong written and oral communication skills and Analytical skills
• Lead and motivate team members towards achieving their goals by understating their problems and providing solutions.

TECHNICAL SKILLS

Database: Oracle 8, 8i, 9i, 10g, 11g and, Teradata, MS Access, SQL Server

Cloud Technologies: Snowflake, AWS and Azure

Hadoop/Bigdata Technologies: HDFS, Map Reduce, YARN, Hive, HBase, PIG, Zookeeper, Sqoop

DW/OLAP: PowerBI,Tableau,Informatica, Business Objects, Cognos & Erwin.

Operating Systems: Windows, Solaris, Linux, UNIX

Tools: / Utilities: Recovery Manager, DBVerify, Exp/Imp, Server Manager, TKPROF, TOAD, and EMC tools- time finder, Erwin, Oracle Enterprise Manager (OEM)

Programming Language: C, C++, SQL, VB 6.0 and PL/SQL and Python.

RDBMS: Oracle 8, 8i, 9i, 10g,11g and 12C.

Scripting Languages: HTML, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Data Solution Architect

Responsibilities:

• Instrumental in designing analytics, predictive models, replenishment, inventory tracking application that tracks Confidential 's electronic gadgets shipping end-to-end, starting from the origination point that is the respective manufacturer (like Confidential, Confidential, Confidential etc) to the central North America Warehouse and then to the respective stores across North America.

Confidential, Fort Myers, FL

Oracle Architect

Responsibilities:

• Analyzed and Migrated Ecommerce application of Confidential to a new platform to reduce data latency. Merged newly acquired business stream ecommerce application into existing architecture.

Confidential, Atlanta, GA

Data Architect

Responsibilities:

• Studied existing application architecture and enhanced & redesigned legacy network management data application and reporting to new architecture.

Confidential, Charlotte, NC

Oracle DBA/ PL/SQL and ETL Lead

Responsibilities:

• Worked with business users to gather requirements and developed physical and logical Data Models.
• Lead the development team in solution implementation.

Confidential

PL/SQL and ETL Lead Developer

Responsibilities:

• Worked on Informatica 7.1 as an ETL tool to extract data from source systems to Target system; Supported and maintained the metadata processes
• Used Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse from SAP database, Flat files and Oracle tables in Informatica 7.1
• Developed and modified changes in mappings according to business logic; Used connect direct to obtain files and loaded them into staging database
• Used UNIX shell scripts for deleting the old files, executing the control files and executing informatica batches;

Confidential

ETL Lead Developer

Responsibilities:

• Worked as core ETL developer; Extracted data from Flat files using informatica power center mappings and transformations
• Used Informatica reusable transformations and mapplets; Resolved if any issues in transformations and mappings, analyzed sources, targets.
• Utilized various transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter and Update Strategy transformations.

Confidential

ETL Lead Developer

Responsibilities:

• Loaded Data using Informatica, created mappings and scheduled the data loads into data marts; Created mappings and mapplets and also tuned them for better performance
• Developed type 2 Update strategies to keep track of historical data
• Transformations like Source Qualifier, Lookup (connected & Unconnected), Aggregator, Expression, Stored procedure (connected & Unconnected), Sequences are mostly used
• Designing the Business Objects universe and looping issue was resolved using context
• Used various types of BO reports like simple list, Grouped list, Drill down reports, Grouped cross tab, free hand SQL reports for better analysis using Infoview.

Confidential

ETL Lead Developer

Responsibilities:

• Worked on low-level design of the project; Developed data cleansing process and complex mappings using (Aggregator, Expression, Joiner, Lookup and Update strategy transformations).
• Monitored Sessions and batches using Informatica Power Center; Developed Cognos, textual & graphical reports (simple, master details, cross tabs, charts and HTML) with drill down, slice & dice, filter and alert features.
• Built Top Ten Reports, Rank & Sort Data on Percentage Growth as per User requirements; Involved in Unit testing of ETL processes and reports.

Confidential

PL/SQL and VB Developer

Responsibilities:

• Involved in Coding (used PL/SQL, Stored procedures, ADO’s, MSMQ, Crystal reports), Debugging & testing

Confidential

PL/SQL and VB Developer

Responsibilities:

• Involved in Coding (used PL/SQL, Stored procedures, ADO’s, MSMQ, Crystal reports), Debugging & Testing.

Confidential

PL/SQL and VB Developer

Responsibilities:

• Involved in Coding (used PL/SQL, Stored procedures, ADO’s, MSMQ, Crystal reports), Debugging & testing