LiveCareer-Resume

application development senior analyst resume example with 6+ years of experience

Jessica
Claire
resumesample@example.com
(555) 432-1000,
, San Francisco, CA 94105
:
Professional Summary
Highly motivated Sales Associate with extensive customer service and sales experience. Outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market.
Skills
  • Unix
  • Windows
  • Software/Applications: MS 2000,
  • MS Word,MS Excel, MS
  • Access,Outlook,PowerPoint.
  • Database: SQL Server,Oracle 11g
  • ETL: Informatica PowerCenter 9.6,
  • Informatica PowerExchange 9.6
  • Language: SQL,Shell Script
  • Tools: Informatica 9.6,Oracle SQL
  • Developer, Microsoft SQL Server,
  • Sqoop,Hive,Toad
  • Banking, Oracle
  • Credit, Developer
  • Clients, Oracle SQL
  • Client, Problem solving
  • Data Warehouse, QA
  • Database, Requirement
  • Delivery, Router
  • Dimensions, Scheduling
  • ETL, Securities
  • Fast, Shell Script
  • Financial, Specification
  • Front office, Microsoft SQL Server
  • Government, SQL
  • Informatica 9.6, SQL Server
  • Informatica, Stories
  • Insurance, Strategy
  • Notes, Tables
  • Managing, Toad
  • MS, Trouble shooting
  • Access, Type 2
  • MS Excel, Unix
  • Office, UNIX shell scripts
  • Outlook, View
  • PowerPoint
  • Windows
  • 2000
  • MS Word
  • Operating Systems
Education
Sant Gadge Baba Amrawati University Shegaon, Expected in 04/2012 Bachelor of Engineering Technology : Information Technology - GPA :
Maharashtra State Board, Akola , Expected in 02/2008 Higher Secondary Certificate | Science : - GPA :
Maharashtra State Board , Expected in 03/2006 Secondary School Certificate : - GPA :
Work History
Cvs Health - APPLICATION DEVELOPMENT SENIOR ANALYST
York, PA, 01/2019 - 11/2019
  • Project Name:Portfolio Management (ETL-Developer) Client Name:Bank of Ireland Project Description: BOI is a global firm providing financial services to private, corporate and institutional clients.
  • This project deals with the customer details management department of Bank of Ireland.
  • The main purpose of this project is to create and customize their tools and services for bank that will complement their expertise and enhance client digital experience.
  • Creating mappings using different transformations and loading the target tables.
  • Create the sql queries and map view.
  • Coordinating with the onshore team to manage application and to address issues changes on a daily basis.
  • Creating control m jobs for scheduling.
  • Handle team and create task and stories for the team members.
  • Keep track of user stories and responsibility for code delivery.
Carlyle Group Inc. - ASSOCIATE
Washington, DC, 12/2015 - 01/2019
  • Project Name :SigFig (ETL -Developer) Client Name:UBS Project Description:UBS is a global firm providing financial services to private, corporate and institutional clients.
  • This project deals with the wealth management department of Union Bank of Switzerland, USA.
  • The main purpose of this project is to create and customize their tools and services for advisors that will complement their expertise and enhance client digital experience.
  • Creating mappings using different transformations and loading the stage tables.
  • Generate the files and Sftp to Sigfig drop box.
  • Perform health check on the files and send reports to end users.
  • Perform reconciliation for position and balances files generated within UBS and files send by Sigfig.
  • Coordinating with the onshore team to manage application and to address issues changes on a daily basis.
  • Creating Autosys jobs for scheduling.
  • Monitoring and managing QA defects in ALM.
  • Creating SCR and deployment notes to migrate the code to higher environments.
  • Project Name: Global Securities Infrastructure (Data Provisioning ) Client Name:Credit -Suisse Project Description:Data Provisioning is a project which manages the flow of data internal and external to GSI.
  • There are various consumers for which we prepare extract in order to fulfill their requirements.
  • Reconciliations are carried out between the Front office and Back office trades.
  • Due to day-to-day business transactional process and in order to maintain consistency extracts are generated with help of ETL tool.
  • Huge Data stores along with its huge set of connections in different environment are involved to generate feed for different business consumers.
  • Responsibility:.
  • Understanding the business model and customer requirement.
  • Involved in developing ETL strategy to populate the Data Warehouse from various source systems (Flat Files, Oracle) feeds using Informatica Power center.
  • Creating reusable transformations and used transformations like Source qualifier, Aggregators, lookups, Filters, Router, SQL, and Joiner.
  • Also created Concurrent workflows.
  • Code review and Unit testing.
  • Involved in trouble shooting and performance tuning.
  • Performed unit testing and bug fixing.
  • Preparing Technical Specification, Unit Test Case Documents.
Apex Systems - SYSTEM ENGINEER
Fort Meade, MD, 12/2012 - 11/2015
  • Project Name: Capital Stream Client Name: PNC Project Description: PNC Financial group is one of the largest diversified financial services organizations.
  • PNC has wide range of services for their customers for individual, small business to corporations and government entities.
  • PNC project involves building a Data Warehouse application using the tool Informatica and Oracle.
  • The aim of this project is to calculate the rating of the customers.
  • On the basis of the rating PNC can decide the relation with the customer for various types of loan and credit.
  • They want to create the data ware house to analysis their business.
  • Responsibility:.
  • Created Informatica mappings to load the data warehouse.
  • Implemented SCD- type 2.The mappings involved extensive use of transformations like Filter, Router, Expression, Sequence generator, lookup and joiner.
  • Use lookup transformation to get the date from flat file.
  • Used joiner transformation to join the stage and historical table.
  • Used MD5 to comparing stage and historical data for maintaining the history.
  • Used Harvest tool for check in the code for QA environment.
  • Conducting Unit Testing.
Additional Information
  • Senior Informatica Developer with 6+ years of extensive hands on experience on ETL Informatica. Excellent problem solving, fast Learning, presentation and analytical skill with the ability to work in both independent and team environments. Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center. Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow. Experience in integration of various data sources like Oracle, flat files into staging area. Implemented various Data Transformations using Slowly Changing Dimensions. Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks. Strong business understanding of verticals like Banking, investment and Insurance.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Sant Gadge Baba Amrawati University
  • Maharashtra State Board, Akola
  • Maharashtra State Board

Job Titles Held:

  • APPLICATION DEVELOPMENT SENIOR ANALYST
  • ASSOCIATE
  • SYSTEM ENGINEER

Degrees

  • Bachelor of Engineering Technology
  • Higher Secondary Certificate | Science
  • Secondary School Certificate

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: