SUMMARY:

• Confidential is a BI Architect with around 10 Years of experience in IT services, specifically in Business intelligence, Data Warehousing and Data Engineering. He has worked on projects involving data warehousing platforms like Structured Querying, ETL, OLAP reporting, Big data etc.
• He also has experience in architecting and implementing BI solutions on AWS platform.
• Around 10 Years of total IT experience in all the phases of the Data warehouse life cycle involving Requirement Gathering, design, development, analysis, Documentation & testing of Data warehouses using ETL, Data Modeling, Online Analytical Processing, BI Reporting.
• He is an AWS Certified Solutions Architect and Developer (Associate). He is also certified Informatica Cloud Data integration and Informatica Powercenter 8.x Developer.
• Performed as an BI Architect, BI Project Manager, BI Project Lead, BI Developer in Analytical Reporting, ETL & Database technologies along with domains.
• Extensive Experience in Manufacturing, Supply Chain, Finance and Technology industries
• Extensive experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica PowerCenter 9.1/8.x/ 7.x as well as Informatica Cloud
• Hands - on experience in developing BI solutions on AWS platform (Redshift, RDS, Dynamodb, S3, EC2, EMR, Data Pileline)
• Familiar with Big data technologies - Hadoop, HDFS, Hive, Spark, Presto and in design and development of Map Reduce jobs.
• Hands-on experience in Installations, Configurations, Patching, Administration, Security setup, authentication setup, Deployments, Code Migration, Cluster setup, Migrations &Upgrades and architecture of Informatica Products 7.1/8.1/8.6/9.1
• Experience in working with all modules of Business Objects 5.1, XI R2, R3 like Central management console, Designer, Desktop Intelligence, Web Intelligence, Xcelsius, Rich Client, Import Wizard.
• Experience in Supporting Reporting solutions like Tableau, Microstrategy.
• Worked extensively worked on RDMS like Oracle 8i, 9i, 10g, 11g, SQL server 2005/2008, Sybase. And MPP: Amazon Redshift and NOSQL: DynamoDB
• Clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on System Development Life Cycle.
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized data models.
• Successful in recognizing problems, troubleshooting solutions and reaching project goals on time.
• He has worked in Agile scrum methodology
• In-depth knowledge on Dimensional Modeling - Star and Snow flake schemas, Entity-Relationship Modeling (1NF/2NF/3NF), Bill Inmon and Ralph Kimball concepts.

SKILL:

Business Intelligence: Informatica Powercenter/Exchange 7.1.3, 8.1.1, 9.1.0, Informatica Cloud, SSIS 7.0, Business Objects 5.1, XI R2, XI R3, Tableau 8, Koretech, Microstrategy

DBMS: Oracle-8i, 9i, 10g, 11g, PL/SQL, Microsoft SQL Server 2005, 2008, Sybase, RDS, AWS- DynamoDB, Redshift, S3, HIVESQL

Data Modeling: MS VISIO, Erwin, Embarcadero, Oracle designer

Others: Python, Shell Scripting, Appfluent, Oracle Enterprise Manager, SVN Version Control, CA scheduler, AWS EMR, Athena

OS/Environment: Solaris, Redhat Linux, Windows98/95/XP, Windows Server 2005/2008

Collaboration Tools: Remedy, Service desk, Support central, IBM Same time, MS Lync, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect/Project Manager

Platform: Unix, Windows

Technology/Software: AWS EMR, Informatica Cloud, Amazon Redshift, SSIS, Microsoft SQL Server 2008, Python, Airflow, DynamoDB, S3

Responsibilities:

• Create a low level specification for the technical architecture in the TO-BE environment.
• Categories dependencies and buckets for existing Datamarts and batch processes and create stories for sprints
• Technical Design of elements to be migrated in EMR/Python scripts/ Informatica cloud and Amazon S3/ Redshift/RDS according to existing specifications.
• Hands-on implementation of identified modules
• Continuously re-evaluate project status, identify issues and risks, and provide recommendations for process improvement, resolution of issues and escalate when necessary
• Develop modules in an Agile Methodology with 10 day sprints.
• Clean up and Optimize Batch process using best practices and capabilities of cloud computing.

