|
|
|
Junior Member
 
Group: Forum Members
Last Login: 12/4/2008 8:06:04 PM
Posts: 19,
Visits: 48
|
|
|
Any body interested for a teradata developer job in usa please let me know ASAP.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 12/5/2008 11:03:29 PM
Posts: 15,
Visits: 16
|
|
Hi,
My contract is going to end,
I am looking for a job in TERADATA WITH UNIX / MAINFRAME.
Thank you
Gopi
Thank you
Gopinadh
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 12/5/2008 11:03:29 PM
Posts: 15,
Visits: 16
|
|
Hi ,
I am looking for right opportunity at teradata.
Can you forward the job description to my email:id = gopi.mainframe@gmail.com
thank you..
Gopi..
Thank you
Gopinadh
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2/27/2009 1:15:58 AM
Posts: 5,
Visits: 24
|
|
Hi
Please send me job Description.
sridhar_quality@yahoo.com
Thanks,
Hi Friends,
Next week i am writing the Teradata basic,Physical Implementation ,sql.if u have any model question paper or PDF document for this level...plz send to me.....
Thanks
Sridhar
sridhar_quality@yahoo.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/7/2009 1:32:06 AM
Posts: 4,
Visits: 5
|
|
Hi Sridhar,
If you find any material for the tera data basics,and other please send the same to my below id.
hello_nisar2000@yahoo.com
Nisar ahmed,
SR.mainframe Developer
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 12/30/2008 12:09:14 AM
Posts: 7,
Visits: 8
|
|
|
For Teradata Training & Certification with 100% guarenty. Plz write aloo_a2@yahoo.com. For sample classes or video tutorial write to aloo_a2@yahoo.com. I provide only classes. I have 10yr+ exp in Database 6yr+ in Teradata. I'm working professional.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/21/2009 6:12:51 PM
Posts: 6,
Visits: 6
|
|
I am intersted in Teradata Openings
I am US right now
Please let me know if you have any openings
Thanks in advance!!
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/13/2009 10:59:43 AM
Posts: 2,
Visits: 3
|
|
Hi ,
Ihave excelent Teradata Profiles.
Can you forward the job description to my email:id = madhuri@logicbridgeinc.com
thank you..
madhuri
Thank you
madhuri
SHRAVAN KUMAR. MOGILICHERLA
EXPERIENCE SUMMARY:
• Having Eight (8) years of comprehensive experience with s/w skills in Data Warehousing involves Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation.
• Very strong skills on project management, requirement analysis, business analysis, database modeling, design and analysis, issue co-ordination and development with Teradata/Oracle/SQL Server based Relational Databases.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
• Analysis of Business and system requirements including impact analysis of existing systems and create detail requirements with the consultation of Business users and technical architects.
• Creation and maintenance of detail project plan and master test plan.
• Hands-on experience leading diverse cross-functional teams through all phases of technology rollout while serving as technical expert and mentor.
• Developed technical documentation for the requirements.
• Familiar with Logical Data Model and Physical Database design.
• Good command in RDBMS Systems like SQL, PL/SQL, DB2, SQL Server, Oracle, Teradata.
• Experience in application development using system analysis, design and modeling techniques like Unified Modeling language (UML), Entity Relationship Diagrams (ERD).
• Six plus (6+) years of experience using Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, Exposure to T pump on UNIX/Windows environments and running the batch process for Teradata CRM.
• Acquaintance with Business Objects XI R2.
• Rapid accommodation to emergent technologies, able to quickly learn new technologies and proprietary systems.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems.
Technical skills
Category Skills
Operating Systems Windows, UNIX, DOS
RDBMS Teradata, Oracle 8i/9i/10g, DB2, SQL Server, MS Access
Languages Unix, SQL, PLSQL, Oracle, SQL*Plus, C, JAVA
TD Utilities BTEQ, Fast Load, Multi Load, Fast Export, T Pump, Arcmain, PMON, Teradata Administrator, Teradata Analyst pack (Visual Explain, Index izard, statistics wizard, TSET), Queryman, Teradata Dynamic workload manager, Teradata manager, Net Vault, Multi tool, QCD, DBQL, Acclog, Crashdumps.
Reporting tools Business Objects BOXI, Pivot tables and Graphs.
ETL Tools Informatica power center 7.1
Other tools MS-Office, Visio, ERWIN, Toad, Telnet, SFTP
EDUCATION AND QUALIFICATIONS:
• Bachelor of Technology in Electrical and Electronics Engineering.
(Jawaharlal Nehru Technological University).
• Teradata ADVANCED Certified Professional V2R5
o Teradata Certified Professional V2R5.
o Teradata Certified SQL Specialist V2R5.
o Teradata Certified Implementation Specialist V2R5.
PROFESSIONAL EXPERIENCE:
Deutsche Bank, 60 Wall Street, New York DEC 2007-TILL DATE
TERADATA SENIOR DEVELOPER
Description:
Deutsche Bank is a leading global investment bank with a strong and profitable private clients franchise. Its businesses are mutually reinforcing. A leader in Germany and Europe, the bank is powerful and growing in North America, Asia and key emerging markets.
Asset Finance & Leasing (AFL) is the Division of Deutsche Bank and center of competence for capital, project and real estate advisory as well as for arranging and financing services centered on diverse asset classes, such as Aircraft, Ships, Real Estate and Infrastructure. It includes, for example Real Estate Leasing, Structured Investments and Construction Management. AFL's role differs in each specific transaction. They provide expertise as arranger, advisor, equity underwriter, and lessor or as manager for real estate facilities.
Leasing and asset finance transactions involve complex, long-term structures that are tailor-made to serve the specific legal and accounting requirements of the parties involved as well as to provide for the general framework of the respective regions. To successfully close such transactions, AFL is made up of professionals with backgrounds in the banking, leasing, and manufacturing and consultancy sectors. Experts across various regions work closely together to find the best solutions for their clients. AFL teams are based in Europe, the United States, Singapore, Dubai and Japan. We will get the data from multiple sources belongs to multiple areas of the business. This project meant to hold the raw data getting from the fields and keeping historical transactions and satisfying the reporting needs of the high level management. This project delivered a most trusted data warehouse to satisfy the reporting needs and single fact store.
Responsibilities:
• Communication with business users and analysts on business requirements. Gathering and documenting the technical and business Meta data about the project.
• Analysis of the specifications provided by the clients.
• Involved in discussions on the data requirement topics.
• Populating the masked data into the development machine to facilitate offshore development activities And Maintenance of users and space provided.
• Monitored Masking activity on the sensitive data.
• Rendered services as DBA-4 interacting more with developers.
• Mastered Teradata loading utilities like Fast load, Multi load.
• Worked with Exporting Utility Fast Export.
• Used Data Demographics to select columns for Primary Index.
• Created PPI, Secondary indexes as per requirement.
• Created Join Indexes.
• Used Unix to execute the scripts.
• Used unix schedulers like crontab.
• Used Teradata Administrator to check the skew factors, spaces.
• Used PMON to check system health.
• Created designs to facilitate continuous loads.
• Managed the several Database statistics by creating the triggers.
• To maintain the uniformity, created the user profiles and used Roles group users.
• Used Multi valued compression logic to maximize the Free space
• Involved in the code reviews prepared by the teams.
• Created production support documents.
Environment: Windows, UNIX, Vi Editor , Oracle 9i, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, SFTP, PMON, TD ADMINSTRATOR, Teradata manager, Backbone’s Netvault 7.0, ARC, DBSControl, DBQL, Teradata Analyst pack, QCD.
Adara Networks, 10 Victor Square, Scotts Valley, CA Jul 2006 – Nov 2007
Customer Analytics Information System
TERADATA SENIOR DEVELOPER
Adara has created a platform of proprietary routing products that operate at the Application-layer (Layer 7 of the OSI Reference Model) to optimize network performance and virtualize network resources. Adara has succeeded in delivering the technology and products using revolutionary, high-performance, distributed network solutions. Adara products are completely compatible, transparent, and non-disruptive to existing client, server and network infrastructures; their technology enables applications with large-bandwidth or low-latency requirements to operate over a wide-area network while providing LAN-level performance.
The Customers of Adara are organizations who need network access to information, applications and services. The benefits of our solution increase, rather than decrease, as information, networks or users become increasingly complex or distributed; resolving a long-standing and unsolved problem in networking and computing in general. They offer prospective customers the ability to leverage tangible, immediate ROIs, to increase top line revenues while realizing improved gross, operating and net margins. Since we have developed an application-agnostic routing platform, one that supports all application layer services, Adara offer customers a fully extensible product; a solution for today and for the network-based services of the future. Perhaps most importantly, Here, customers are business partners to which we offer an ability to penetrate their competitor’s customer bases, while erecting a defensive barrier to penetration of their own client base.
This project is meant to keep track of the Customer calls which holds the complaints, helpdesk, request for the documentation, etc and handling the customer contract and Services info. Solid customer base is modeled and populated to make helpful for the CRM systems to serve the customers better and satisfying the high level reporting structure.
Responsibilities:
1. Maintenance of Data models of the aEDW.
2. Communicated with the source teams and Business analyst to finalize the requirements.
3. Reviewing code both technically and functionally and documenting results.
4. Worked with team for the development of load scripts to load the flat files into the aEDW tables depends on the load type like incremental, full flush or CDC.
5. Created the mappings to implement the business logic on the data coming from Oracle system.
6. Worked on Teradata loading utilities Mload, Fastload and FastExport.
7. Involved in writing the Business logic in BTEQ and Query optimizations
8. Created informatica workflows and schedule the jobs.
9. Automated and scheduled SFTP to transfer data from other systems.
10. Worked independently on ad-hoc reports
11. Timely reports to the high level management.
12. Used crontab to schedule the jobs in unix environment.
13. Worked as a DBA 4 to make the development environment ready.
14. Developed the triggers to handle history and audit data for production environment.
15. Created users, roles, profiles and Objects and system rights.
16. Used PMON to check the production machine health check and worked with On Call DBA to manage the sessions.
17. Performed the Multi valued compression
18. Involved with team to finalize the production support manuals.
19. Involved in monitoring and controlling the sessions of different jobs running on NCR machine using the PMON
20. Creation and scheduling the Net Vault jobs and monitoring.
Environment: Windows, UNIX, Vi Editor , Erwin, Oracle 9i, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, SFTP, PMON, TD ADMINSTRATOR, Teradata manager, Backbone’s Net vault 7.0, ARC, DBSControl, DBQL, Teradata Analyst pack, QCD, Informatica power center 6.0, Informatica workflow manager and monitor
Abbott Laboratories, 100 Abbott Park Road, Abbott Park, Illinois Aug 2005 - Jun 2006
TERADATA SENIOR DEVELOPER
It is a global, broad-based health care company devoted to discovering new medicines, new technologies and new ways to manage health. Abbott products span the continuum of care, from nutritional products and laboratory diagnostics through medical devices and pharmaceutical therapies. Their comprehensive line of products encircles life itself - addressing important health needs from infancy to the golden years.
Abbott has sales, manufacturing, research and development, and distribution facilities around the world, close to where our customers need us to be. Abbott management need the best warehouse system need to hold the manufacturing and sales of manufacturing systems, to recognizing the threshold to generate the order for the manufacturing unit , to identify the trends of the medicines movement across the world every season. Daily reports need to show the previous day manufacturing order details and quantity, Sales cubes need to reflect the exact business with timely reporting. Apart from that serving the dependent systems by pushing the medicines base compositions to SQL server and Oracle applications to make xml compatible for the GUI applications.
Responsibilities:
• Understanding the BRD and Participation in Client meetings to understand the business needs for new developments/enhancements.
• Writing SRS, Design documentation.
• Requirements gathering
• Offered the services of DBA-4.
• Creating Teradata macros for the rollup process.
• Managed Back Up jobs.
• Created and managed the Users on non-production Environment.
• Managed the Space Allocation in non-production Environment.
• Worked with the System Health Check.
• Writing bulk load and fast export scripts to bring the data from several databases.
• Involved in making the CDC process using the Informatica mapping designer.
• Tuning the performance of the code
• Creating workflows in informatica to run the BTEQ scripts and bulk loads.
• Prepared of Test cases and Participated in the peer reviews
• Prepared Presentations and process document as per CMM Level 5
• Maintained the production objects.
• Provided excellent support to production and stabilizing.
Environment: WINDOWS, Red hat Linux, Teradata V2R5, Oracle 9i, DB2, ER-Win 3.5.2, NDM, SFTP, BTEQ, Query man, Multiload, fast export, Teradata Analyst pack : Teradata Visual Explain, Statistical wizard, Teradata Manager, Teradata Administrator, PMON, Informatica workflow manager, workflow monitor, mapping designer, OLE Loads
Witness Systems Inc, 3979 Freedom Cir # 500, Santa Clara, CA Nov 2004 - Jul 2005
TERATADA DEVELOPER
Client: DaimlerChrysler Customer Assistance Center
Quality-driven customer service is a core DaimlerChrysler value, and for our many European customers that begins with the quality of service provided by our Customer Assistance Center in Maastricht [the Netherlands]. Implementing a monitoring solution would help us increase the quality of our customer service and make it more transparent and consistent. After carefully assessing available solutions, they selected the Witness Systems approach based on its functionality, ease-of-use and Web-based architecture.
The main focus of this project is to hold the Customer service information gathered at various service layouts and shops to help the several dependent online and CRM applications. This project has shadow metric that is identification dots at their service centers from the survey info gathered from several trusted sources. Prepared best warehouse system and other designs to support the web reports as well as to serve the ad-hocs to take the flexible plans over the business. Client impressed with our focus on business drivers and its proven strength of the warehouse.
Responsibilities
• Writing SRS, Design documentation.
• Requirements gathering
• Creation of environment and maintenance in prod and non-prod box like creation of database, handling the new user request and their privileges using there Teradata Administrator.
• Creating Teradata macros and BTEQ scripts for the rollup process
• Writing bulkload and fast export scripts to bring the data from several databases.
• Involved in making the CDC process using the Informatica mapping designer.
• Tuning the performance of the code by justifying the performance with the teradata objects like SI, JI, HI, PPI etc.
• Creating workflows in informatica to run the BTEQ scripts and bulk loads.
• Prepared of Test cases and Participated in the peer reviews
• Prepared Presentations and process document as per CMM Level 5
• Maintained the production objects.
• Provided excellent support to production and stabilizing.
Environment: WINDOWS, Unix, Teradata V2R5, Oracle 9i, ER-Win 3.5.2, SFTP, BTEQ, Query man, Multiload, fast export, Teradata Analyst pack : Teradata Visual Explain, Statistical wizard, Teradata Manager, Teradata Administrator, PMON, Informatica workflow manager, workflow monitor, mapping designer.
WallGreens Retail Aug 2003 – Oct 2004
TERADATA DEVELOPER
This project is to provide the data for the mining, ad-hoc reporting and planned reporting structure. Technically the main aim of this project is making a solid base for customer sales and services information. Need to provide the data whatever the data miners needed to build the scores and profitability of the card members. The data we gather from multiple sources will be utilized to build the statistical model to plan for promotions and to attract the categories of the customers based on their lifestyle and social strength.
Responsibilities:
• Involved in Client meets and understanding BRD
• Performed source system study and Requirement gathering
• Creation of the mapping documents and reviews with the data architects
• Communicating with the Client for the shadow metrics implementations
• Preparation of testing and quality documents
• Designing the ETL model to gain the metrics
• Presentation and reviewing the models with in the team
• Making the Teradata objects, BTEQ scripts, Mload and fast export scripts
• To get the data from Oracle used Spool on/off script and
• To get the data from SQL server used the DTS tasks and scheduled the SQL packages.
• Tuning and optimization of Teradata Queries
• Using the Unix wrappers to make the workflows
• Performing the unit testing
• Involved in Peer views
• Preparation of testing cases Documents
• Supporting in bug fixing and helping the data validation team.
• Preparation of Production support document
• Maintaining the production script
• Providing and monitoring the stats after the drop to verify the stability of the job and data quality.
• Sending the stats report to the high level management using the pivot tables and xls graphs.
• Helping the Reporting team by providing the teradata queries
• Fulfilled ad-hoc requests coming from superiors.
• Worked as a good team player and took participation to improve the team spirit.
Environment: WINDOWS, Unix, Teradata V2R5, Oracle 9i, ER-Win 3.5.2, SFTP, BTEQ, Query man, Multi load, fast export, Teradata Analyst pack: Teradata Visual Explain, index wizard, Statistical wizard, Teradata Administrator, PMON, Unix wrapper
Forrester Research Inc, Cambridge, MA May 2001 – Mar 2003
INFORMATICA Developer
Responsibilities:
• Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources like individual details of the household.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle and mainframes into the Oracle target database.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Connection management and scheduling of jobs to be run in the batch process
Environment: Informatica Power Center 4, Oracle 9i/8i, SQL Server 2000/2005 UNIX Shell Scripting, UNIX, Autosys, Windows 2003.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/13/2009 10:59:43 AM
Posts: 2,
Visits: 3
|
|
Hi ,
Ihave excelent Teradata Profiles.
Can you forward the job description to my email:id = madhuri@logicbridgeinc.com
thank you..
madhuri
Thank you
madhuri
SHRAVAN KUMAR. MOGILICHERLA
EXPERIENCE SUMMARY:
• Having Eight (8) years of comprehensive experience with s/w skills in Data Warehousing involves Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation.
• Very strong skills on project management, requirement analysis, business analysis, database modeling, design and analysis, issue co-ordination and development with Teradata/Oracle/SQL Server based Relational Databases.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
• Analysis of Business and system requirements including impact analysis of existing systems and create detail requirements with the consultation of Business users and technical architects.
• Creation and maintenance of detail project plan and master test plan.
• Hands-on experience leading diverse cross-functional teams through all phases of technology rollout while serving as technical expert and mentor.
• Developed technical documentation for the requirements.
• Familiar with Logical Data Model and Physical Database design.
• Good command in RDBMS Systems like SQL, PL/SQL, DB2, SQL Server, Oracle, Teradata.
• Experience in application development using system analysis, design and modeling techniques like Unified Modeling language (UML), Entity Relationship Diagrams (ERD).
• Six plus (6+) years of experience using Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, Exposure to T pump on UNIX/Windows environments and running the batch process for Teradata CRM.
• Acquaintance with Business Objects XI R2.
• Rapid accommodation to emergent technologies, able to quickly learn new technologies and proprietary systems.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems.
Technical skills
Category Skills
Operating Systems Windows, UNIX, DOS
RDBMS Teradata, Oracle 8i/9i/10g, DB2, SQL Server, MS Access
Languages Unix, SQL, PLSQL, Oracle, SQL*Plus, C, JAVA
TD Utilities BTEQ, Fast Load, Multi Load, Fast Export, T Pump, Arcmain, PMON, Teradata Administrator, Teradata Analyst pack (Visual Explain, Index izard, statistics wizard, TSET), Queryman, Teradata Dynamic workload manager, Teradata manager, Net Vault, Multi tool, QCD, DBQL, Acclog, Crashdumps.
Reporting tools Business Objects BOXI, Pivot tables and Graphs.
ETL Tools Informatica power center 7.1
Other tools MS-Office, Visio, ERWIN, Toad, Telnet, SFTP
EDUCATION AND QUALIFICATIONS:
• Bachelor of Technology in Electrical and Electronics Engineering.
(Jawaharlal Nehru Technological University).
• Teradata ADVANCED Certified Professional V2R5
o Teradata Certified Professional V2R5.
o Teradata Certified SQL Specialist V2R5.
o Teradata Certified Implementation Specialist V2R5.
PROFESSIONAL EXPERIENCE:
Deutsche Bank, 60 Wall Street, New York DEC 2007-TILL DATE
TERADATA SENIOR DEVELOPER
Description:
Deutsche Bank is a leading global investment bank with a strong and profitable private clients franchise. Its businesses are mutually reinforcing. A leader in Germany and Europe, the bank is powerful and growing in North America, Asia and key emerging markets.
Asset Finance & Leasing (AFL) is the Division of Deutsche Bank and center of competence for capital, project and real estate advisory as well as for arranging and financing services centered on diverse asset classes, such as Aircraft, Ships, Real Estate and Infrastructure. It includes, for example Real Estate Leasing, Structured Investments and Construction Management. AFL's role differs in each specific transaction. They provide expertise as arranger, advisor, equity underwriter, and lessor or as manager for real estate facilities.
Leasing and asset finance transactions involve complex, long-term structures that are tailor-made to serve the specific legal and accounting requirements of the parties involved as well as to provide for the general framework of the respective regions. To successfully close such transactions, AFL is made up of professionals with backgrounds in the banking, leasing, and manufacturing and consultancy sectors. Experts across various regions work closely together to find the best solutions for their clients. AFL teams are based in Europe, the United States, Singapore, Dubai and Japan. We will get the data from multiple sources belongs to multiple areas of the business. This project meant to hold the raw data getting from the fields and keeping historical transactions and satisfying the reporting needs of the high level management. This project delivered a most trusted data warehouse to satisfy the reporting needs and single fact store.
Responsibilities:
• Communication with business users and analysts on business requirements. Gathering and documenting the technical and business Meta data about the project.
• Analysis of the specifications provided by the clients.
• Involved in discussions on the data requirement topics.
• Populating the masked data into the development machine to facilitate offshore development activities And Maintenance of users and space provided.
• Monitored Masking activity on the sensitive data.
• Rendered services as DBA-4 interacting more with developers.
• Mastered Teradata loading utilities like Fast load, Multi load.
• Worked with Exporting Utility Fast Export.
• Used Data Demographics to select columns for Primary Index.
• Created PPI, Secondary indexes as per requirement.
• Created Join Indexes.
• Used Unix to execute the scripts.
• Used unix schedulers like crontab.
• Used Teradata Administrator to check the skew factors, spaces.
• Used PMON to check system health.
• Created designs to facilitate continuous loads.
• Managed the several Database statistics by creating the triggers.
• To maintain the uniformity, created the user profiles and used Roles group users.
• Used Multi valued compression logic to maximize the Free space
• Involved in the code reviews prepared by the teams.
• Created production support documents.
Environment: Windows, UNIX, Vi Editor , Oracle 9i, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, SFTP, PMON, TD ADMINSTRATOR, Teradata manager, Backbone’s Netvault 7.0, ARC, DBSControl, DBQL, Teradata Analyst pack, QCD.
Adara Networks, 10 Victor Square, Scotts Valley, CA Jul 2006 – Nov 2007
Customer Analytics Information System
TERADATA SENIOR DEVELOPER
Adara has created a platform of proprietary routing products that operate at the Application-layer (Layer 7 of the OSI Reference Model) to optimize network performance and virtualize network resources. Adara has succeeded in delivering the technology and products using revolutionary, high-performance, distributed network solutions. Adara products are completely compatible, transparent, and non-disruptive to existing client, server and network infrastructures; their technology enables applications with large-bandwidth or low-latency requirements to operate over a wide-area network while providing LAN-level performance.
The Customers of Adara are organizations who need network access to information, applications and services. The benefits of our solution increase, rather than decrease, as information, networks or users become increasingly complex or distributed; resolving a long-standing and unsolved problem in networking and computing in general. They offer prospective customers the ability to leverage tangible, immediate ROIs, to increase top line revenues while realizing improved gross, operating and net margins. Since we have developed an application-agnostic routing platform, one that supports all application layer services, Adara offer customers a fully extensible product; a solution for today and for the network-based services of the future. Perhaps most importantly, Here, customers are business partners to which we offer an ability to penetrate their competitor’s customer bases, while erecting a defensive barrier to penetration of their own client base.
This project is meant to keep track of the Customer calls which holds the complaints, helpdesk, request for the documentation, etc and handling the customer contract and Services info. Solid customer base is modeled and populated to make helpful for the CRM systems to serve the customers better and satisfying the high level reporting structure.
Responsibilities:
1. Maintenance of Data models of the aEDW.
2. Communicated with the source teams and Business analyst to finalize the requirements.
3. Reviewing code both technically and functionally and documenting results.
4. Worked with team for the development of load scripts to load the flat files into the aEDW tables depends on the load type like incremental, full flush or CDC.
5. Created the mappings to implement the business logic on the data coming from Oracle system.
6. Worked on Teradata loading utilities Mload, Fastload and FastExport.
7. Involved in writing the Business logic in BTEQ and Query optimizations
8. Created informatica workflows and schedule the jobs.
9. Automated and scheduled SFTP to transfer data from other systems.
10. Worked independently on ad-hoc reports
11. Timely reports to the high level management.
12. Used crontab to schedule the jobs in unix environment.
13. Worked as a DBA 4 to make the development environment ready.
14. Developed the triggers to handle history and audit data for production environment.
15. Created users, roles, profiles and Objects and system rights.
16. Used PMON to check the production machine health check and worked with On Call DBA to manage the sessions.
17. Performed the Multi valued compression
18. Involved with team to finalize the production support manuals.
19. Involved in monitoring and controlling the sessions of different jobs running on NCR machine using the PMON
20. Creation and scheduling the Net Vault jobs and monitoring.
Environment: Windows, UNIX, Vi Editor , Erwin, Oracle 9i, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, SFTP, PMON, TD ADMINSTRATOR, Teradata manager, Backbone’s Net vault 7.0, ARC, DBSControl, DBQL, Teradata Analyst pack, QCD, Informatica power center 6.0, Informatica workflow manager and monitor
Abbott Laboratories, 100 Abbott Park Road, Abbott Park, Illinois Aug 2005 - Jun 2006
TERADATA SENIOR DEVELOPER
It is a global, broad-based health care company devoted to discovering new medicines, new technologies and new ways to manage health. Abbott products span the continuum of care, from nutritional products and laboratory diagnostics through medical devices and pharmaceutical therapies. Their comprehensive line of products encircles life itself - addressing important health needs from infancy to the golden years.
Abbott has sales, manufacturing, research and development, and distribution facilities around the world, close to where our customers need us to be. Abbott management need the best warehouse system need to hold the manufacturing and sales of manufacturing systems, to recognizing the threshold to generate the order for the manufacturing unit , to identify the trends of the medicines movement across the world every season. Daily reports need to show the previous day manufacturing order details and quantity, Sales cubes need to reflect the exact business with timely reporting. Apart from that serving the dependent systems by pushing the medicines base compositions to SQL server and Oracle applications to make xml compatible for the GUI applications.
Responsibilities:
• Understanding the BRD and Participation in Client meetings to understand the business needs for new developments/enhancements.
• Writing SRS, Design documentation.
• Requirements gathering
• Offered the services of DBA-4.
• Creating Teradata macros for the rollup process.
• Managed Back Up jobs.
• Created and managed the Users on non-production Environment.
• Managed the Space Allocation in non-production Environment.
• Worked with the System Health Check.
• Writing bulk load and fast export scripts to bring the data from several databases.
• Involved in making the CDC process using the Informatica mapping designer.
• Tuning the performance of the code
• Creating workflows in informatica to run the BTEQ scripts and bulk loads.
• Prepared of Test cases and Participated in the peer reviews
• Prepared Presentations and process document as per CMM Level 5
• Maintained the production objects.
• Provided excellent support to production and stabilizing.
Environment: WINDOWS, Red hat Linux, Teradata V2R5, Oracle 9i, DB2, ER-Win 3.5.2, NDM, SFTP, BTEQ, Query man, Multiload, fast export, Teradata Analyst pack : Teradata Visual Explain, Statistical wizard, Teradata Manager, Teradata Administrator, PMON, Informatica workflow manager, workflow monitor, mapping designer, OLE Loads
Witness Systems Inc, 3979 Freedom Cir # 500, Santa Clara, CA Nov 2004 - Jul 2005
TERATADA DEVELOPER
Client: DaimlerChrysler Customer Assistance Center
Quality-driven customer service is a core DaimlerChrysler value, and for our many European customers that begins with the quality of service provided by our Customer Assistance Center in Maastricht [the Netherlands]. Implementing a monitoring solution would help us increase the quality of our customer service and make it more transparent and consistent. After carefully assessing available solutions, they selected the Witness Systems approach based on its functionality, ease-of-use and Web-based architecture.
The main focus of this project is to hold the Customer service information gathered at various service layouts and shops to help the several dependent online and CRM applications. This project has shadow metric that is identification dots at their service centers from the survey info gathered from several trusted sources. Prepared best warehouse system and other designs to support the web reports as well as to serve the ad-hocs to take the flexible plans over the business. Client impressed with our focus on business drivers and its proven strength of the warehouse.
Responsibilities
• Writing SRS, Design documentation.
• Requirements gathering
• Creation of environment and maintenance in prod and non-prod box like creation of database, handling the new user request and their privileges using there Teradata Administrator.
• Creating Teradata macros and BTEQ scripts for the rollup process
• Writing bulkload and fast export scripts to bring the data from several databases.
• Involved in making the CDC process using the Informatica mapping designer.
• Tuning the performance of the code by justifying the performance with the teradata objects like SI, JI, HI, PPI etc.
• Creating workflows in informatica to run the BTEQ scripts and bulk loads.
• Prepared of Test cases and Participated in the peer reviews
• Prepared Presentations and process document as per CMM Level 5
• Maintained the production objects.
• Provided excellent support to production and stabilizing.
Environment: WINDOWS, Unix, Teradata V2R5, Oracle 9i, ER-Win 3.5.2, SFTP, BTEQ, Query man, Multiload, fast export, Teradata Analyst pack : Teradata Visual Explain, Statistical wizard, Teradata Manager, Teradata Administrator, PMON, Informatica workflow manager, workflow monitor, mapping designer.
WallGreens Retail Aug 2003 – Oct 2004
TERADATA DEVELOPER
This project is to provide the data for the mining, ad-hoc reporting and planned reporting structure. Technically the main aim of this project is making a solid base for customer sales and services information. Need to provide the data whatever the data miners needed to build the scores and profitability of the card members. The data we gather from multiple sources will be utilized to build the statistical model to plan for promotions and to attract the categories of the customers based on their lifestyle and social strength.
Responsibilities:
• Involved in Client meets and understanding BRD
• Performed source system study and Requirement gathering
• Creation of the mapping documents and reviews with the data architects
• Communicating with the Client for the shadow metrics implementations
• Preparation of testing and quality documents
• Designing the ETL model to gain the metrics
• Presentation and reviewing the models with in the team
• Making the Teradata objects, BTEQ scripts, Mload and fast export scripts
• To get the data from Oracle used Spool on/off script and
• To get the data from SQL server used the DTS tasks and scheduled the SQL packages.
• Tuning and optimization of Teradata Queries
• Using the Unix wrappers to make the workflows
• Performing the unit testing
• Involved in Peer views
• Preparation of testing cases Documents
• Supporting in bug fixing and helping the data validation team.
• Preparation of Production support document
• Maintaining the production script
• Providing and monitoring the stats after the drop to verify the stability of the job and data quality.
• Sending the stats report to the high level management using the pivot tables and xls graphs.
• Helping the Reporting team by providing the teradata queries
• Fulfilled ad-hoc requests coming from superiors.
• Worked as a good team player and took participation to improve the team spirit.
Environment: WINDOWS, Unix, Teradata V2R5, Oracle 9i, ER-Win 3.5.2, SFTP, BTEQ, Query man, Multi load, fast export, Teradata Analyst pack: Teradata Visual Explain, index wizard, Statistical wizard, Teradata Administrator, PMON, Unix wrapper
Forrester Research Inc, Cambridge, MA May 2001 – Mar 2003
INFORMATICA Developer
Responsibilities:
• Participated in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Managed the entire ETL process, involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources like individual details of the household.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle and mainframes into the Oracle target database.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Connection management and scheduling of jobs to be run in the batch process
Environment: Informatica Power Center 4, Oracle 9i/8i, SQL Server 2000/2005 UNIX Shell Scripting, UNIX, Autosys, Windows 2003.
|
|
|
|