Application Support

Fahad A. Mohammed Edwardsville, IL 62025 fahdsunnevasets@gmail.com EXPERIECE SUMMARY •Around four years of dedicated experience in the field of IT with strong background in Data Warehousing and Database analysis and development. •Extensively used various ETL processes like Data Transformation, Data Cleansing, Mapping Development, Testing and Implementation. •Involved in Database design/entity relationship design. •Worked with complex mappings using different transformations like Filter, Expression, Router, Update Strategy, Unconnected / Connected Lookup, Aggregator Transformations. •Good conceptual and practical knowledge of various relational databases like Oracle, SQL Server, Microsoft Access. •Developed stored procedures, triggers, functions •Experience with TOAD utility, SQL Developer for Oracle database development. •Extensive experience in Reporting Tools like Cognos. •Highly motivated and quick learner. EDUCATION Master of Science in CMIS, GPA: 3.5 Bachelor of Technology in Computer Science, GPA: 3.5 CERTIFICATIONS Microsoft Certified Professional (MCP) NT Certified Database (SQL) Programmer VIT Certified Trainee in SAP Basis TECHNICAL SKILLS Software: Oracle Developer/Designer, SAP 4.6c & ECC 6.0,Mercury Quality Center, Rational Rose, Microsoft Visio, Microsoft Access, Microsoft Excel, Informatica Powercenter 7.1/8.1.1, SQL Server Management Studio, Microsoft Project, Cognos 8 BI 8.1/8.3 Software Languages: SQL, PL/SQL, C, C++ Platforms: Windows 98 / Me / NT / 2000 / XP / 2003, UNIX, Linux PROFESSIONAL EXPERIENCE Informatica/Cognos Developer/Analyst Jaros Technologies, Granite City, IL Dec 08 – Current Responsibilities: • Involved in Data Warehouse design and user requirement sessions. • Analyzed the gaps (GAP Analysis) requested by the users and fixed them on DW side. • Developed new mappings and maintained existing Informatica mappings and workflows based on specifications/user requirements. • Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor. • Developed transformation logic and designed various Mappings and Mapplets using Designer. • Worked on various transformations like Lookup, Aggregator, Expression, Joiner, Router, Filter, Update Strategy and connected and unconnected lookup transformations. • Used test cases, test scenarios and documented actual results and compared them to expected results. • Created and implemented SQL scripts and Anonymous PL/SQL scripts. • Used workflow monitor to monitor the jobs/batches and analyze the errors. • Worked on implementing ETL strategies like Incremental Loading and other performance tuning for various mappings. • Created and maintained several custom reports (GL, AP, AR, and Accounting/Financial Reports) for the client using Cognos 8.3. • Created List Reports and Cross Tab Reports and Drill Through reports. • Created standard and Ad hoc reports using Cognos 8.3. Environment: Informatica Power Center 7.1/8.1.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 10g/9i, Windows Server 2003, Oracle 10g/9i, UNIX, Toad ,Cognos 8.1/8.3 ETL Developer US Steel, Granite City, IL May 08 – Dec 08 Responsibilities: • Developed procedures, functions and triggers using Oracle PL/SQL. • Designed and developed all the tables, views for the system in Oracle. • Worked with analysts, users, and other IT technical professionals to understand requirements • Created tables with indexes, sequences, constraints. • Created test plans, test scripts for each procedure. • Tracked various defects and worked to resolve the production defects. • Verified the source data and executed various SQL’s to verify data. • Involved in Unit Testing / System Integration Testing. Assisted QA Team members to create test scenarios. • Used Cognos for data validation and documented actual results and compared them with expected results. • Developed some unique reports for the users to validate the data. Environment: Oracle 9i/10g, SQL, PL/SQL, UNIX, Cognos 8.3 Graduate Assistant To Associate Dean of School of Business, SIUe, IL Jan 08- April 08 Database (SQL) Programmer /Analyst St.Clair County Housing Authority, Belleville, IL, Jan 2007- Dec 2007 Responsibilities: •Created new databases in Access considering the DBMS constructs •Designed queries, reports on demand and according to the requirement, using SQL •Maintained four separate databases on demand and according to the requirements Environment: Microsoft Access, SQL, Microsoft Excel, Some custom applications, Windows 2000 Database/Java Developer Galaxy Software Solutions (GSS), India, Feb2006 – April 2006, Responsibilities: •Designed the databases of the organization as per the DBMS constructs •Designed tables and reports according to the requirements of the project •Developed and used java applications to create the front end Enterprise applications Environment: Oracle 9i/10g, SQL, PL/SQL, UNIX, Cognos 8.3 PROJECTS DURING MY MASTERS at SIUe. SAP Configuration: •Constructed a functioning company (Pen Inc.) operating in SAP R/3 environment. •Implemented and configured this in SAP R/3 & ECC 6.0. SAP Basis Training Project [SAP 4.6c & ECC 6]: •SAP R/3 4.6c administration •Scheduling and monitoring background jobs, CCMS monitoring, User administration, Role administration and authorization profile management, Transport administration, System copy, Spool administration Database Application Development: •Designed and implemented a small database application for a small scale business with all integrity constraints in place. •Implemented the project in four phases: conceptual design, logical design, physical design, and implementation of updates and queries. Database Administration Project: •Created Oracle database (manual) from scratch in Oracle 10g on Linux platform. •Created and managed data dictionary, table spaces, data files, system files, storage structures, user profiles, roles, privileges. •Implemented backup and recovery using logical backup i.e. oracle data dump export and import utility. ACTIVITIES •Member of SIUE chapter: Association of Information Technology Professionals (AITP)

Application Support

Edwardsville, IL