SUMMARY:

• 6 Years 7 Months of I.T. Analyst experience at Confidential as ETL and Reporting Lead Developer.
• Hands on experience with Business Intelligence and Data warehousing.
• Hands on experience in ETL tool - Informatica 9.1.0 and Talend 5.6, 6.0, 6.1,6.2.1,6.4.1.
• Hands on experience in Reporting tool - SAP Business Objects 4.0, OBIEE 11.1.1.6.12 , TIBCO Spotfire 5.0, Tableau 8.0.
• Working on Big Data Hadoop Development - Apache Spark(Scala), Oozie, Scoop, Hive.

PROFESSIONAL EXPERIENCE:

Confidential (New Jersey)

Talend Lead Developer

Responsibilities:

• Sqoop Import/Export Ingestion Framework Implementation.
• Hive Export Ingestion Framework Implementation.
• SAS Data Ingestion Framework Implementation.
• JSON Ingestion Framework Implementation.
• Stream Ingestion (File Based) Framework Implementation.
• Talend Run Book Ingestion Framework Implementation.
• Ingestion Report Generation Job for capturing statistics like Output Record Count, Output Volume, No. of Datasets, Source Type and Ingestion Type, etc.
• Worked in Talend Administration Centre (TAC) for scheduling the Jobs using Job Conductor, Execution Plan and Triggers.
• Worked with Databases mainly with Hadoop, Teradata and Oracle as the Source and Target Database.
• Working on HDFS and Hive Metadata for Big Data Hadoop.
• Hands on experience in Talend Studio 5.6, 6.0, 6.1, 6.2.1 and 6.3.1 Enterprise Installation involving directly with Talend Product Team.
• Confidential ’ mature Transition processes, (DD3) and tools, continuous playback, orientation of the team, Staggered waves based transition approach will ensure Risk minimized effective transition.
• Confidential will bring in digitized knowledge acquisition, knowledge management tools along with a flexible operating model to mitigate any risk during transition.
• Platform (support tools, infrastructure, resources) readiness for steady state operations; early start during due diligence to assess fitment and integration needs of the platform.
• Measure, monitor and manage transition effectiveness and risks to ensure No Business Interruptions.
• Confidential will Optimize processes to drive efficiency, Digitize key areas (workflow, reporting, knowledge mgmt., talent management), integrate set of tools (ticketing, CMDB, KM).
• Improve stability - effective root cause, Predictive controls for effective preventive maintenance. Confidential proposes to bring 9% YOY benefit to GM through process optimization, system simplification and innovation. This additionally will improve our service levels.
• Transformation initiatives targeted towards simplification and automation; through small group activities to identify opportunities to improve the services, processes and systems.
• Focus on simplification through transformation initiatives will simplify the systems resulting in cost efficiency.
• Optimizing our resource mix by cross-; multi-skilling teams across technologies.

Confidential (Bentonville, Arkansas)

BI Consultant and Talend Lead Developer

Responsibilities:

• Gather Business Critical Rules, Business Disruptive Rules and Data Validation Rules from the Pricing Team of Confidential Stores Inc.
• Implemented 100+ Business Critical Rules on Talend ETL Tool in order to produce the exceptions to integrate with Tableau and OBIEE Dashboard Visualization.
• Implement Business Disruptive Rules by establishing the data pattern using Standard Deviation distribution.
• Worked in Talend Administration Centre (TAC) for scheduling the Jobs using Job Conductor, Execution Plan and Triggers.
• Worked with Databases mainly with Hadoop, Greenplum, Teradata and Oracle as the Source and Target Database.
• Implemented 100+ Data Quality Rules on Hadoop.
• Implemented Kerberos Security Setup using Keytab file to authenticate Hadoop (Hive) through Talend.
• Creation of HDFS and Hive Metadata for Big Data Hadoop.
• Hands on experience in Talend Studio 5.6, 6.0 and 6.1 Enterprise Installation involving directly with Talend Product Team.
• Project the Price Gap in Confidential products compared to competitors.
• Providing a platform for the Pricing team to decide on the critical discounts or Rollback’s on Products in order to gain profit and edge the market with respect to other global competitors.

Confidential (Schenectady, New York)

Onsite Coordinator and Lead BI Developer

Responsibilities:

• Assess information needs of Business and Functional owners
• Requirement Gathering and GAP Fit Analysis with Confidential Functional and Confidential Business teams
• Ensure implementation of IT projects for Enterprise BI centre
• Project execution & monitoring across all BI Analytics Projects as identified from time to time
• Participation in Requirements review, assisting project teams to prepare project plans and monitoring the execution, perform control & reporting activities
• Monitor Projects and ensure quality solutions implementations with no schedule and cost slippage
• Initiate project kick-offs, stakeholders review meeting setup for regular status reviews, conflicts resolution, coordination with interface/support teams for planning, risk mitigation, setup Design/Arch review, work with project teams on UAT, Deployment and Infant care planning
• Understanding and documenting process improvement initiatives
• Review and verification of project deliverables at defined time period
• Regular reporting to Confidential leadership and respective project stakeholders
• Analyze enhancement requirements
• Enhancement task execution and monitoring, Enhancement migration and deployment
• Address customer queries and clarifications, Review existing IT systems and solutions, Review deliverables and standards
• Following the Confidential Six sigma standards

Confidential (Schenectady, New York)

Developer

Responsibilities:

• Understanding of the Business requirement logic through functional spec where the customer will publish through JIRA (Internal task management tool).
• Directly coordinating with Client to gather the new requirements and working with existing issues.
• Development of the New reports in BO Webi Environment using the BOXI 4.1 version.
• Regression testing of applications while the database changes happens.
• Created Business and Technical Specification Document.
• Involved in leading a new project from analysis, design, implementation of Universe and reports.
• Have Worked on ITSM tool and provided Production support to the user and helped Resolution of customer issues by coordinating between various teams involved in the project.
• I have also worked as tester in the team, involved in writing unit test cases and execution of test cases.
• I have tested inconsistence and redundancy of the data in Life &Health.
• Tools - JIRA, E-cab, DocSpace, Version Manager, Central Management Console, Oracle SQL Developer.

Confidential

Trainee

Responsibilities:

• Logic building coding in Java, CSS, HTML and MySQL, PLSQL.
• Learning on Communicational skills & Business etiquettes.
• Learning on Six Sigma concepts.
• Learning of Business.
• Learning on Team skills.
• Trained on ETL tool Informatica as well as SAP Business Objects.
• Worked in a team of size four, efficiently proved my potential developing the design of ETL and Reporting.
• I was also involved in writing unit test cases and execution of test cases.