SUMMARY:

• Overall 19 years of IT experience in Analysis, Design, Development, and support of Data Warehouse BI, RDBMS, and Big Data projects.
• Certified AWS Cloud Solution Architect - Associate.
• Certified PMP from Project Management Institute (PMI). Good experience in Agile.
• Rich experience in Oracle database with SQL and PL/SQL. Written complex procedures, functions and triggers. Also written SQL* Loader scripts to pump the data from various DBMS to oracle.
• Experience in Dimensional Modeling, Data and ETL Architect and designing of RDBMS. Experience in Netezza, Informatica, Business Objects, Microstratgey with adaptability to work in any ETL or BI tool.
• Good Understanding and knowledge of Big Data Hadoop HDFS, Map Reduce, with experience in PIG, HIVE and SQOOP.
• Experience in Data science and Machine learning for implementation of Linear and Logistic Regression using Octave and Python.
• Expertise in putting up comprehensive strategy and planning of small, medium and large scale projects.

TECHNICAL PROFICIENCIES:

Operating Systems: UNIX, LINUX, Windows

Languages: SQL, PL/SQL, Pro *C, C, C++, Java, HTML, JavaScript, Python, R, Octave

Database/RDBMS: ORACLE, Netezza, Teradata

Reporting Tools: Developer 2000 (6i), Oracle Forms and Reports, Crystal Reports, Tableau

ETL & OLAP Tools: Business Objects, Informatica, Data Stage, BODI, OBIEE, Microstrategy

Big Data: Hadoop HDFS, Map Reduce, PIG, SQOOP, HIVE, Scala, Spark

Concepts & Methodologies: Big Data, Cloud, Relational Database, Data Warehouse, Data Migration, Data Mining, Business Intelligence, Data StructuresObject Oriented Modeling & Designing, Big Data concepts and analytics.

Data Science & ML: Data Science and Machine Learning knowledge and expert understanding. Experience in implementing linear regression and logistic regression using Octave, Python.

Software Life Cycle Models: Waterfall & AGILE

WORK EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

• Responsible for part of program management from delivery standpoint which includes project initiation, project planning and validation strategy, project effort and cost estimation, Staffing, project closure and support.
• Provided technical help and guidance.
• Preparation of project schedules, monitoring and tracking of various activities.
• Responsible for Tracking of program on budget and resourcing for existing project and new projects
• Interaction with Business to understand the requirements and flows of various systems.

Environment: Hadoop, HDFS, ETL, Oracle

Confidential

Responsibilities:

• Responsible for overall program execution which includes end to end execution of various projects, including project initiation, project planning and strategy, project effort and cost estimation, Staffing, project closure and support
• Managed and involved in various program including MDM, Data Warehouse enhancements, BI Reports, Predictive Modeling
• Provided technical help and guidance.
• Responsible for budget and resource tracking for all projects under the program.
• Interaction with Business to understand the requirements and flows of various systems.

Environment: Oracle, DB2, Netezza, Informatica, BO

Confidential

Responsibilities:

• Lead the team of Test Data Management to define and implement the process for fulfilling test data requirements of IT projects. Analyzed and understood the overall IT infrastructure and database landscape and designed Informatica ETL jobs, and written complex SQL, PL/SQL codes to fulfill the data needs for testing various applications.
• Taken the transition from existing teams in terms of the data needs in order to record the existing process of data generation, data subsetting, data masking etc.
• Prepared strategy for the fulfillment of data needs and implemented in various lines of businesses.
• Participated in tools comparison and POC.
• Build the team and implemented Confidential best practices.
• Supported the various lines of businesses for their data refresh needs.

Environment: Oracle, DB2, Netezza, Informatica, BO

Confidential

Responsibilities:

• Responsible for end to end execution of various projects in Health and wellness portfolio, including project initiation, project planning and strategy, project effort and cost estimation, Staffing, project closure and support.
• Managed and involved in various projects but specifically contributed to Data Strategy project for Big data implementation.
• Defined the scope of project based on business and technical needs for various data streams which were loading into HDFS and then to the analytical layer.
• Participated in business discussions to prioritize their needs in terms of analytical reports and then designing the base accordingly.
• Estimated the overall effort and then have monitored and tracked the activities closely.

Environment: Hadoop, Hive, Map Reduce, PIG, Oracle, DB2, Teradata, Data stage, BO

Confidential

Responsibilities:

• Project Management activities including estimation, tracking, monitoring and participating in the discussions with the Business.
• Requirement specification, analysis, Coordination with Business and other teams Involved in risk projection and mitigation planning.

Environment: Oracle,Unix, OBIEE, BODI

Confidential

Responsibilities:

• Project Management activities including estimation, tracking, monitoring and participating in the discussions with the Business.
• Requirement specification, analysis, Coordination with Business and other teams Involved in risk projection and mitigation planning

Environment: SQL Server, Dot net

Confidential

Responsibilities:

• Confidential intends to re-platform the Confidential application which is faced with serious issues like out of support and non-standard hardware and software components, frequent failures and near saturation of infrastructure capacity.
• The new development will extend the capability of the previous CDW environment and will be catering to provide the same scope of business requirements.
• The Confidential provides critical information support for various business areas like Broker, Finance, Sales, Operations and Underwriting.
• Project Management activities including estimation, tracking, monitoring and participating in the discussions with the Business.
• Requirement specification, analysis, Coordination with Business and other teams Involved in risk projection and mitigation planning

Environment: Oracle SQL, PL/SQL, Informatica