SUMMARY:

• Excellent knowledge in Analytics tools like SAS, R, and Matlab .
• Experience in forecasting various domain like sports, energy using analytical tools.
• Excellent knowledge in System optimization tools like CPLEX, AMPL, and GUROBI etc.
• Having nearly around 4.3 years of work experience in IT with experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP applications on Windows and Unix platforms
• Informatica certified developer.
• Infosys certified IBM infosphere Datastage developer.
• Infosys certified for CPG Retail domain.
• Experienced with planning, architecture, and design of data warehousing in Informatica and SQL optimization
• Excellent Knowledge in TERADATA data warehouse architecture, Teradata utilities and Teradata SQL
• Experienced in Talend ETL tool and Datastage ETL tool used for staging and loading data from Source.
• Proficient in architectural diagrams, logic flowcharts, data maps, operating, maintenance and support procedures, and detailed documentation of the technical design
• Highly experienced in SQL performance tuning and debugging of existing ETL process.
• Well versed with various aspects of ETL processes used in loading and updating Teradata data warehouse.
• Experienced with mentoring Teradata Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing
• Full SDLC experience including Analysis, Design, Development, Testing and implementation of the system.
• Team player with good communication skills, written skills, technical documentation skills and also a self-motivated individual with exemplary analytical and problem solving skills.
• Demonstrate a willingness, interest and attitude to learn new technologies and skills.
• Strong Business Domain knowledge of Retail sector
• Received multiple Awards for exemplary Leadership, excellent support for Offshore in ensuring timely deliveries and seamless coordination, recruitment, Learning and Knowledge Sharing.
• Appreciation from Customer for Outstanding Contributions in resolving challenging Issues and defect free deliveries.
• Lead on Multiple projects at the same time, overseeing teams at Offshore across multiple areas (ETL Development).

TECHNICAL SKILLS:

Databases: Teradata 12, Teradata 13, Teradata V2R5, Teradata V2R6, IBM Datastage 8.0,Talend ETL tool,, Oracle Toad 11g, Microsoft Access

Operating systems: Windows, UNIX

Software engg tools: Visual source safe, Sub version, IPM+, WinSCP, Quality center, WinCVS,

Data modeling tools: MS VISIO

Application Utilities: Teradata, BTEQ, Multi load, Fast export

Informatica: ETL Data Load Utility tool SAS, Analytics tool, R- Analytics tool, Cognos TM1, Confidential tool, Talend, ETL Data load utility

Tidal Scheduling tool: GURIBO

Autosys Scheduling tool: CPLEX, AMPL

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Technology Analyst

Technology: Informatica, Teradata, Oracle, UNIX

Tools : Informatica 9.1, Autosys, Toad, Sub version, WinScp.

Responsibilities:

• As Offshore lead, was involved in extensive Business requirement analysis and Planning Module execution plans.
• Involved in Complex ETL Architecture designing for new interfaces in PSI.
• Performance Tuning in existing ETL Aggregate and Cube tables used in Business Intelligence environment.
• Involved in complex framework development to convert the upstream Source data into data warehouse.
• Analysed on the existing framework and identified the potential issues which lead to data corruption on the BI layer.
• As lead, provided Estimation and preparing the plan for implementation.
• Gained Good knowledge in Oracle for loading the data from Source using Toad.
• Rewrote complex logic of High Speed Data extractions in the reporting layer.
• Enhanced the logic to calculate customer information accurately.
• Performance tuning of data mart sqls using optimal sql methodologies that used SCD Type 2
• Code Reviews and bottom-line ownership for the deliverables of the Development Team
• Managing team of 3 offshore resources.
• Supported in production run, got appreciated for solving various issues and contributing to get green status for Project.

Confidential

Offshore Lead, Nike, Beaverton

Technology: Informatica, Oracle 10 g, UNIX

Tools : Informatica 9.0 ETL tool, Autosys, Sub version, WinScp, hp Quality center

• As a developer was involved in Design coding and unit testing for EDS layer.
• Was involved in extensive analysis for the current Nike Warehouse data.
• Have good knowledge about Enterprise Information Management framework followed in Nike DW.
• Data extracts from the warehouse sent to external applications
• Data was sent to multiple servers from SAP source to Oracle targets
• As lead, provided Estimation and preparing the plan for implementation.
• Was Managing team of 3 members

Confidential

Technology : Cognos TM1, UNIX, IBM Data stage, Microsoft access

Technology: IBM Cognos TM1, Oracle 10 g, UNIX

Tools : IBM Cognos TM1 10, Microsoft Access, Cognos Tm1 web, Toad

• As Offshore module lead , managed a team of 4 members and was responsible for end to end Module delivery.
• As a developer was involved in Design coding and unit testing for Semantic layer.
• Was involved in extensive analysis for the current TESCO Warehouse data.
• To gather requirements from Onsite team, analyze the data and come up with the best possible design.
• Identified and implemented operational architecture changes in the warehouse for performance improvement.
• Estimation and preparing the plan for implementation.
• Performed project management activities like SPC Logging and Metric reports preparation.
• Version and Request management in IPM+
• Experienced in loading data from excel files .
• Research on failures to make permanent fix and implementing permanent fixes through CR.
• Provided best solution to fix business and technical production issues.