OBJECTIVE:

Technical Lead /Manager position with a company that offers an opportunity to utilize my experience in DW & BI ETL Tool Informatica, SQL Servers, Sybase, and Oracle & Netezza. Highly motivated, creative and versatile individual with 8 years of experiences in the IT industry as a Technical Lead, Senior Developer as well as Data Analyst. Recently I got an opportunity to work in cloud - based tools like Snap logic and Snowflake. I am involving more into design for migration from Informatica to Snap logic.

SUMMARY:

• In addition to Informatica, hands on experience in streaming platform Snap logic and Could base Snowflake, AWS S3 projects .
• Skilled in design, development and implementation of Data Warehouses. Experience in Lead developer activity.
• Proven success in designing and implementing solutions for Data Centre Management with SQL Server, Sybase and Oracle.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Capable of independent work with minimal supervision and also capable of presenting Status updates to Management teams. Comfortable in interacting with people across hierarchical levels for smooth project execution.
• Handling the design, development, testing and deployment of custom data warehouse systems. Defining data requirements and designing databases to satisfy client business objectives.
• Extensively used ETL methodology for supporting Data Extraction, Transformation and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Oracle.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy.
• Participating in design reviews and assisting with allocation of functionality to specific system components. Developing, implementing databases, and writing stored procedures.
• Analyzing content and quality of databases, recommending data management procedures, and developing extraction/ ETL processes.
• Handling all customer concerns and escalations in a timely manner.
• Proactively worked with other teams, such as Oracle DBA team, UNIX team & Network teams, to maintain the different environment or help resolving issues.
• Transfer knowledge of applications/environments to production support teams.
• Created documents where necessary.
• Followed all the steps for ITIL Problem Management (Problem Detection, Problem Logging, Categorization, Prioritization, Investigation and Diagnosis, Solution, Closure)

TECHNICAL SKILLS:

Primary Skill Category: ETL Data Warehousing, Informatica (Power center 8.6/9.5), SQL Server 2008 R2, SYBASE 15.7 & Oracle 10g, UNIX (Crontab)

Acquired Skills: HiPort, Cute FTP & WinSCP

IT Service Management Tools: HP Service Manager

Financial Domain Expertise: Investment Asset Management

Portfolio& Charles River trading System: Media and Entertainment

WORK EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

• Proactively interacted with BA’s and kept track of each phase like UAT, staging and verifying technical aspects.
• Effectively followed all the necessary processes & made sure that the user acceptance testing is performed and supported even after the release.
• Monitoring progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters. Delivering services /solutions within constraints (schedule, features / functionality) & ensuring quality execution in the delivery of a product/service/solution to drive satisfaction
• Consistently and tirelessly ensuring our systems, especially at night - all run smoothly, and minimizing the impact to the business. Done by reacting quickly and effectively to incidents occurring through the night, liaising with all parties involved quickly and professionally, and showing maximum effort to ensure no impact to the business & provide permanent solution for the incident. Handling all customer concerns and escalations in a timely manner. Maintaining strong relations with the client for securing repeat/ referral business.

Confidential

Technical Lead

Database: ORACLE 11g, Snowflake, Netezza 7.0

Tools: Informatica 9.5/10.1, Snap logic, TOAD, Agility, WinSCP, Putty

Responsibilities:

• I was part of requirement gathering from the product owner and come up with impact analysis of the process and logic to be implemented, Design, Work allocation, Implementation, providing technical guidance to the peers, Testing and Deployment.
• Worked in multiple projects like Consumer Data, Public Metadata and Authorization projects using Informatica 9.5/10.1
• In Confidential project, we are receiving the data by using HTTP transformation from the REST and Dynamic API. Performing encryption for extra security before passing the content along with key to head of the operator. Based on the key they will complete authentication and decrypt the content.
• In Confidential, we receive data as JSON message using IDQ data parser to split and load data into staging and then backfill to main target tables. Following Exception and log table to record the process.
• In Confidential, Pulling the data from different source like Facebook, Google & Amazon (AWS) and loading the data into staging and performing the logic to get the subscribers and mostly viewed product, series and bundles. Excluding the person who received the promo offers but not utilized, sending the new offers to different subscribers.
• Worked in Agile methodology, every day Scrum meeting will be happening for requirement gatherings and changes as well. In short span of time, accomplished big tasks.
• Fully parameterized including database connections, variables and parameters etc.
• Have created labels and queries and taken care of deployments in lower environments.
• Used JIRA, HEAT for project effort logging and ticket creation respectively.

Confidential

Senior ETL Developer

Database: ORACLE 11g, Sybase 15.7

Tools: Informatica 9.5, TOAD, WinSCP, Putty

Responsibilities:

• Created complex workflows like CVaR & CAPRI process using Informatica 9.5.
• Currently working on Advanced Commercial Banking System (ACBS) which pulls Loan related data from iDesk and load into ACBS Data Mart.
• Initially worked on JPMC (J.P Morgan Chase), AML (Anti Money Laundering), and DMS (Directorship Management System) feeds.
• Proficiently cleaned, transformed, validated or modeled data with purpose of understanding or making conclusions for decision making purposes.
• Created various Transformations like Joiner, Aggregator, Expression, Filter, Lookup and Router.
• Once development activities get completed then code will be reviewed by peers/QA. code gets migrated to higher environments on the satisfactory confirmation of the peers/QA
• Have created labels and queries and taken care of deployments in lower environments.
• Successfully coordinated between clients & teams for timely delivery of solutions.

Confidential

ETL Developer & Data Analyst

Database: Sybase 15.7, SQL Server 2008 R2

Tools: Informatica 9.5, Tidal (TES), Crontab (UNIX), Cute FTP

Responsibilities:

• Effectively designed complex maps like Charles River & EAGLE process using Informatica 9.5.
• Proficiently cleaned, transformed, validated or modeled data with purpose of understanding or making conclusions for decision making purposes.
• Created various Transformations like Joiner, Aggregator, Expression, Filter, Lookup and Router.
• Used Mapplet and Reusable Transformations to prevent the redundancy of transformation usage and maintainability.
• Perfectly set up new fund in Investment Data base and maintained investment data so that End user could have correct information and could take an appropriate decision.
• Successfully coordinated between clients & teams for timely delivery of solutions

Confidential

ETL Developer as well as Data Analyst

Database: SYBASE 15.5, Oracle 10g

Tools: Informatica 8.6, Crontab (UNIX), Cute FTP

Responsibilities:

• Effectively designed complex maps like Confidential using Informatica 8.6.
• Effectively resolved issues caused by various reasons and applied ETL, Database fix when required in order to stop it from occurring in future.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Created an ITIL based release management process guide for monthly IT Maintenance releases for Ops.
• Involved in enhancements and maintenance activities of the data warehouse. Adeptly kept track of entire upstream data provider like holding, Index Value, Security information and trading information.