Platform: Unix, Windows

Technology/Software: Informatica Powercenter 9.5.0, Sybase, Microsoft SQL Server 2008, CA Scheduler.

Confidential, New York, NY

BI Senior Consultant

Responsibilities:

• Oversee entire project life cycle from initial concept through production release and post close completion for IT initiatives
• Participate in scope and requirements meetings with business customers, and take the lead in defining and communicating final decisions to all parties
• Technical Design of MIS Datamarts in Informatica and DB (Sybase and SQL Server) according to client requirements.
• Co-ordination of Development and Review with Offshore team.
• Co-ordination with Release Management for Deployment of artifacts during various stages of the project (Development, SIT, UAT, Production)
• Continuously re-evaluate project status, identify issues and risks, and provide recommendations for process improvement, resolution of issues and escalate when necessary
• Provide project status to stakeholders

Platform: Unix, Windows

Technology/Software: Informatica Powercenter 8.1.1 9.1.0 , Business Objects XI R2, XI R3, SSIS 7.0, Oracle- 10g/11g, PL/SQL, Microsoft SQL Server 2008, Tableau 8, Appfluent, Oracle Enterprise Manager.

Confidential, Dallas, Tx

Onshore Project Lead

Responsibilities:

• Oversee entire project life cycle from initial concept through production release and post close completion for IT initiatives
• Participate in scope and requirements meetings with business customers, and take the lead in defining and communicating final decisions to all parties
• Create and manage project plans, identify necessary resources, and execute project management tasks throughout the life of a project
• Continuously re-evaluate project status, identify issues and risks, and provide recommendations for resolution and escalate when necessary
• Maintain steady communication with development and/or analytical staff, business customers and management on all projects
• Provide project status to stakeholders
• Requirement gathering and analysis and Impact Analysis for the Enhancements coming in for various Applications being supported.
• Design of the enhancement / new processes in Informatica/BOXI according to client requirements.
• Analysis for the requests raised by the Client regarding the existing applications.
• Analysis of Business Objects Reports for Query Optimization.
• Co-ordination of Development and Support Activities with Offshore team.
• Co-ordination of QA for Projects and RTS.

Application Onshore Administrator

Confidential

Responsibilities:

• Scheduled Maintenance of tools which include Patching and fix pack upgrades for both tools as and when required.
• Co-ordination and Support for all the server and database maintenance activities.
• Back-up for offshore Administrator in Release Activities.
• Co-ordination with offshore Administrator for new initiatives and Research activities on both tools.

Confidential

Platform: Unix, Windows

Technology/Software: Business Objects 5.1, XI R2, Informatica Powercenter 7.1.3, 8.1.1, Oracle-8i, 9i, 10g, PL/SQL

Offshore Programmer

Responsibilities:

• Develop or enhance the ETL mappings to extract data from the various Sources and load it into the Oracle databases or Flat files as required.
• Do the error validation of the data moving from various sources to targets.
• Test the mappings and check the quality of the deliverables.
• Add new fields as business requirement and issues in existing table structure of database and modify the BO universe accordingly.
• Test the universe for its integrity and check if BO reports are fetching correct data in such cases.

Production Support

Confidential

Responsibilities:

• Monitory/Running of daily/weekly/monthly loads.
• Abend fixing failed loads within specified time as per SLA and also finding out solutions for permanent closures for repetitive failures
• Maintenance activities like space cleanup, table space and partitions maintenance etc.
• Consolidate new findings and learnings from every resource in the team and discuss them in weekly knowledge sharing meeting.
• Document tacit knowledge among various resources.
• Create a master document repository which is useful for references and knowledge transfer.
• Upload project summary to Knowledge Centre once in every six month.