SUMMARY:

AARATI NARAHARI

609-***-****

adqpaj@r.postjobfree.com

Motivated Informatica certified, Scrum certified developer with over 12 years of work experience in the IT Industry in analysis, design, development and maintenance of various software applications in client-server environment. Experience in providing Business Intelligence solutions in Data warehousing and Decision Support Systems using Informatica Cloud and Power Center. Experience in Software Analysis, Testing, Design, Development and Production Support in Data Warehousing using Snowflake,Oracle, SQL Server and Teradata.

●Experience in developing strategies for Extraction, Transformation and Loading (ETL)

mechanisms using Informatica.

●Experience in generating various dashboards for performance.

●Experience in Database design and development using Oracle, SQL Server to include Database Architecture, Logical & Physical Design, Backup, Restore, and Data Integration.

●Experience in PL/SQL Programming.

●Experience in UNIX shell scripting and automation of sessions.

●Experience in automation using Autosys and Tidal.

●Certified Scrum Master.

●Excellent problem solving skills with a strong technical background and good interpersonal skills.

●Managed GitHub repositories and permissions, including branching and tagging.

●Version control systems: Git,Subversion and Informatica versioning.

SKILLS:

ETL Tools: Informatica Cloud (Power Center 7.x/8.6.1/9.5.1/10.1.1/10.2) Databases: Snowflake,Oracle 8i/9i/11g/12c, SQL Server, Teradata V2R6 Languages: C,SQL, PL/SQL, Shell Scripting

Tools: Toad, Autosys, SVN, GIT, and Tidal

Operating Systems: UNIX, Linux

CERTIFICATIONS:

●Informatica Certified Designer (Architecture and Administration, Mapping Design, Advanced Mapping Design).

●Scrum Certified Master.

EDUCATION:

Bachelors of Engineering, Osmania University, Hyderabad, India.

PROFESSIONAL EXPERIENCE:

Girl Scouts of the USA,New York. Oct’ 19 – Till Date Sr ETL Developer

Girl Scouts is the preeminent leadership development organization for girls. As a part of the Engineering team, the data from different sources like Salesforce,Opsuite,Netsuite, Google Analytics and Litmos APIs needs to be extracted, transformed and loaded into the warehouse .The warehouse resides in Snowflake. The extracted data is then presented to the business users through Looker as explores .

Accomplishments and responsibilities:

●Captured the existing functionality as requirements from SSIS to Informatica.

●Worked on the design and coding of the mappings and mapplets as per the requirements.

●Elimination of any redundancy of data storage was implemented, to enhance performance of the existing code.

●Used the Cloud based version of Informatica to amp up the loading times of the data into Snowflake.

●Resolved any issues the business users have in Looker, to trace back to source systems as needed .

●Worked on writing Design documents to implement the needs of business as a technical document.

●Used transformations and mapplets to implement business requirements efficiently .

●Interacted with Informatica to work on different issues with the tool.

●Managed Informatica permissions and privileges as an admin.

●Used GIT for versioning. Worked on code push, pull and merges .

Environment: Informatica Cloud/IICS, Snowflake, Looker,Salesforce,Google Analytics

Albridge Solutions,

Bank of New York Mellon. Oct’ 08 – Aug ‘19 Lead Developer/Production Support Specialist

/Data Research Analyst

Albridge is a data management and financial technology solutions company for several financial services companies. Worked as a Data Research Analyst to analyze issues raised by clients as well as proactively worked on identifying and fixing existing data anomalies. As a developer and production support specialist, I supported many applications, including

front-end reports, replication feeds and Data warehouse loading from an ODS (Operational Data Store) and extraction processes to feed downstream systems.

Accomplishments and responsibilities:

●Worked with Business to understand the requirements and worked on the data model accordingly. Also wrote the technical requirements for several

implementations and enhancements.

●Analyzed and supported several version upgrades for Informatica, 7.x/8.6.1/9.5.1/10.1.1/10.2 HF1.

●Worked on design and architecture of Disaster Recovery implementation. ● Performance enhancements were done in database level as well as mapping level by tuning mappings and sessions for all the processes.

●Guided team with code consolidation, deployment and troubleshooting of production issues.

●Designed a technical reconciliation key to trace back the source record in all the target systems.

