PROFILE SUMMARY:

• Result - focused 8 years of BI implementation experience across varied business models and departments using industry standard modeling, ETL and analytics toolset
• Experienced Teradata engineer with knowledge and hands-on implementation of BTEQ, Fast Load, Multi Load, Performance Tuning, Performance monitoring via Teradata logs and viewpoint.
• Developed IBM Datastage jobs to read data from databases(Oracle, DB2,Teradata,MarkLogic,SnowFlake), file system and REST APIs and load into database or file system.
• Extensively used Transformer, Lookup, Join, Pivot, Change Data Capture, Teradata Connector, ODBC Connector, Hierarchical Data, Unstructured Data stages.
• Designed and developed IBM Quality stage jobs involving multiple passes to map a parent entity to its child entity.
• Improved the performance of Teradata load processes to handle large data volumes by modifying the primary index, stats, table structure.
• Developed Alteryx workflows to blend data from multiple sources and trained business users on Alteryx which can be used as a self-service ETL tool .
• Developed Tableau data visualizations with Live connections and Data extracts using action filters, parameters and sets with the help of Tableau Desktop. Published Tableau workbooks to the server with hyperlinks.
• Designed and developed SAP Business Objects universe consisting of numerous classes and objects while avoiding loops and traps. Created canned reports and objects to facilitate ad-hoc reporting.
• Developed and supported Ad-hoc and Canned SAP BO Web Intelligence reports crafted for various business units.
• Developed Python script to call REST API and load data into Teradata database using Teradata packages.
• Trained, mentored and motivated a lot of junior programmers and constantly updated myself on newer technologies and trends in data warehouse.
• Worked on global network delivery model-based projects (onsite-offshore model), dealt with users across functional areas(departments) and managers from multiple vendors.
• Quick Learner, highly motivated, result oriented, responsible and an enthusiastic team player.

TECHNICAL EXPERTISE:

Languages: SQL, Shell Scripting, Python, SnowSQL

ETL Tools: IBM Datastage (V7.5,V 8.5,V9.1), Informatica, IBM Information AnalyzerIBM QualityStage, Alteryx, Ab initio

Reporting Tools: SAP Business Objects (XIR2, BI4.0), Tableau

Databases: Teradata (V6.5, V13, V15), Oracle, SQL Server, DB2, MarkLogic

Data Modeling Tool: Erwin

Testing Tools: HP ALM(Quality Center), Selenium, TCS Intelligent Testing System(ITS)

Operating Systems: UNIX, LINUX, Windows 7/8/10

Version Control: SVN, Git, GitHub

Other Tools: Microsoft Office, WinSCP, Jenkins, Jira, Service-Now

PROFESSIONAL EXPERIENCE:

Confidential

Technical Architect

Responsibilities:

• Collaborated with business users for Requirement Analysis.
• Followed AGILE SCRUM for design, development, and testing phases of application.
• Created Data Model using Erwin Data Modeler adhering to Teradata M&E model
• Developed the ETL process using IBM Infosphere Datastage to read the data from MarkLogic database by using REST API and load into Teradata.
• Parse the JSON response from MarkLogic using Hierarchical Data stage’s assembly editor
• Develop and document loading error capturing systems and methods to resolve these errors. These include data errors, duplicate errors, delimiter errors, update anomalies in the source systems, incompatible data structures etc.
• Deployed on UAT and Production environment using Jenkins build.
• Maintained source code version control in Git-Hub for check-in and check-out of the source code.
• Worked with JIRA issue tracker, to update issues with solutions and status.

Confidential, Culver City

Technical Architect

Responsibilities:

• Collaborated with business users for Requirement Analysis.
• Worked with various application teams to identify the necessary data sources.
• Followed AGILE SCRUM for design, development, and testing phases of application.
• Designed the ETL strategy for robust and performance oriented database and application layer.
• Created Data Model using Erwin Data Modeler adhering to Teradata M&E model
• Developed the ETL process using IBM Infosphere Datastage to load data from Oracle and SQL server databases into Teradata.
• Created various dashboards using Tableau Desktop for user reporting.
• Deployed on UAT and Production environment using Jenkins build.
• Maintained source code version control in SVN repository and Tortoise SVN for check-in and check-out the source code.
• Worked with JIRA issue tracker, to update issues with solutions and status.
• Developed complex algorithms and SQL coding for various processes like Executive Dashboard, Merge process of duplicate party ids, cleansing and de duping of customer addresses etc.

Confidential, Culver City

Architect

Responsibilities:

• Functional requirement review and analysis
• Estimate the requirement and Design a solution based on the functional specifications
• Create a Conceptual, Logical and Physical Data Model adhering to Teradata M&E model
• Review of Code, Design and Deployment
• Monitor the progress of requirements and share the updates with client and BRM teams
• Coordinate with onsite team and monitor offshore operations
• Release management, Support management and Process improvement
• Organize and Conduct UAT sessions
• Maintain technical standards checklist
• Inherit agile principles into the existing operations
• Develop and enhance Tableau dashboards
• Create Alteryx workflows for seamless data load

Confidential

ETL Lead

Responsibilities:

• Estimate the requirement and Design a solution based on the functional specifications
• Code, Design and Deploy ETL and reporting solutions
• Monitor the progress of requirements and share the updates with client and BRM teams
• Planned and implemented the database migration from Teradata V12 to Teradata V13
• Assign the requirements to development team
• Created various Dashboards for Senior executives like CFO and Vice Presidents
• Organize and conduct UAT sessions
• Release management, Support management and Process improvement

Confidential

Computer Systems Engineer

Responsibilities:

• Design and Enhance IBM Datastage jobs/Sequencers.
• Develop UNIX scripts for scheduling Datastage jobs/Sequencers.
• Creating new BO Web Intelligence Report or enhancement request for existing canned reports
• Making BO Universe changes and enhancements
• Fixing bugs and defects in reports
• Production deployment and Support.
• Handling, Monitoring Teradata Database as well as Datastage jobs.
• Interacting with clients for system related issues.
• Resolution of issues based on the Service Now incidents.
• Coordinating with Onsite team.