PROFESSIONAL SUMMARY:

• 6+ years of experience in building and integrating ETL processes in a large Data Warehouse system
• Have an excellent exposure in Retail Market Research and Consumer insights
• Have a very good experience in designing a Data Model for multiple business requirements
• Good in both Structured and Object Oriented Programming Languages such as UNIX Shell Scripting, PL/SQL, Java and Python
• Have experience in designing ETL jobs using different components of IBM InfoSphere Datastage
• Experience in handling Dimension , Slowly Changing Dimension and Fact data in both “ Star ” and “ Snowflake ” data models
• Excellent in complex Data Analysis using in - depth knowledge of ETL core concepts
• Proficient in different Relational Databases and its Structured Query Language
• Familiar with IBM High Performance Data Warehouse appliance “ Netezza ” and NZSQL
• Excellent in Software Development Life Cycle and knowledgeable in Agile methodology
• Good understanding of BIG Data concepts and its Eco systems in MapReduce, SQOOP, Spark and Hive
• Excellent in Incident Management , Problem Management and Configuration Management skills
• Have experience in high severity incidents recovery and resolution
• Experience in implementing System Improvement Plans to bring the stable platform
• Experience in batch job management in multiple batch job schedulers such as Autosys , Control-M and TIBCO Ops Console
• Proficient in migrating applications from one platform to other platform
• Experience in upgrading an application in newer version of software
• Worked with cross functional teams like Architecture, Development, Production and Operation
• Excellent coordination between offshore and onshore team
• Ability to grasp any new technology and languages very quickly

TECHNICAL SKILLS:

Languages: UNIX Shell Scripting, JAVA, Python, SQL, PL/SQL and NZSQL

Technologies: Extract Transform and Load in IBM Datastage 8.1

Databases: Oracle 12g, Netezza Twinfin and Mako

Tools: Eclipse, IDLE, SQL Developer, DB Visuablizer, TOAD

Version Manager Tools: TortoiseSVN and SourceTree

Operating Systems: Linux, Windows XP and Windows 7

Domain Skills: Retail - Consumer Market Research

Data Modeling Tools: SQL Developer Data Modeler

Exploring Technologies: Apache Spark in Python

PROFESSIONAL EXPERIENCE:

Confidential

ETL Consultant

Technologies: Datastage 8.1, Netezza 7.0.2, Oracle 11g, JAVA, SQL, PL/SQL, Netezza SQL and UNIX Shell Scripting

Responsibilities:

• Stabilizing an application by reviewing the change requested end to end
• Modeling new Data Model and provide generalized solution for complex problems
• Building Oracle PL/SQL stored procedures and UNIX Shell scripts to automate validation framework
• Exploring Oracle query plan and tuning query performance to achieve optimal results
• Migrating the entire data warehouse from one Netezza box to other Netezza box
• Building/Mirroring data marts in the brand new Netezza box to enable disaster recovery management
• Developing an application component using Netezza nzsql, nzload, nzmigrate and external table utilities
• Designing multiple sequential and parallel Datastage jobs using appropriate Datastage components
• Exploring Retailer data feeds and proposing solution for new client request using Data cleansing and Transformation in IBM Datastage
• Applying in-depth knowledge of ETL core concepts and resolve problems
• Studying and exploring operational complexities exist in the system and providing solution for the same
• Reviewing code and solution suggested by team members
• Working with cross functional team like Architecture, Support, Development and Operations

Confidential

Technical Team Lead

Technologies: Datastage 7.5, Netezza 6.2, Oracle 11g, JAVA, SQL, PL/SQL, Netezza SQL and UNIX Shell Scripting

Responsibilities:

• Assessing the entire system and performing FMEA to find potential failures
• Driving System Improvement Plans and bring stability in the platform
• Developing application components in NZSQL, Oracle PL/SQL to support change request and code fix
• Building Datastage jobs to migrate data from Oracle to Netezza databases
• Performing complex Data Analysis with Data Science and providing solutions
• Building redundant and fail-over application components to enable disaster recovery management
• Handling Incident Management and recovering high severity production issues within SLA
• Providing Root Cause Analysis using standard 5-WHY and Fish-bone Analysis
• Providing permanent solutions for the high severity incidents through Problem Management
• Managing project timelines and keeping say-do ratio up
• Collaborating with client team and planning low level tasks required for deployment

Confidential

Senior Software Developer

Technologies: Oracle 10g, ODI, JAVA, SQL, PL/SQL, SAS SQL, UNIX Shell Scripting

Responsibilities:

• Gathering system requirements to build a connecting system between legacy and enhanced version of application
• Discussing all system requirements with architects and users and freeze design approach
• Developing a connecting system components using Oracle SQL, PL/SQL Stored Procedures and Functions, Oracle Data Integrator (ODI), Shell Scripting
• Rewriting Store Facts Modeling (SFM) algorithm in SAS SQL that calculates Store ACV, Selling Sqft, Number of Employee and other metrics for a particular store irrespective of country/region
• Perform Unit Testing and documenting test cases and test results
• Stabilizing system performance by looking at Oracle SQL query plan and rewriting SQL query
• Providing assistance in SQA and UAT testing
• Planning the cut-over approach to transition into enhanced application from legacy application
• Supporting post production issues with high quality recovery and resolution
• Documenting high level design, low level design, UML diagrams, and unit test results artifacts

Confidential

Software Developer

Technologies: Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting

Responsibilities:

• Requirement analysis for the given change request
• Converting user requirements into system requirements
• Discussing design approach with architects and freezing it
• Building application code using Shell Scripting and PL/SQL stored procedures
• Modifying Autosys jobs and its parameters to in corporate the change in pattern matching
• Perform Unit Testing and documenting test cases and test results
• Providing assistance in SQA and UAT testing
• Deploying build into assembly and SQA environments
• Supporting post production issues with high quality recovery and resolution
• Documenting high and low level design artifacts

Confidential

System Analyst

Technologies: Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting

Responsibilities:

• Providing end to end application support
• Provide high quality solutions to high severity issues within defined SLA
• Utilizing in-depth knowledge of SQL and Scripting to fix performance issues
• Migrating application components from AIX to LINUX platform
• Upgrading applications in higher versions of Oracle and Ab-initio
• Implementing process improvements that helps to reduce cycle time of client deliverables
• Maintaining Autosys scheduler and jobs
• Communicating timelines of deliverable with clients
• Coordinating with onshore and offshore technical leads
• Documenting technical artifacts