PROFESSIONAL SUMMARY:

Qualified Sr. Developer / Data Analyst/ Business Analyst/Data Consultant/Data Architect/ Business Report developer with a diverse range of leadership, analytical, communication, troubleshooting, independent, and critical thinking skills. Strong understanding and ability to adapt to and implement various SDLCs.

PROFESSIONAL EXPERIENCE:

Confidential, Knightdale, NC

Sr. BI Data Architect/ Database Developer/Data Modeler/Report Developer

Responsibilities:

• Provide reporting and visualization troubleshooting services for Cognos, Tableau, Pentaho, Business Objects, OBIEE/OBIA, SAS analytics, Sybase IQ and MSBI stack.
• Provide Integrations and troubleshooting services for Informatica, Oracle Data Integrator, SSIS, Pentaho Integration
• Create Tableau data connections for data sources such as (IBM DB2, Oracle, MS - SQL server, flat files, excel)
• Design dashboard prototypes based on business requirements
• Create data models base on business requirements for various companies
• Create public facing web apps using J2EE, JSP, XML, Struts, and Tiles
• Informatica and Salesforce integration cloud - Development and Administration
• Create lunch and learn sessions for various visualization tools such Tableau, Cognos, SAS, OBIEE, Business Objects SAP, SSAS and SSRS
• Create lunch and learn sessions for CRM tools such as MS Dynamics and Salesforce
• Create mapping and conversion plans for moving between Salesforce classic to Salesforce Lighting

Confidential, Raleigh, NC 0

Sr. Data and Content Management Subject Matter Expert

Responsibilities:

• Created Master Data Management training and guidance artifacts for developer’s workshops. Discovered, defined and documented standards and reusable functionality and services for SOA development and reporting
• Documented “As-Is” and “To-be” data processes
• Helped define data rules for the collection, storage, access, archiving, and destruction of data. Helped to define data scope, roles and responsibilities.
• Helped to define data cubes from various sources, defined OLAP cubes, and updated hierarchies
• Contributed to and matured NCDOT data discipline Body of Knowledge by adding content, validating data ideology, and best practices as adopted in DAMA DMM/DMBOK, NIST, NEIM, and TOGAF.
• Defined and created SOA lifecycle documentation for business requirements, functional requirements, data analysis, data design, ETL integration, requirements traceability matrix, testing, and gap analysis
• Created technical road maps. Updated mind maps with detail information to mature the data discipline for SOA
• Created, enhanced, and maintained content and data management solutions through the population and maintenance of the SOA Data Asset inventory and capabilities.
• Worked with DMG to provide data services by helping to developing data cleansing processes for DMV Modernization, and Master Data Management. Helped to define the master file.
• Gathered requirements and helped to create and setup data profiling task for DMV data. Helped defined and setup a secure lab for data stewards and data analyst to worked together and define SSIS integration packages used to ETL data for cleansing. Helped to define, document, and implement all defined processes. Ensured that all participants had VMware and the necessary software on the workstations to access and operate in the various environments
• Documented and helped to define SSIS ETL data standards, naming conventions and transformation patterns
• Worked with the DMG team to define and create a process for shared and secure access to PII, PCI, and highly restricted data. Worked with Data security to help implement data security policy and procedures.
• Documented and created “Lunch and Learn” material for data modeling and design using, Sybase PowerDesigner, Oracle Designer, Oracle SQL Developer
• Helped to define and document ETL processes for DB2, Oracle, Sybase, MDX SQL server, and SharePoint data sources.
• Help to create, test, and document the cleansing, secure access and deployment processes
• Documented and helped to define SOA and DMG deployment plans. Used TFS check-in/check-out between stages
• Documented and helped to create Request for Change Order (RFC) and work orders using the OTRS change management system.

Confidential, Rhode Island

Sr. BI Data Architect/ Database Developer/Data Modeler

Responsibilities:

• Collected business requirements, documented business rules, and converted business requirements to functional requirements and specifications. Set up requirement traceability matrix (RTM) for data models
• Met with the Confidential Data governance and advisory members to define and secure data
• Created physical model prototypes and wrote SQL and PL/SQL code to test and discuss models against RTM
• Designed data model for Eligibility and Enrollment domain which also included Medicaid, CHIP and DHR.
• Provided business and functional rule transformation for ETL from relational to dimensional database designs.
• Created mapping plans between multiple data sources and targets (Oracle, Db2, SAS, Excel, Sqlserver, and flat files)
• Using the Eligibility and Enrollment model, designed Pentaho integration templates, as well as built prototypes for data visualization and reporting to be used with BI tools Tableau, Cognos, and SAS
• Created ETL prototypes for team members. Wrote SQL and PL/SQL code to test data before and after integration
• Installed, setup and configured Tableau Desktop and Tableau Server. Maintained versions and upgrades. Ensured all workbooks were properly migrated.
• Worked with analytics team to map and convert Excel report to tableau reports by replacing coding, pivot tables, VLOOKUPs, with complex calculations, and table calculations. Changed static reports to dynamic and interactive visualizations by using parameters. Managed and created geographical visualization by using geographic mapping. Ensured performance and optimization for reports by applying Tableau, and other database optimization best practices
• Created Tableau BI dashboard presentations to display dimensional analytical functionality for predictive analysis

