SUMMARY:

• Having 7+ years of IT experience in the field of Data Warehousing, BI Architecting, Design and development for various Data warehousing projectsusing Teradata and Oracle.
• Extensive working knowledge of Teradata and its utilities like TPT, Multi - Load, fast load and BTEQ.
• Implementation, review specification, testing and maintenance of applications and extensive Experience in Teradata 12/13 & 14 for developing ETL and ETL architectures.
• Developed technical design documents and mapping specifications to develop Teradata loading scripts.
• Experience with SQL, PL/SQL in creating Views, Functions, Triggers and Stored Procedures in Data Warehouse environments that employ Relational databases like Oracle, SQL Server, and Teradata.
• Well Versed with Data warehousing Architecture on the Design, Development and Extraction, Transformation and Loading of Data using ETL tools.
• Extensive experience in designing and creating data marts using ETL tools Informatica Power Center Informatica 8.6.1, 9.0 and 9.1.
• Identified, designed, coded, debuged tasks necessary to develop Data Warehouse/Mart and ETL BI solutions.
• Have knowledge in Informatica Data Quality (IDQ), Power Center, Data Cleansing, Data profiling, Data quality measurement and Data validation processing.
• Extensively worked on Informatica Workflow Manager to create Sessions, Batches and schedule Workflows and Worklets.
• Worked on optimizing the query performance, session performance and fine-tuning the mappings for optimum performance and involving in source level, target level and map level bottlenecks
• Experience in developing complex Mappings, Mapplets, Worklets, re-usable Tasks and re-usable mappings.
• Experience in integration of various data sources with Relational Databases like Oracle,SQL Server, XML Files and Worked on integrating data from flat files like fixed width and delimited.
• Extensive Experience in loading the data from Flat file,XML, Oracle as the Teradata Target .
• Proficient in Data Modeling using Erwin tool for creating physical and logical data models. Managed ODBC connections.
• Experience in working with UNIX environment.
• Expertise in writing/debugging/enhancing UNIX Shell Scripts.
• Proficient in using Agile Scrum methodologies performed roles of Scrum Team Member following sprint/standup sessions and analyzed the Iteration Burn Down charts.
• Proficient with Tools/Utilities such as TOAD, Microsoft SQL Server, Oracle PL/SQL server.
• Excellent understanding of Software Development Life Cycle (SDLC) requirement analysis, design document.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in aproject environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

Databases: Teradata,Oracle, MS SQL Server 2008

Tools and Utilities: Teradata SQL Assistant, Teradata Viewpoint, Teradata Performance Manager, Teradata Administrator, Putty, Toad,Informatica

DB Tools: SQL Plus, TOAD, Oracle SQL *Plus

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, Erwin.

Operating Systems: Windows, Unix, Linux.

Languages: SQL, PL/SQL, XML, Unix Shell Scripting

Visualization Tools: Tableau Desktop, Tableau Server, Tableau Reader

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr.Teradata Developer/ Informatica Developer

Responsibilities: 

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand requirements.
• Converted business requirements into technical documents - BRD, explained business requirementsregarding technology to the developers.
• Gather information from different data warehouse systems and loaded into warehouse using Fast Load, Fast Export, Multi-Load, BTEQ, Teradata parallel transporter (TPT) and UNIX shell scripts.
• Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server, IBM DB2 using Teradata utilities BTEQ, MLOAD, FLOAD and PUMP to load staging area
• Developed Test plans to verify the logic of every phase. The test plans included counts counts.
• Automated and ran the process of archiving the history data (Source data) from AIX servers to Eco system.
• Involved in setting up the LDAP authentication to the users.
• Created security domains with different roles for the development teams, test teams and operate teams.
• Automated the password reset process for the Application accounts (Database and Informatica Native accounts) by creating a shell script.
• Involved in powercenter 9.1 to 9.6 version upgrade. Created repositories in 9.6 informatica, copied the user groups from 9.1 to 9.6 and restored the 9.1 version of repositories in 9.6.
• Engaged Informatica support for critical issues/bugs in the powercenter.
• Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
• Involved in automating Repository backup process which runs daily.
• Responsible for maintaining repository backups and their restorations.
• Responsible for deployments from Development repository to the QA and Prod repositories and also worked on automating deployment process.
• Administered the repository manager for managing user privileges. Generating the Ad-hoc reports based on the business user requests.
• Support Production job failures and resolve the issue in timely manner. Troubleshoot the Productions failure and provide root cause analysis.
• Worked on emergency code fixes to Production.
• Developed database triggers and SQL queries needed inside the ETL Informatica.
• Involved in testing by using Informatica workflow manager and monitor, etc. and extensive testing on log files to detect errors.
• verification, look up hits, thebusiness logic of each element of data attributes and target

Environment: Teradata13/14, Erwin 8, TOAD, Linux, Shell Scripting, Putty, Informatica Power Center 9.6, Informatica power exchange, IDQ

Confidential, Richardson, TX

Teradata ETL Developer

Responsibilities: 

• Worked closely with Business Analyst and the end users in writing the functional specifications based on the business requirement needs.
• Involved in Dimensional Modeling (Star Schema) of the Data warehouse
• Involved in massive data cleansing before data staging.
• Analyzing the requirement document and prepare a design document for Teradata components
• Change data capture of Suppliers and millions of accounts every business day.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables and XML targets.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica Server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data Warehouse before and after the sessions.
• Tuning the complex mappings based on source target and mapping, session level.
• Involved in performance and tuning the ETL processes.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Developed UNIX Shell Scripts for scheduling the sessions in Teradata.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate the data in thewarehouse. 

Environment:  Oracle10g, SQL, Teradata12/13, UNIX, Erwin, TOAD, Windows

Confidential, Rowe Price, MD

Teradata ETL Developer/ Tableau Developer

Responsibilities:

• Worked on loading data from several sources to Staging using Teradata MLOAD, FLOAD, and BTEQ.
• Worked on exporting data to flat files using Teradata FAST EXPORT.
• Build tables, views, UPI, NUPI, USI, and NUSI.
• Query optimization explains plans, collect statistics, Primary, and Secondary Indexes.
• Worked exclusively with Teradata SQL Assistant to interface with Teradata.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Environment: Teradata V2R6.2, MS SQL SERVER 2005, MLOAD, FLOAD, Fast Export, BTEQ, Query man, Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel Windows

Confidential

Oracle Developer

Responsibilities:

• Managing databases, tables, indexes, views, stored procedures.
• Enforcing business rules with triggers and user defined functions, troubleshooting, and replication.
• Writing the Stored Procedures, checking the code for efficiency.
• Maintenance and Correction of Transact Sequel Server ( Confidential -SQL) Statements.
• Daily Monitoring of the Database Performance and network issues.
• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, thecreation of groups, granting the privileges to users and groups. SQL Authentication
• Rebuilding indexes on various tables.

Environment: Oracle9i,Windows,Toad