SUMMARY:

• Over 7Years of IT experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica, Teradata and Oracle
• Dedicated and Focused team player with exceptional data warehouse experience
• Very good experience in Implementation of Data warehouses and Data Marts with Star and Snow flake Schemas.
• Proven track record in planning, building, and managing successful large - scale Data Warehouse and decision support systems Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling
• Expert in Teradata RDBMS, initial Teradata DBMS environment setup, development and production DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.
• Extensive experience in design and development of Data warehouses and Data Marts using as Informatics Power Center / Power Mart 9.5/8.5.x/7.1.x/6.1.x and associated tool to map, transform and extract data feeds from various source platforms and databases
• Expertise in Query Analyzing, performance tuning and testing.
• Experience in writing database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized views and Triggers
• Experience in writing UNIX shell scripts and Mainframe JCL to support and automate the ETL process
• Strong Hands on experience on Reporting tools like Microstrategy, SSRS, Crystal Reports, OBIEE and Tableau
• Implemented Dashboards, configured Repositories, Created drill down and drill across reports from humongous volumes of data as the data source.
• Created Tableau and MicrostrategyDahboardsand scheduled the reports to be delivered to the users
• Created Tableau Data visualizations using heatmaps, Bar charts, Geographic maps and Density Charts
• Worked on Ataccama for ABC checks
• Built Control M jobs for scheduling.
• Periodical Interaction with Client to resolve mapping issues
• Created test data to ensure successful data loading.
• Having strong Retail domain and Communication background experience
• Excellent communication and inter personnel skills, Proactive, Dedicated and Enjoy learning new Technologies and Tools.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process.

TECHNICAL SKILLS:

ETL Tools: Teradata Utilities (FastLoad, MultiLoad, Fast Export, BTEQ, TPump and SQL assistant), Informatica PowerCenter 10.x/9.x/8.x/7.x/6.x/5.x

Business Intelligence Tools: Microstrategy 9, OBIEE 11g/12c, SQL Server data tools 2015,Business Objects 6.5.1,6.5Crystal Reports, Tableau 8.0, Ataccama

Languages: SQL, PL/SQL, MySql, SQL*Plus, C, C++, UNIX Shell scripting,Mainframe JCL, Python

Databases: Oracle 8.i/9.i/10g, SQL Server, Teradata 15/14/13/12/V2R6/V2R5, DB2,MS Access 2000

Oracle Utilities/Tools: Toad, SQL* Loader, PL/SQL, Erwin

Cloud: AWS/S3, Amazon Redshift

Operating Systems: Windows 98/2000/NT/XP, UNIX, MS-Dos,Mainframes

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis, MO

Teradata Developer

Roles and Responsibilities:

• Analyze and plan any new request from client for enhancements and provide effort estimates needed for implementing the enhancements and bug fixes
• Develop Technical specification documents by analyzing the legacy systems
• Implement and support new and existing data, ETL, and reporting solutions implemented in Teradata and Micro strategy
• Create stored procedures, with required business logic to load the target tables and performing unit testing
• Perform code/Test case review and ensure coding standards are met and deploy the code in higher environments
• Wrote complex SQL queries for running few manual business reports which cannot be automated and delivering them on periodic basis
• Prepare the test plan and test strategy for system integrated testing
• Coordinate system Integration testing with respective teams
• Implementing update and delta strategies for SCD type tables
• Understand source data and the business systems that create and utilize the source data during business operations
• Collaborate with other Business Intelligence teams to design and develop solutions to business problems
• Produce ad-hoc reports to answer business questions quickly and thoroughly
• Created process flow and data flow diagrams using MS Visio representing how various upstream systems feeding into Teradata
• Designed GAP analysis documents for comparing New systems data model to existing physical model
• Develop technology documentation to support ongoing maintenance of reporting and data solutions
• Coordinate the Support groups of Confidential and notify them in case of any issues

Environment: Teradata 15, UNIX, UC4 Automation, GitHub, Informatica 10, Agent Ransack, SQL server 2016, Tableau 8

Confidential, Woonsocket, RI

Teradata Developer

Roles and Responsibilities:

• Analyze the Ab initio ETL Graphs and Develop requirements from EDW.
• Develop Technical specification documents, Unit Test Cases.
• Development of Informatica sessions with Pushdown Optimization in Informatica Power Center 9.1.
• Development of Informatica mappings Transformations and Mapplets using Source Qualifier, Filter, Lookup, Aggregator, Union, Router, Update Strategy etc.,
• Created Workflows to run these informatica mappings.
• Involved in Data profiling of Flat files in EDW and build physical model for Teradata using IDQ (Informatica Data Quality) tool.
• Identified the pain points within each and every system pertaining to the reports
• Spearheaded meetings with other source systems and Intermediate systems and worked on the process flows and exception analysis
• Open issue Analysis
• Performed the AS - IS analysis between Oracle and Teradata systems for the data flowing into the system
• Converted Oracle queries to Teradata queries and compared the outputs of both the queries for gap analysis
• Performed the technical comparison of the systems which included Size, availability of system, number of tables, ETL jobs, CDC, Error handling capability, Reporting layer, Report count, user count, Report SLA to name some.
• Compared the subject areas and attributes across different systems
• Provided Short Term and Long Term Recommendations.
• Started Learning Hadoop as part of Knowledge gaining Program to work on the new technologies.
• Worked on ALM testing tool to execute test cases and Defect fix.Participate in Daily Scrum call with all the stake holders.
• Support User Acceptance Testing and resolve the issues identified. Assist in debugging performance related challenges.

