SUMMARY

• Over 15 year experience as Systems Analyst / Application Developer / Database Developer / Data Modeler / Data Analyst / Data Governance / ETL, Quality Assurance, Testing and BI Consultant in client - server and mainframe applications with an excellent delivery record of projects & system support
• Application Development experience with full understanding of SDLC including Data Architect - logical / physical data modeling, development of strategy, gather functional and business requirements, analysis, coding and developing, maintenance and enhancements
• Experience in Oracle application and database design, development, configuration, implementation and testing, creating and optimizing all database objects included materialized views, stored packages / procedure and functions, database triggers, synonyms, sequence, object type, user profile and roles
• Over 5+ years of work experience in Business Analysis and Data Analysis in Financial industry. Specialized in Implementation of Financial Tools, Data Governance, Data Lineage, Data Quality, Project Financials, Budgets, Forecasts, Costs, Benefits, Requirements management, user acceptance testing, Change Management, Reporting and SQL
• 5+ years working with Oracle BI, SQL including intermediate to advanced knowledge on DML / DDL
• Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules
• Experience with data management technologies and tools such as ( MDM, Informatica, Collibra)
• Experience in Oracle ERP R12 Implementation (AP, AR, GL, CM) and Seibel Case Management
• Experience in Oracle SCM (Procurement, Inventory, Order Management, Business Intelligence)
• Experience in SAP HCM Implementation (OM,PY,PA,EN,TM)
• Experience in Oracle XML Publisher, Oracle OBIEE 11g, OBIEE RPD modeling, OBIEE front end, security and leverage advanced DB functions, Oracle Application Framework,
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, IDEF1X methodology
• Extensive knowledge and experience of Extraction, Transformation and Loading (ETL) environments database development methodologies, programming languages, developed highly complex SQL scripts, supported analysis and transformation of data, database extraction and data cleansing
• Wrote programs, debugged and executed unit testing, system testing, integration and regression testing
• Knowledge and understanding of web services (SOAP, XML, WSDL, SQL) and experience designing interfaces between application systems, Oracle API’s and Concurrent programs
• Experience and Expertise includes Business Requirement Gathering, Requirement Mapping, GAP analysis, Functional architecture, Solution Design, Unit Testing, UAT and User Training
• Strong analytical, problem-solving, time management and communication skills, Organized, self-motivated, detail-oriented and a good team player and Continuously learning and updating my skills to keep up with changing IT technology

TECHNICAL SKILLS

• Windows NT/2000/XP/VISTA/7, VAX4200, VAX/VMS, UNIX, Linux, Apache, HSF,
• T-SQL, PL/SQL, VB6, ASP.Net, VB.Net, C#, COBOL, WBF, WCF, XML, XSL, HTML
• Novell, NFS, Ethernet, Cisco CCNA, Windows 2003/2008 Server, VPN, LAN, SOAP
• Oracle EBS R12, Oracle/PLSQL, Oracle/DBA, MS Windows, MS Office, Crystal Reports, MS Visio, MS Visual Studio, SSIS, SSRS, MS Project 2007, UML, HP QC, Oracle BI Publisher, Seibel Case Management, Oracle XML Publisher, Seibel Tools, IBM Clearcase, Java Scripts, SSH, FTP, CASE Tools, SAP BI, OBIEE g11/12C, MsSQL, NoSQL, XML, Erwin, Toad, Jira, DB2, OAF

PROFESSIONAL EXPERIENCE

Sr. Data Engineer / BI /DW

Confidential

Responsibilities:

• Interact with users to gather business requirements for BI projects and enhancements
• Design data architecture for BI projects and enhancements
• Create EDW business data models and business rules for all EDW environments
• Create data definitions, models and access views
• Create BO Universe Structures
• Definition of data synchronization and acquisition rules
• Definition of data quality and validation rules
• Define Extract/Transform/Load (ETL) processes
• Ensure data access optimization
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment
• Developed working documents to support findings and assign specific tasks and Data Profiling
• Supply high level and detail estimates for enhancements/projects
• Provide data modeling services to BI Development & Support Team
• Work on Business Objects Universe Design & Report Construction
• Work on Data dimensional and relational modeling techniques and tools (Erwin)
• Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories
• Analyze the Data Lineage from source systems including DB2, Oracle, SAP systems and legacy applications to Data Warehouse
• Working with the enterprise data governance team to incorporate business unit inventories as part of the enterprise data catalog and Business Information Model

Senior Data Analyst and ETL / BI / DW

Confidential

Responsibilities:

• Worked with customers and Stakeholders in gathering business requirements for data migration needs
• Worked across multiple functional projects to understand data usage and implications for data migration
• Worked on SQL*Loader to load data from flat files obtained from various facilities, Created and modified several UNIX shell Scripts according to the changing need of the project and client requirements
• Developed PL/SQL triggers and master tables for automatic creation of primary keys, created stored procedures, functions and pancakes for moving the data from staging area to data mart.
• Involved in the continuous enhancement and fixing of production problems. Generated server PL/SQL scripts for data manipulation and validations and materialized views for remote instances
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPALIN PLAN, SQL&TRACE, TKPROF and AUTOTRACE
• Assisted in designing, planning and managing the data migration process, manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Work with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements
• Understand the data structures and tables inherent in the new PSP system and be able to map legacy data to the new structure using mapping tools, Excel and intermediate databases
• Ensuring that ETL processes run as scheduled and performance tuning ETL jobs as required
• Developed and Optimized Stored Procedures and Functions to perform Work with technical & business staff to develop field level data mappings to aid in data migration and to build interfaces
• Creating & maintaining data dictionaries for different areas of data
• Demonstrated a strong grasp of database architecture including SQL server and database access tools
• Created and maintain Data Model in repository for Dev environment, create migration and data mapping databases
• Synchronized model with data base and correct discrepancies if any in DDL and generate SQLs according to new model
• Adhering to standards in all work products and participate in the refinement of those standards to improve quality and productivity
• Documenting procedures to facilitate cross team support of ongoing operational interfaces and regular data patches
• Understand and communicate technical issues and solutions to the business
• Worked with business users to clarify data requirements and analyze and document scope of work for data conversion and cleansing projects
• Developed and run validation processes to ensure conversion accuracy and quality
• Creation of database objects like tables, views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus
• Worked on support tickets of SPM using JIRA, resolve and follow up with functional and technical teams
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job
• Participated in the Sprint Planning sessions, daily stand-ups, sprint demos and sprint retrospective sessions
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2016 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks

Senior Systems Analyst / Data Analyst / Data Modeler / Oracle SQL Developer

Confidential

Responsibilities:

• Provided support of Umoja SAP HR modules Maintain and stabilize HR modules in SAP system: Payroll, Time, OM, PA, Benefit, Training & Event, Appraisal, ESS/MSS Create/Maintain Payroll Schema
• Supported and worked with the Umoja SAP HCM project team in Data Conversion, QA, Master Data Maintenance, Deployment, BI and ETL, Testing of HCM module
• Testing & Creation of data the Enterprise Structure (Personnel areas, and Personnel sub areas), the Personnel Structure (Employee groups, Employee sub groups, Payroll Accounting Areas), and the Organizational Structure (Organization Units, Positions, Job s)
• Worked on HR data marts and transactional systems, this involved analyzing requirements (user stories), identifying transactional database / data marts, validating data mart design and ETL mappings logic, creating mappings from data mart for the report, creating repository (RPD), reports and dashboard, testing those reports, unit testing, regression testing and documentation
• Maintained Employee Master Data using transaction codes PA30, PA40 to retest new defects upon vendor requirement/changes
• Involved in the Oracle OBIEE BI project, creating queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience using Oracle OBIEE g11
• Designed customized interactive dashboards in OBIEE and SAP BI tools as BI power user applying analysis, drill down, guided navigation, prompts, filters, and variables
• Designed, build and deploy data models optimized for business intelligence and analytics
• Developed a Conceptual model using Erwin/Toad based on requirements analysis
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Coordinated data collection activities to support data migration / conversion of legacy data into Umoja. Acts as a liaison between the internal Umoja teams and the Deployment Cluster Sites
• Developed data sets using SQL for quantitative and qualitative reports for both internal and external clients; standardizes Queries for reuse within the unit
• Participated in the IMU peer review process to ensure accuracy, quality and consistency in IMU provided reports
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Developed global data strategy for Enterprise Data Management, including data architecture, Master Data Management, EDW, data modeling standards, meta data management, and Data Governance
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes

Data Conversion Specialist / Oracle SQL Developer

Confidential

Responsibilities:

• Worked with business users to clarify data requirements and analyze and document scope of work for data conversion and data cleansing projects
• Designed and developed custom made business intelligence solution according to the plan using BI applications
• Built interactive dashboards with drill down effect through Oracle BI Answer using OBIEE 11g
• Developed and design complex data structures, ad hoc queries, reports and analytics, stored procedures, functions, triggers
• Interfaced with Umoja, Missions, OAH’s and HQ in order to facilitate data gathering and cleansing of data from legacy systems (IMIS, SUN, Progen etc) and provided guidance to missions and OAHs regarding data conversion
• Converted data from multiple data sources including text files, MS Excel, MS SQL, MS Access, Lotus Notes and others as and when required
• Designed ETL to load data from data warehouse, Oracle, MySQL, SQL Server to meet business needs
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing
• Developed and ran validation processes to ensure conversion accuracy and quality
• Analyzed data coming from different sources for data conflicts resolution in order to maintain and enhance records within master data
• Interacted with stakeholders in order to address issues and processes that will improve master data integrity
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions
• Created and maintained the Data Model repository as per company standards, data integration and migration processes as required by Umoja technical teams
• Ran period reports for business stakeholders and Umoja management to show progress of efforts
• Interfaced with Subject Matter Experts in pertinent business users and Umoja to review data conversion and cleansing requirements
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Tested ETL jobs as per business rules using ETL design document
• Developed data sets using SQL for quantitative and qualitative reports for both internal and external clients; standardizes queries for reuse within the unit, designs reporting templates using MS Excel and Crystal Reports
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets and create scripts using T-SQL and automate SSIS package execution
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information