EBI Operation is the Production support team of Freescale,  Managing entire EBI Cycle of Freescale , which includes development of Change request received time and again from the client in datastage and Teradata SQL.

Ø Actively involved in managing the entire EBI operation cycle of Freescale.

Ø Daily activities include working on change request received from the client (i.e changing the Bteq script to load data as per new business logic and creation of new table loading script and further documentation of the details)

Ø Involved in writing scripts for loading data to target data warehouse using teradata utilities like BTEQ, Fast Load and MultiLoad.

Ø Automation of Process for business by standardization and scheduling.

Ø Abend fixing, discrepancy resolution.

Ø Defining strategies for migration of Database Objects, Data and Data Quality.

Ø Monitored 1600+ jobs running in production environment and provided quick and fast resolution to any load failures.

Ø Experienced in archiving, restoring and recovering data on Teradata using ARC utility and TARA GUI.

Ø Very well trained and experienced in scheduling backups and recovery of the entire EDW databases across various geographical locations for the business continuity and response time.

Ø Handling efficient way of data and DDL backups and environment refreshes.

Ø Expert in UNIX scripts for Database extraction and filtering.

Ø Wrote SQL scripts for backend databases, custom stored procedures, macros and Packages along with Referential Integrity triggers.

Ø Enhanced and Customized load scripts to the newly developed and in design projects.

Ø Expert in UNIX and shell scripts for Database extraction and filtering.

Ø Controlled and tracked access to Teradata Database

Ø Good experience in creating dynamic Bteq queries using shell script.

Ø Creation of one-shots to fix discrepancies In data or processing.

Ø Involved in unit testing Involved and Preparing test cases.

Ø Involved in gathering the requirements for the forms.

Ø Written scripts using Bteq, Fastload, Multiload, Fastexport, Tpump and Queryman.

Ø Involved on error handling with the help of tables like ET, UV and WT.

Ø Worked with joins, sub queries, set operations extensively.

Ø Did performance tuning at various levels.

Ø Prepared BTEQ import, export scripts for tables.

Ø Written BTEQ, FAST LOAD, MULTI LOAD scripts .

Ø Prepared FAST EXPORT script for tables.

Product Cost Planning was an area within SAP, to plan costs for manufactured materials, services, other intangible goods and set prices for materials and other cost accounting objects. The purpose was to calculate the cost of goods manufactured (COGM) and determine the Cost of Goods Sold (COGS) for each product unit. Cost breakdown by each product and to calculate value added at each stage of completion. Assist in strategic decisions like make vs. buy, pricing, market analysis, Inventory valuation, variances and reserve calculations. The objective of this project was to migrate the lively running database (For Freescale Semiconductor Inc.) from SAP to TeraData

Ø Worked in all phases in Software Development Life Cycle from requirement gathering to production Implementation of an Entity.

Ø Understand complex business requirements and transformation for ETL and Reporting with continuous interaction with Clients and BA's.

Ø Analyze and Design the new requirements and find the optimum solution to develop the requirement in DB, Data Modeling, ETL and Reporting.

Ø Written scripts using Bteq, Fastload, Multiload, Fastexport, Tpump and Queryman.

Ø Involved on error handling with the help of tables like ET, UV and WT.

Ø Creation of Datastage jobs.

Ø Worked with joins, sub queries, set operations extensively.

Ø Did performance tuning at various levels.

Ø As part of the SEI CMM Level 5 process, create various documents viz. Estimation sheets, Requirement Analysis, Design Documentation, Mapping Document, Test Cases, RTT log, MOM, Review log, Timesheet and Checklists for ETL, Scripting and Reporting.

Continuous effective coordination and communication with my Team Members, Team Leads, Project Manager, Onsite coordinator, Client, BA's.

Understand and develop complex ETL (Graphs and Shell Scripting), SQL Queries and Reports for various Projects and Modules.

CATS  ( Collabera Applicant tracking System) is the project of Collabera Consulting Pvt ltd

Ø Worked as SQL developer.

Ø Interacted with application developers in creating SQL queries for the Functional module.

Ø Converted MS Excel worksheets into MS SQL Server 2000 database, such as: Created database and tables/views, Setup relationship among tables, wrote stored procedures, and triggers.

Ø Optimized SQL server performance using tools like MS Query analyzer, MS SQL profiler, and index tuning wizard.

Used Crystal Report 11 to generate various reports for business analysis purpose.

Ø Develop effective sourcing and recruiting strategies from `initial screening' to the `offer closure'

Ø Responsible for providing desired recruitment solutions to internal and external project within the stipulated time.

Ø Closing candidates proactively for Niche skills and generate higher revenues for the company.

Ø Extensively experience in working with C2C, W2, 1099.

Ø Recruited and placed consultants for Global leaders like, Johnson & Johnson, Wachovia,BCBS, IBM,JPMC, Freddie Mac, Fannie Mae,AT&T, Verizon Telecom, Verizon Business, AIG and more

Ø Successfully recruited consultants for various software projects on different verticals like Financial, Banking, Brokerage, Insurance, & Consulting firms on Contract.

Ø Interaction with Technical Panel/Technical leads/Resource Managers for requirement understanding, technical screening, involve in the overall end-to-end process of recruitment

Ø Recruiting via Internet job boards (Dice.com, Monster.com) direct phone sourcing, vendor network, referrals and expanded Internet sourcing.

Ø Submit qualified candidates to the US team.

Ø Responsible for screening candidates to ensure their qualifications meet open positions.

Ø Conducting phone interview for prospective candidates, Coordinating interviews.

Internet savvy to perform targeted Internet research/searches identifying candidates to meet our client needs.