Confidential, Folsom, CA

Sr. BI Data Architect/ Database Developer/Data Modeler

Responsibilities:

• Provided troubleshooting services such as SharePoint restores, ETL and ELT services for conversions from relational to dimensional data marts and warehouses

Confidential

Sr. BI Data Architect/ Database Developer/Data Modeler

Responsibilities:

• Analyzed AMI business requirements in CaliberRM and converted them into functional requirements.
• Participated in AMI design sessions to integrate external vendor technology with Duke’s Smart Grid metering requirements. Verified current state and defined future state for over the air readings to be extracted and transformed using business rules and loaded according to models of various database targets.
• Wrote AMI ETL and ELT design and specification mapping documents that were used for integrating the meter Firmware updates, Phase Angle, and Device Status data from SSN Han Communication manager (HCN) Oracle database into Duke's customer information systems such as CSS, and CIM DB2 databases or Oracle data warehouse for the AMI project.
• Lead design and development of Informatica ETL and ELT solutions
• Lead design and development of SFTP and XML Gateway solution from Duke to third party vendor
• Attended RDR meeting to ensure that all business requirements were in CaliberRM and actionable
• Converted RDR business requirement into functional requirements for the RDR project. Met weekly with external load management vender to ensure vendor’s proposed solutions met or could be customized to satisfy Duke’s business needs.
• Wrote COBOL programs to load or update CSS and CIM DB2 databases. Create JCL to execute the Cobol programs
• Lead and participated in design sessions to integrate external vendor technology with Duke’s Confidential switches and Load Management (LMS) requirements. Worked with team members using CA ERWIN to create conceptual, logical, and physical models that included the defined business model. Passed physical model to DBAs for creation
• Worked with various leads to ensure that the data models were complete and included definitions for each database and that the integration between the databases was specified. Used TOAD and Oracle SQL Developer Data Modeler tools to design test data and cases, to extract test data, and to ensure completeness
• Ensured that the DBAs were given complete and concise information to construct the physical database from the physical models
• Ensured that the models were defined and could handle the business requirements and rules for transactional functionality (OLTP) as well as reporting (OLAP).
• Wrote RDR ETL and ELT design and specification mapping documents that were used to obtain Field service request (FSR), Visit, and Inventory data from the DB2 CSS databases, and deliver the data to an external vendor.
• Handled, routed, and assigned defects from HPQC.
• Created defect analysis documents

Confidential

Responsibilities:

• Created Informatica data sources and targets as necessary from flat files, DB2, Oracle, SAS, Excel and various other data sources
• ETL- Using Informatica, extracted data from various sources, transformed data per specification, and Loaded data to various targets
• ELT- Using Informatica, extracted data from various sources, loaded data to various targets, and created database transformation per specification for reporting and other request.
• Created Informatica ETL mappings as specified for both AMI and RDR project functional requirements
• Created Informatica sessions and workflows to execute mapping designs
• Created UNIX shell scripts to extract and set up data, format data, rename files to include date timestamp and move files to staging areas on different servers, set parameters for informatica workflow processes.
• Created Unix scripts, and DOS batch files depending on server and OS to use with CA Workload Automation
• Created Requirements Traceability Matric (RTM) for requirements on components
• Created unit test plans for solutions and matched information in the RTM. Set up Gap Analysis
• Documented and managed the team’s test plans and results for input to HP Quality Center (HPQC)
• Assisted with HCM versions 2.0 & 2.1 software acceptance testing using SOUPUI Functional API testing tool
• Designed, wrote, tested, and documented SFTP file transfer automated processes for transferring files to Third party venders for both secureFX and winSCP software. Created CA ESP Jobs to schedule the transfer processes. Designed and documented a process to deliver files to the Layer7 XML Gateway. Used DOS and Unix scripts to format, rename and deliver files to the Layer7 XML Gateway
• Created, updated, and maintained documentation via of SharePoint designer.
• Defined and mapped custom reports produced in RightAngle PGN Custom stored procedures so that they could be produced from within Business Objects
• Created integration process for ETL of data reporting Hub from relational to dimensional.
• Explained and provided business and operational information about both Solarc Right Angle and Confidential Custom stored procedure and functionality to business analysts and developers

Sr. Database Developer

Confidential

Responsibilities:

• Participated in DPI’s Data governance process. Attended weekly data governance meeting. Met with business owners to gain knowledge about subject areas. Gathered and documented requirements to ensure that the Confidential warehouse dimensional model met the State of NC educational needs and specifications as well as allowed production of federal EDEN reporting. Helped define data rules for the collection, storage, access, archiving, and destruction of data. Help to define data scope, roles and responsibilities, policy, procedures, and standards
• Defined and mapped data elements from 23 plus sources and databases (Oracle, Db2, SAS, and files) to the Confidential Longitudinal Oracle data warehouse. Assisted with defining functional areas for dependent reporting data marts
• Extracted and transformed student data from NCWise using Oracle PL/SQL and SQLplus. Loaded the extracts data into the ODW using SQLloader and Oracle Data integrator. Used ODI and Oracle SQLloader to load financial, teacher licensure and certification, educational programs, and assessment testing data from various databases, applications, and flat files into the ODW. Scrubbed and cleaned data as specified by business rules. Used Linux scripts and Oracle PL/Sql to scrub, format, and merge data in the staging area from various formats.
• Created Oracle PL/SQL and SQLplus scripts to extract and transform 23 data sources based on the Confidential dimensional model. Loaded data for a 1000 plus tables into the Confidential ’ warehouse using SQLLoader and Oracle Data Integrator.
• Created Linux shell scripts to insert files from the Unique Identification system (UID) into an Oracle database for error processing. Created Oracle stored procedures to correct or match LEA/school codes in program data to eliminate erroneous, duplicate records, and manage Change Data Capture (CDC) from the UID files, and to correct various data fields within the UID files. Merge data to create authoritative source for each educational program.
• Assisted with the designing and planning of new functionality for an Oracle Apex Metadata management system. Created updatable mapping to ensure that the MDR had updated elements that map to authoritative sources for reporting as well as map to elements in the Confidential data warehouse.
• Designed and created facts and dimensions using Oracle Business Intelligence Enterprise Edition (OBIEE) that allows the relational data from other sources to be modeled dimensionally
• Created BI Publisher reports, dashboards, scorecards and OBIEE KPIs using OBIEE Business Intelligence
• Created training documentation for the Confidential OBIEE reporting system and dash boarding
• Conducted OBIEE dashboard and BI Publisher reporting training session for registered participants
• Assisted with creating a XML process to deliver federally regulated reports and documents from the Confidential OBIEE reporting system to the US Dept. of Education. Used XML SPY to set up and create formats for the XML created reports. Automated the OBIEE and XML SPY process

Confidential, Raleigh, NC

Project Lead/Sr. Developer/Data Architect

Responsibilities:

• Served as project lead, collected and documented requirements by interviewing the business users and analyzing each of the applications, Obtained the business user’s sign off to ensure that all requirements were captured
• Using TOAD and Oracle SQL Developer Data Modeler tools, created the conceptual, logical, and physical models. Ensured that the DBA had the proper definitions to create the physical model
• Designed and created Oracle 10g repositories for SQL Server, Oracle9i, and DB2 databases, by transforming the relational data models into dimensional models. Created star and snowflake designs based requirements. Used context, alias, and short cuts to resolve loops and used classes, subclasses, and custom filters for clarity
• Wrote design specifications to empower and assist other team members with building universes for the systems.
• Created financial Universes with GL, AR, AP, and PO financial components using Business Objects XI.
• Extracted, transformed and loaded (ETL) data from the HORIZON AS/400 DB2 database using MS SQL Server Integration services (SSIS), from the Solomon SQL Server 2000 database using MS SQL Server Data Management, DTS and BCP tools, and from the Multiview Oracle 9i database using Oracle Pl/Sql, SqlLoader, and dblinks. Transformed Cognos business processes for rail and lag data in Cognos Cubes to fit new dimensional model.
• Consulted and assisted with the training of team members on Business Objects XI Universe Designer
• Built report templates using Business Objects XI Web Intelligence that included graphs, drill downs, multiple queries, custom queries, system linked reporting and BO dashboards.
• Worked with users to test reports and ensure that audit questions for the data could be answered from the repository using Business Objects XI Web Intelligence reporting tools.
• Provided backup support for Solarc Right Angle and Sqlserver by monitoring and checking the Accounting, Contracts, FEA options, Scheduling, and Valuation RAM Queues each morning. Performed root cause analysis on queues that were stopped and restarted the queues after issues or problems were resolved
• Provided backup up for Solar Right Angle monthly close when main support was out.
• Provided Solarc Right Angle support and assisted with development for Accountcode Engine, Compositional blending, Nightly Snapshot, Performance Analysis, Credit Interface, Pricing Provisions, and the Purge Process.
• Assisted with decommissioning of Right Angle Solarc for the coal commodity.
• Used views to transformed relational table to dimensional formats or layouts that could be used with Business Objects reporting without modifying the relational database that was being used with Crystal Reports and other relational reporting tools.
• Replicated various Crystal Reports to Business Objects Desktop reports
• Migrated Transportation application from Visual Studio.net to Visual Studio2005. Made appropriate code changes where necessary. Assisted with migration plans from Visual Studio 2005 to Visual Studio 2008
• Supported conversion of Weight Ticket system and XML files transfers to SQLServer database