Environment: Teradata15 (Multi Load, Fast Export, BTEQ and Teradata SQL assistant), Informatica 9.5.1, Unix, MS Access, Oracle.

Confidential, Kansas City- KS.

Teradata and MicrostrategyDeveloper

Teradata/ETL Responsibilities:

• Analyzing the requirements and validating the ETL Mapping Specs.
• Prioritizing the data base objects like tables and views based on the project, data volume and load frequency.
• Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
• Developed mappings in Informatica Power Center Designer to load data from staging environment to disaster recovery warehouse.
• Created mappings using the transformations such as the Source qualifier, Look up, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Involved in Creating Sessions, Workflows Using Workflow Manager
• Scheduling the jobs through Control-M.
• Involved in UNIT testing, Defect Analysis and fixing.
• Worked on a new Internal ETL test automation tool for unit testing namely DVT (data validation Tool).
• Involved in preparation of High level and Low level design documents.
• Worked closely with the Onsite Business Analysts for requirement gathering and analysis.
• Developed complex mappings with different transformations and mapplets to load data into dimension and fact tables.
• Generated PL/SQL Scripts, procedures as a part of my development activities.
• Involved in Unit Testing and Code reviews of the components to ensure defect free code delivery. Generated PL/SQL Scripts, procedures as a part of development activities.
• Efficiently trouble shooting the ETL issues and gave optimized analysis of the issue for its quicker resolution.
• Prepared the Source to Target specifications.
• Used Execution Plan and Informatica Performance optimization techniques to improve the performance of the data loads.
• Hands on Deployment of Informatica code to system test, UAT and support for production.
• Hands on control-m for scheduling the Informatica jobs and running jobs
• Quick error handling in the code development.
• Assisted the end users in making them understand the technical/business logics during the UAT testing.

Environment: Teradata 14 (FastLoad, MultiLoad, Fast Export, BTEQ andTeradata SQL assistant), Unix, Microstrategy 9(Architect, Developer).

Confidential

Teradata Developer.

Roles and Responsibilities:

• Worked closely with clients for gathering the functional requirements and working with the project manager to give a high level design and the cost associated with the project.
• Wrote Bteq’s and JCLs to load data from flat files on Mainframe to Teradata Warehouse using BTEQ and MULTILOAD Utilities .
• Worked extensively with Flat Files and Fast Export utility.
• Created Parameterized Macros
• Worked with Visio to develop Flow Diagrams associated with the projects.
• Involved in Unit testing, smoke testing, system testing and integration testing and preparation of test cases.
• Worked in production teams to run jobs and troubleshoot production Issues/tickets.
• Designed and created various temporary and volatile tables as part of data transformation.
• Analyzed the sources system and documented the data quality issues.
• Did Performance tuning for TERADATA SQL statements
• Involved in migration of Jobs and associated Scripts to production and testing and setting up the respective environment
• Retrieved various Job outputs from $AVRS
• Involved in Code Reviews

Environment: Teradata 12 (FastLoad, MultiLoad, Fast Export, BTEQ and Queryman), Mainframes, DB2, Datacom, Erwin 4.0, VB and Windows 2000/NT.

Confidential

Teradata Consultant.

Roles and Responsibilities:

• Involved in the requirement analysis in support of Data Warehousing efforts.
• Extracted data from Oracle database transformed and loaded into Teradata target database according to the specifications
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created tables, views, procedures for the database using SQL and PL/SQL.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Worked extensively on complex mappings using different transformations like lookup, expression, filter, aggregators and others populate the Data Warehouse.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created sessions and workflows to run in parallel, sequentially and nested.
• Developed Teradata Fastload scripts for initial loads, Mload scripts for data loads and BTEQ scripts for developing post load processes.
• Developed Teradata SQL scripts to verify referential integrity and to provide custom SQL support to the end user
• Developed UNIX shell scripts to run batch jobs in production.
• Involved in Unit Testing and Preparing test cases.
• Involved in Peer Reviews.

Environment: Informatica 8.6(Designer, Workflow manager, Workflow monitor and Repository Manager), Teradata 12 (FastLoad, MultiLoad, Fast Export, BTEQ and Queryman), UNIX, Oracle 10g, Erwin 4.0, Microstrategy and Windows 2000/NT.