SUMMARY:

• Overall 13 years of IT experience in Architecture Designing and IT development. BI Architect with over 6+ years of leadership experience in designing innovative business solutions. Skilled in designing Data warehouse/ Datalake, cloud computing, information management, application development, and visualization.
• Demonstrated mastery in evaluating requirements for business application integration and service activation.
• Proven mentor and training with expertise in communicating across organizational levels and with cross - functional teams to drive shared vision and foster culture of excellence.
• Predominant experience in designing and developing datalake and datawarehouse. Designing ETL and BI solution using BIG DATA technologies. Very strong in HADOOP, HDFS, HIVE and PySpark.
• ETL Design and hands on experience on Talend 6.1/6.2, Informatica 9.6 and Python based ETL.
• 1+ years of experience working with Qliksense scripting and Visualization. Good Knowledge of Tableau architecture.
• Very strong in database programing Oracle, SQL and PL/SQL.
• Experience in AWS Cloud technologies like Redshift, EMR, EC2, lambda, Athena.
• Expertise in Analysis and Design, Data modeling, Database design.
• Actively involved in project management, Project Delivery, documentation as per standard process followed by the organization.
• Responsibilities include client interaction, requirement gathering, design, and development, planning & tracking for a small team.
• Excellent team player with recognized analytical, strategic planning and interpersonal skills. Highly motivated, enthusiastic and self-starter.

TECHNICAL SKILLS:

Solution architecture

ETL architecture

ETL - Talend

ETL - Infomatica

AWS Redshift

Oracle

Python

HIVE, Hadoop, Spark

Agile - Project planning and co-ordination

Project Management

Talend Studio 6.2 and 6.1

Informatica 9.6

Erwin Data Modeler, Microsoft Visio

Tableau 10

Qlik View Qlik Sense Desktop

Waterfall/Iterative Lifecycle

Test Driven Development

Sql workbench/TOAD/Putty

Redshift, Oracle 10g

PROFESSINAL EXPERIENCE:

Confidential, NJ

ETL Architect

Responsibilities:

• Analyze and define client’s business strategy and determine system architecture requirements to achieve business goals.
• Gather detailed business requirements and use cases, and translate technical specifications into development requirements.
• Create team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.
• Develop data architecture design to facilitate targeted customer analysis.
• Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize ETL, database, reporting development.
• Database designing and Data modeling, Building ETL Framework.
• Pharma SME (Subject matter expert), Business communication and Data Quality Framework.
• KPI identification, Designing BI semantic layer and visualization

Technologies Involved - Hadoop, HIVE, Spark, Talend, S3, EMR, Amazon Redshift, Qliksense.

Confidential, NJ

ETL Architect

Responsibilities:

• Collaborated with business analysts, developers, and technical support teams to define project requirements and specifications.
• Led team to plan, design, and implement application.
• Designed, developed, and managed Python scripts, databases, visualizations.
• Pharma SME (Subject matter expert), Business communication and Data Quality Framework.
• Designing innovative UI and onboarding new data sources.

Technologies Involved: Informatica 9.6.1,Oracle,Python, R, S3, EC2, Amazon Redshift, Tableau.

Confidential, NJ

ETL Architect

Responsibilities:

• Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
• Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews
• Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
• Led team to plan, design, and implement application.

Technologies Involved: Informatica 8.6, Oracle, Tableau.

Confidential, NJ

Data Architect

Responsibilities:

• Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
• Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
• Led team to plan, design, and implement application.
• Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews

Technologies Involved: Informatica 8.6, Unix,Oracle 10G,VBA.

Confidential

Data warehousing Consultant

Responsibilities:

• Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
• Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
• Led team to plan, design, and implement application.
• Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews

Technologies Involved: Datastage, DB2, Oracle 10g.

Confidential

Oracle Programmer

Responsibilities:

• Oracle PL/SQL Programming. Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions.
• Implemented application developments, resolved performance issues, and provided end - user training on hardware and software.
• Led team to plan, design, and implement application.
• Worked closely with Quality Assurance team, Business Analysts, and User Representatives and participated in the product design process including specification and other document reviews

Technologies Involved: Datastage, DB2, Oracle 10g.