OBJECTIVE

• To pursue a rewarding career with challenging roles and teh opportunity to learn something new every day, which will help me to explore myself fully and realize my potential. Willing to work as a key player in challenging and creative environment.

SUMMARY

• 9+ years of IT experience with expertise in developing Business Intelligence Reporting, Data modeling, Analysis, Design, Development, Implementation and Testing of Database/ Data Warehouse applications.
• Excellent with Oracle PL/ SQL, SQL Server, Netezza SQL, Unix, Teradata, Informatica.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Experience in analyzing teh data generated by teh business process, defining teh granularity, source to target mapping (Informatica) of teh data elements, gathering requirements and analysis for teh data warehouse design and development.
• Have experience in preparing teh Test Strategy, Test plan, Detailed Test cases by splitting down business requirements and defect management to support quality deliverables.
• Agile working experience in ETL Data warehouse Projects.
• Interact with customers to determine business/technical requirements/User Stories, analyzing business process and workflow, developing functional or external specifications and designs.
• Hands on experience in data warehousing concepts including Meta data and Data Marts.
• In - Depth work experience on all stages of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, security management and production support.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with teh ability to grasp things quickly.
• Hands on experience on teh ETL process (SRC -> STG -> 3NF -> MART) and movement of data between layers.
• Strong experience in using Teradata Utilities - BTEQ, M-Load, F-Load, F-Export, T-Pump & TPT
• Strong experience in writing Teradata Loader Scripts
• Demonstrated leadership abilities and team work skills as well as teh ability to accomplish tasks under minimal direction and supervision.
• Have good experience in Dev methodologies - Waterfall and Agile methodology and have used tools like JIRA and Rally for tasking.
• Collaborate with other Onsite and Offshore QA team to accomplish teh daily task on time. Prepared daily development status reports to communicate teh dev status with teh management.
• Experienced to work with Development team, Production support team and Business Analysts in handling critical situations to meet teh deadlines for successful completion of teh tasks/projects.

TECHNICAL SKILLS

Database: Oracle 10g/9i/8i, Teradata V2R5, Netezza SQL

Operating System: Win 98/XP, Vista, 2007, Win7 & 8, UNIX

Programming & Scripting: Shell, SQL and OOPS Concepts

DBMS Tools: TOAD, SQL* PLUS, Aginity, WinSQL

ETL: Informatica, Syncsort

Reporting Tools: Microstrategy

Utilities: Toad, Putty, WinSQL, WinSCP, Tidal Scheduler, SVN, CVS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Exadata/Informatica Developer

RESPONSIBILITIES:

• Extensively worked converting teh existing Informatica mapping with Netezza to Oracle Exadata.
• Created Unix script for various activities and for testing teh conversion data.
• Created Unit Test documents and test script for teh same.
• Fixed issues related to teh migration of teh database.

ENVIRONMENT: Netezza TwinFin 12, Toad 11.6, Informatica Power Center 9.5.1, Unix shell scripting, Autosys 11.3, SVN, Windows.

Confidential, Charlotte, NC

Team Lead/Sr. Teradata Developer

RESPONSIBILITIES:

• Extensively worked with Business Analyst & Users in understanding teh Source to target Mapping documentation.
• Involved in teh full systems life cycle for Revenue generating application Data warehouse and responsible for designing, developing teh applications software dat is delivered on time, in line with business objectives.
• Working extensively in migrating teh application from NETEZZA to Teradata platform.
• Working with large data-set using Teradata utilities like Bteq and Tpt Experience in integration of various data sources like Oracle, Teradata, Flat files.
• Used Informatica to pull teh data from Oracle and prepare flat files.
• Attended teh meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying teh physical infrastructure, system study, design, and development.
• Developed complex SQL queries to develop teh Interfaces to extract teh data in regular intervals to meet teh business requirements, extensively used Teradata Utilities like M - load, F- Load, BTEQ and Fast Export.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating teh execution of maps.
• Extensively worked on Performance tuning to increase teh throughput of teh data load (like read teh data from flat file & write teh data into target flat files to identify teh bottlenecks).
• Implemented Slowly Changing Dimension Type me &Type II for different Dimensions.
• Written Unit test scripts to test teh developed interfaces.
• Provided support for teh production department in handling teh data warehouse.
• Worked under Agile methodology and used Rally tool one to track teh tasks.
• Written thorough design docs, unit test documentation, Deployment & Runbook documents.

