SUMMARY:

• Confidential has 9+ years of IT experience in Architecture, Design, Development and Implementation of Business Intelligence and Analytics solution on Niche Data Analytics and Visualization/Reporting tools.
• Exceptional background in analysis, design, development, customization, implementation and post implementation using various business intelligence strategies.
• Worked extensively as ETL developer/architect using Informatica, RDMS Teradata, SQL Server, Google Big query, AWS Athena, Dataflux and Unix.
• Confidential Confidential is also a Tableau expert who has developed numerous intuitive dashboards for complex data analysis and understanding to help himself and other managers to gather insightful observations from raw data.
• Confidential Confidential has Firm initiative experience wif Big Data in Data ingestion, querying, Data transformation technologies and python.
• He has experience and good understanding through various phases of a project life cycle, starting from Requirement Gathering & Analysis, Design, Development, Testing, Implementation, Documentation, Production Support and maintenance, involving client specific tools and technologies.
• Analyze and monitor application and system logs using homegrown and commercial profiling tools (AppDynamics, Splunk)
• Worked wif business customers in understanding teh requirements for preparation of High - Level Design documents, Low level Design documents and Impact analysis documents.
• Experience in technical analysis, solution identification, design, development & implementation, production support and documentations throughout each stage of Project Life Cycle.
• Has helped wif project management artifacts like SoWs and project estimation and timeline tools.
• Has been part of pre-sales work for RFP by designing & developing dashboards which was presented during orals.

PROFESSIONAL EXPERIENCE:

Confidential

ETL and Tableau Developer and Lead

Key Responsibilities:

• Leading a team of 5 ETL developers, through various phase of SDLC, involving specific client processes, tools & technologies.
• As an ETL developer Confidential Confidential is involved in various phases of a Project life cycle, developing ETL jobs using Informatica powercenter tools and various Database technologies (Teradata, Sql Server etc.), through teh Client specific Release process, and maintaining Data warehouse for business intelligence reporting.
• Responsible to gather requirements from Directors and Managers to show different data insights for teh client using Tableau on weekly and monthly meetings.
• Involved in Data analysis, Data maintenance, Design, Development, enhancements, bug fixes and Production support activities.
• Managed Dataflux, SAS and SSIS applications to ensure teh availability of reports and application to vendors and client.
• Implemented migration of Big query to AWS Athena.
• Responsible for Requirements Gathering and its implementation feasibility.
• Worked directly wif IT business analysts throughout teh development cycle and provided production support for ETL.
• Worked in 24*7 Managed Services Model and provided resolution to teh critical P1/P2/P3 issues.
• Documenting through each phases of SDLC process.
• Knowledge sharing accross team on project activities and technologies involved in.
• Communicating and co-ordinating wif client IT and Business team, and other cross functional teams such as Admins, other support teams etc.
• SQL query creation and performance tuning for various user requirements on top of Data Warehouse.

Environment: Informatica Powercenter 10.1.1, Teradata SQL and BTEQ, Tableau, SQL Server, Unix, Control M scheduler

Confidential

ETL and Tableau Developer and Lead

Key Responsibilities:

• Leading a team of 3 Big data and Tableau developers, through various phase of SDLC, involving specific client processes, tools & technologies.
• Worked on Tableau wif Extract and Live data sources from big data hive and designing dashboards to forecast capacity planning.
• Migration of Tableau dashboards from Sql Server to Hive.
• Loading teh data using hive and using python to write algorithms to predict forecast.
• Enhacing teh existing code to facilitate new features.

Environment: Big data, Postgres, Hive, Tableau, Python.

Confidential

ETL Developer

Key Responsibilities:

• Confidential Confidential has Involved in gathering business requirements, Design etl, coding, unit testing, review and Support in Production when it went live.
• Worked wif Client Business analyst team to understand teh DATA flow, and logic to be built to move teh DATA from one application system database to other, both Oracle.
• He has developed BTEQ scripts and Unix shell scripts.
• Created new logic to append data from Source application to target existing Database objects as a one-time activity.
• Developed Datastage jobs to do ETL transformations wif teh requirement provided and load respective Dimension and Fact tables.
• Impact analysis as target system Database already having data from other application existing.
• Responsible for teh overall delivery of teh work product as per teh schedule and as per teh defined quality processes.

TECHNICAL SKILLS:

Databases: Oracle - Expert, Teradata - Expert, MS SQL Server - Expert

Hardware / Operating Systems: Windows (7, 8, 10), Unix, Proficiency - Project Experience

Middleware / Databases: Oracle 10g, MSSQL, MySQL Proficiency — Project Experience

General Tools: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, proficiency — Project Experience