●Mappings were created using transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.

●Analyzed and supported Oracle upgrade from 11g to 12c.

●Wrote several PL/SQL procedures, functions and packages to implement design.

●Supported SVN to GIT conversion for all the code-base.

●Provided production support for several applications and worked on identifying the root cause.

●Managed GitHub repositories and permissions, including branching and tagging.

●Worked on enhancements of several reports to monitor performance.

●Designed the batch control and error capture data models.

●Prepared structured data flow diagrams and simulated source files for the development purpose.

●Worked on shell scripts to support execution of Informatica workflows and processes.

●Participated in peer reviews for approving the functional requirements.

●Conducted design reviews for all the code.

●Collaborated with business analysts to support their data warehousing needs.

●Worked as a production support analyst to analyze and resolve the root cause of an issue.

●Ability to collaborate and work with several teams like business analysts, DBAs and System Administrators to meet timely objectives.

●Worked with SFTP servers.

Environment: Informatica 10.2 HF1, Oracle 9/10/11g/12c, Linux, Tidal, SVN, GIT

Lehman Brothers, Jersey City, NJ. Sep’ 07 – Sep ’ 08 Senior ETL Analyst/Developer

The objective for the DC project is to acquire the account activity data that is valued and classified by strategy, account configuration data which define the scope of activity to be processed and referential data that are required for activity enrichment from various WMR and Non-WMR sources and transform it to the format required for the Performance Reporting (PR) and Client Review (CR) components.

Accomplishments and responsibilities:

●Designed and developed ETL technical requirements for activity adapters (trades, journals, holdings, and transactions), FX rates and accrual services from functional requirements.

●Developed mappings, workflows to extract data from various sources like DB2, MF flat files to reporting data store to analyze the data as part of Input analysis. ● Worked on Input analysis to determine the quality of source systems and SLA requirements.

●Analyzed the source data coming from Reuters, Lipper, Morningstar and ADP. ● Worked on Alternative Investments (Private Equity and Hedge Funds) technical requirements.

●Worked on UNIX scripts for request and response mechanisms from various source systems ESM (Enterprise Security Master), TMS (Transaction Management System), ADP, RDS (Reporting Data Store) and Lipper.

●Developed ETL support documents and scheduled workflows in Autosys. ● Used Business Objects (XI, 6x and backwards), with experience in Supervisor, Designer, Reporter, BCA Server (Publisher and Scheduler), Web Intelligence

2.5/2.6.1/6.0, Info view, Application Foundation and Schema Design.

●Worked in the designing and building of the Business Objects Universes, Classes and objects for the business requirements.

●Developed mappings using web services and xml components.

●Worked on product master data as part of reference data management to have one version of truth across all applications enterprise wide as product is sourced from many internal and external source systems and products are referred to in each source system differently as is in sedol and cusip.

Environment: Informatica Power Center 7.1/8.1, DB2 UDB,SQL, Business Objects XI/6.5,

Windows NT/2000, and Sun Solaris 5.8, PVCS, DBArtisan, UNIX-AIX 4.3, Autosys

UBS December 2006-August 2007 ETL/Oracle Developer

UBS is the world’s leading investment banking and securities businesses, serving a wide range of clients including Corporate, government’s hedge funds, financial sponsors, private equity firms, banks, brokers and asset managers worldwide. The main objective of this project is to populate EUE.EUE is an Operational Data store that Calculates entitlements for SOX relevant applications from user entitlement data. These data feeds come from different legacy systems, relational databases and also in different nonstandard formats. This data is then cleansed and transformed as per the business rules and populated into the data warehouse (GERS). GERS is a shared data warehouse that integrates data from various global authorization systems in UBS to provide entitlement information for reporting purposes.

Accomplishments and responsibilities:

●Cleansed, transformed and loaded data into ODS.

●Created several triggers and packages to load into subsequent systems. ● Used Business Objects to create universes with objects and classes. ● Built reports to project data from different perspectives using slicing and dicing and drill down methodologies.

●Expertise in SQL.Tuned queries for performance.

Environment: Informatica Power Center 7.1, Power Exchange Navigator, Oracle 10g/9i,PL/SQL Developer 5.1.4, Shell Scripting, Business Objects 6.5, UNIX-AIX 4.3

Contact this candidate