ENVIRONMENT: Teradata 14/12, Netezza, Flat Files, Sql Assistant, Informatica Power Center 9.6, Unix shell scripting, MicroStrategy, Tidal, SVN, Rally, Windows.

Confidential, Charlotte, NC

Team Lead/Sr. Teradata Developer

RESPONSIBILITIES:

• Requirement gathering, to understand teh requirement of teh project by interacting with various stake holders involved, analyze and document teh requirements.
• Extensively worked with Business Analyst & Users in understanding teh Source to target Mapping documentation.
• Project execution, ie execute teh project as per teh plan signed off by all stake holders and report for any deviations.
• Team co-ordination with offshore and onshore.
• Extracted teh data from flat files or external data sources and loaded them intoTeradatausing Fast-load/Multi-load to perform analysis and generated reports from them
• Developed complex SQL queries to develop teh Interfaces to extract teh data in regular intervals to meet teh business requirements.
• Created UNIX shell scripts for various needs.
• Involved in preparing teh Migration Documents.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts
• Successful in Providing 24x7 On-call Support for Production Issues.
• Worked on few conversion projects from Informatica/Oracle to Netezza/SQL. Also did teh conversion from Netezza/SQL to Teradata as well.
• Worked on Test cases, unit testing and integration testing, also coordinating with teh QA team and resolve and issues.
• Responsible for teh performance tuning of teh ETL process Confidential source level, target level, mapping level and session level.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating teh process.
• Performed error handing using session logs
• Worked under Agile methodology and used Rally tool one to track teh tasks.
• Written thorough design docs, unit test documentation, Deployment & Runbook documents.
• Extracted teh data from flat files or external data sources and loaded them intoTeradatausing Fast-load/Multi-load to perform analysis and generated reports from them

ENVIRONMENT: Teradata 14/12, Netezza, Oracle, Toda, Informatica, Flat Files, Sql Assistant, Unix shell scripting, MicroStrategy, Tidal, SVN, Rally, Windows.

Confidential

ETL Developer/Technology Analyst

RESPONSIBILITIES:

• Written thorough design docs, unit test documentation, Deployment & Runbook documents.
• Extensive System study, data mining of teh old OMS system to understand and develop teh data model for teh new system.
• Design and implement teh reports logic in teh system.
• Defect analysis and Support in teh Testing and deployment phases.
• Developed unit test cases and did unit testing for all teh developed Informatica mappings.
• Created and modified several UNIX shell Scripts according to teh changing needs of teh project and client requirements.
• Involved in teh continuous enhancements and fixing of production problems.
• Provided 24/7 On-call Production Support for various applications and provided resolution for night-time production job abends, attend conference calls with business operations, system managers for resolution of issues.

ENVIRONMENT: Netezza, Flat Files, Sql Assistant, Unix shell scripting, Tidal, SVN, Rally, Windows, Syncsort.

Confidential

ETL Developer

RESPONSIBILITIES:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Reviewing teh data model and ETL flow with Modelers & Architects.
• Understanding of client requirements during team discussions.
• Developing of audits and scoring rules for data quality management.
• Resolving technical issues if any, Unit testing.
• Integrating with teh system, support and maintenance of teh data quality controls.
• Defect analysis, talking with data stakeholders in resolving data issues, enhancing teh supporting and status reports for teh controls created and preparing relevant documents.
• Co-ordination with QA, support team for successful implementation of teh project.
• Worked on various Teradata tools like Bteq, Mload, Tpump etc for various loads and data extracts.
• Extensively created unix scripts for emailing teh audit/scoring reports to teh business team. By doing so eliminated teh time for generating teh same.
• Worked with Functional team to make sure required data TEMPhas been extracted and loaded and performed teh Unit Testing and fixed teh errors to meet teh requirements.
• Tuned a ton of quires and also created many automation process to eliminate teh manual work which was done and thus saved time.
• Created and used volatile tables for testing purposes
• Involved inCode Reviews & Unit Testingfor teh ETL code developed.

ENVIRONMENT: Teradata, Flat Files, Sql Assistant, Unix shell scripting, Maestro, SVN, Rally, Windows.