Candidate Information Name Available: Register for Free Title Project Management Business Intelligence Target Location US-DC-Washington Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Business Analyst Project Management Beltsville, MD Project Manager Business Development Rockville, MD Project Manager Business Development Owings Mills, MD Project Management Business School Hyattsville, MD Business Development Project Management Germantown, MD Project Manager Business Analyst Gaithersburg, MD Project Management Business Analyst Suitland, MD

Candidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLESUMMARY Sound ETL Informatica Developer with 4 years of experience in Project management, system development, Business Intelligence, Data Warehousing Implementation. Experienced in creating and interpreting Physical and Logical data models Proficient writing medium to complex SQL queries and strong with Relational Database design concepts. Experienced in performing System Reengineering/Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements. Solid experience with ETL process and Data Warehousing. Experienced in building Data Integration and Workflow solutions. Expertise in designing and developing complex mappings and transformations in Informatica Power Center 10.1.0. Experienced Implementing complex business rules in Informatica by creating re-usable transformations and Mapplets. Experienced at creating and modifying Informatica workflow and Worklets. Experienced in Data migration, Data extraction, Data cleansing, Data profiling and Data quality and Data Mining. Solid experience in troubleshooting, disaster recovery, backup and restore. Experienced in session scheduling in informatica. My personality traits are Commitment, Ownership, Adaptability, Analytical, Problem Solving Skills and Sincerity. Good communication and presentation skills, excellent team player and ability to work efficiently with both onsite and offsite.TECHNICAL SKILLSOperating Systems Windows, Windows server.MS office tools Microsoft Project, Microsoft SharePoint, Microsoft Excel, Microsoft Outlook. Database MS Access, Oracle Database, MS SQL Server. Analytics and Reporting tool Informatica, SSIS, SSAS, SSRS. Querying Tools Teradata SQL Assistant.EXPERIENCERTG Worldwide5114 West Maple shade lane,Jan 2020  Till DateETL Informatica developerThe project aims to develop a centralized Enterprise Data Warehouse which is to be integrated with existing legacy systems for data migration. The Enterprise Data Warehouse was to serve as a center point for all existing data sources, and also provide the feed for various reporting platforms. The project followed Agile/scrum methodology. Responsibilities Developed complex mappings using various transformations like aggregator, union, joiner, router, connected/unconnected lookups, stored procedure, expression, filter, sorter and update strategy Modified existing target definition and created target table accordingly. Used source analyzer to define and input source definition. Performed a complex mapping by taking SQL override code and translating it using Informatica utility tools. Performed extract, transform, and load (ETL) solutions for data warehousing using SQL server integration services. (SSIS) and Informatica Performed performance tuning by clearing cacheRTG Worldwide5114 West Maple shade lane,Jan 2020 Sept 2020Business AnalystThe project aims to develop a centralized Enterprise Data Warehouse which is to be integrated with existing legacy systems for data migration. The Enterprise Data Warehouse was to serve as a centre point for all existing data sources, and also provide the feed for various reporting platforms. Responsibilities Implemented automated backup and database maintenance / cleanup jobs. Managing Logins, Users, Roles and User permissions. Tracked change requests and monitored workload and schedule. Performed Data mapping, logical data modeling, created class diagrams Activity Diagrams. Frequently used SQL queries to filter data within the Oracle database and created data profiling document. Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion. Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members. Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project. Created the Data Mapping Document to specify the Data mapping from various data sources to the target database. Involved in creating, designing reports framework, dimensional data models for the data warehouse Created Indexes to get the high-level performance. Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules. Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions. Recommended process or system changes intended to eliminate identified risks or gaps. Responsible for all technical SQL Server database operations, Administration, ongoing development for various in- house databases. Assisted with user testing of systems (User Acceptance Testing), developing, maintaining quality procedures, ensuring that appropriate documentation is in place. Involved in reviewing the use cases and sign off from a testing standpoint. Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.Environment: Informatica, MS Project, MS Office Suite (Excel, Word, PowerPoint, Outlook), Oracle SQL Developer. EDUCATIONLagos State University,Bsc Physics (Meteorological and Atmospherical)