SUMMARY

• Professional competencies in communication and goal setting, project delivery, financial management, and leadership.
• Fluent understanding of project management and software development life cycle (SDLC).
• Manage multiple projects simultaneously and meet project expectations and objectives on time.
• Experienced in Waterfall and Agile Software Development methodology.
• Experienced in managing, analyzing, designing, implementing and supporting corporate tools and applications.
• Apply in - depth understanding of business and IT requirements to streamline administration and internal processes, and transform them into process flow diagrams, use cases, technical and functional specifications.
• Experienced in Data Warehousing/Business Intelligence, Analytics and Database Administration.
• In-depth knowledge of data analysis, architecture and design (Relational Databases, Data Warehousing, Normalization, De-normalization, Star/Snowflakes Schemas), modeling, mapping and integration (ETL).
• Fluent understanding of Database Administration, performance tuning, security and high availability/disaster recovery.
• Proactive in research of new technology and software appropriate for supporting current projects, and learn and apply them quickly.
• Expert in written and oral communication, collaboration, problem solving, analytical, critical thinking, interpersonal, team building, mentoring, and organizational skills.

TECHNICAL SKILLS

Databases: Teradata 13.10, MS SQL Server 2005/2008 R2/2013, ORACLE 10g/11g Server, Sybase 10/11.5, IBM Informix

Applications: LA County Workforce Innovation and Opportunity Act and CalJobs (public sector), K12 School Education (public sector), Telecommunications, Distribution, Healthcare (MCO), Data Warehousing/Business Intelligence, Mortgage Banking, Accounting, Finance, HR, Payroll, Billing, Claims, Loans, Supply Chain, Production, Post Production, Marketing, Budgeting, Repertoire, Royalties, Residuals, Profit Participation

Methodologies: OOAD, UML, RUP (Rational Unified Process), RAD (Rapid application development), SAP Waterfall and Agile Methodologies, Business and Data Modeling.

Business Systems: ERP business management system

DW Tools: Hadoop, MapRduce data processing system

BI/Analytics Tools: Microsoft SSMS, SSIS, SSRS, SSAS, Adobe Analytics, Informatica, Digital data collection tools, IBM Cognos BI, TM1, SAP BW, SAP Lumira, MS Excel BI, Micro-Strategy, SAS Enterprise Guide, SAP Business Objects XI, Crystal Reports XI

GUI/Tools: Lotus Notes, Track Plus, MS Project, MS Office Suite (Word, Excel, PowerPoint, Access, Outlook), Adobe, Visio, ERwin r7, CA ERwin Data Modeler r8, Task Scheduler, FTP, Putty

Help Tools: RoboHelp, ForeHelp

Platforms: SharePoint 2013, TFS 2013, Salesforce, Windows VISTA/7/8, UNIX, MS DOS, IBM, HP

Testing Tools: WinRunner

DB Object Managers: Teradata SQL Assistant, SSMS, Server Studio, PL/SQL Developer, SQL Plus, dbArtisan

Languages: PowerBuilder 3.0/4.03/5.4/6.0/6.51/9.0/10.5/11.5/12.5 , Microsoft .Net 3.5, C#, VB, ASP.Net Apps, IBM Informix, Sybase, Transact SQL, Oracle PL/SQL, Java, XML, HTML

Class Libraries: PowerClass, PowerLock, PowerBuilder Foundation Class

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

IT Consultant

Responsibilities:

• Managed multi-million-dollar LA County Workforce Innovation and Opportunity Act (WIOA) enterprise project.
• Studied the Confidential and Cal Jobs system to obtain a thorough understanding of the systems.
• Undertook managing, planning, organizing and leading the technology project functions/operations for divisions, such as Contract Management and Financial Management.
• Managed automation of operational functions to in-house Cloud Virtual Servers for Contract Budget and Invoicing projects for FMD, and Contractor (Agency/Supplier) and Administration conversion projects from ERP systems for CMD.
• Created the Cloud system activity processes diagram for the new WDACS Contractor’s Gateway applicaiton.
• Supervised a team of 2 professionals composed of a business analyst and a data analyst, and 3 technical staff composed of 1 dba and 2 application and developers.
• Managed project planning, resource allocations and task assignments using MS Project.
• Collaborated and communicated with division managers and IT team leads.
• Studied Confidential processes and created swim-lane business work and process flows using Visio for “As Is and “To Be” processes, and applications documentation composed of prototypes in Visio, system procedures and standards.
• Streamlined application implementation by coordinating with leads and analysts.
• Managed and supported system users and IT staff with providing necessary resources and tasks to deliver a successful product.
• Provided executive management with necessary technology and system information for communicating with management, stakeholders and agencies (contractors).
• Supervised WDACS dba and data analysts to decompose the Cal Jobs system and integrate the data warehouse for on-going changes in an Oracle environment.
• Managed the application development planning and functional design for the various Confidential projects.
• Provided expert knowledge and leadership to elicit project requirements and documentation.
• Managed business and technical staff for integration of data across Confidential and financial source systems (eCAP).
• Coordinated the application change management.
• Planed and designed database objects for applications and reporting, assigned tasks to technical staff and worked with County OBA on performance and normalization in an Oracle DW environment.
• Was responsible for managing and coordinating the unit testing, integration testing, production simulation and load testing.
• Conducted interviews, performed workflow analysis, document scope and objectives, and lead the design sessions.
• Supported the technical staff with necessary information to provide reporting measures using Oracle Application Express and Cognos Report Studio, and web application functionality.
• Monitored application compliance with WDACS program requirements.
• Performed GAP analysis on potential Commercial Off-The Shelf (COTS) application acquisitions to identify the level of coverage and the amount of customization required to meet the needs of business area within WDACS.
• Studied WDACS program and policy guidelines to formulate solutions to improve service delivery.

Confidential, Long Beach, CA

IT Consultant

Responsibilities:

• Played key role in creating documentation and technical guides for end users.
• Facilitated User Acceptance Testing (UAT), ensuring that all errors were tracked and reported to development and management teams.
• Acted as single point of contact for multiple vendors, business units, and Information Technology partners during integration of Digital Tower Application (DTA) installation, administering schedules and communicating risks.
• Assisted with SOX 404 compliance, resulting in successful post-migration audit.
• Ran weekly meetings, helping to facilitate communication and maximize productivity.

Confidential, Los Angeles, CA

IT Consultant

Responsibilities:

• Managed a team of 4 professional and technical staff using Agile-Scrum project management methodology working with Microsoft Consulting Services and created BP flow diagrams using Visio, BRDs, FRDs, Data Definition Documents and gap analysis to derive requirements for K12 School Education Grade-book and Master Scheduling applications in My Integrated Student Information System (MiSiS).
• Attended Sketch (JAD) meetings for MiSiS functionality and performance enhancements working with Microsoft software architect consultant and provided support in analysis and documentation of business rules and requirements while they were implementing the new Application Lifecycle Management (ALM) with Sketches, Feature Acceptance and Report (FAR) and Build Stabilize and Release (BSR) phases.
• Communicated and acted as a liaison between business users and development team, and worked with senior IT management, Business Analysts, DBAs, Software Architects, SQL and Report Developers, and QA Team in project development and testing life cycle.
• Studied and analyzed the Student Information System (SIS) database, wrote complex queries using T-SQL and SQL Server 2013 SSMS, analyzed and documented Internal/External data issues for Gradebook and Master Scheduling tables.
• Wrote queries in MS SQL server and used data to create report presentations in MS EXCEL, using PIVOT tables.
• Manipulated and analyzed raw data and performed WEB Analytics.
• Reviewed and analyzed complex report RDLs in SSRS and data set stored procedures for creating new reports, enhancements and bug fixes and documented specifications.
• Analyzed Grade-book UI and Reports functionality for Elementary and Secondary school levels and documented user requests for enhancements and performance in the areas of Entering Grades, Roster, Creating Assignments, Assignment Categories, Grading Scale, Footnotes, Templates and Publishing Grades.
• Studied and researched the use of Missing Assignments and Grades report in schools for improving student grades to meet course requirements and created prototypes in Excel for UI query criteria screen and report layouts for detail, summary and Missing Assignments Report for parents.
• Documented specs for MiSiS Explorer Special Programs and Services for new ad-hoc reports such as Bus Route Information, Special Educational Services and student information with Resource Specialist Programs (RSP).
• Analyzed Master Scheduling UI and Reports functionality for Creating New Sections, Section Editor, Creating Periods, Walk-In and Concurrent Enrollment and documented user requests for enhancements and performance.
• Created Specifications documentation for new reports, interfaces, enhancements and bug requests from SharePoint and Team Foundation Server (TFS) tickets, specifying Objective, Purpose, Definition, Functional and Technical Specifications, Business Rules, Data Definitions with table and column information for Interface, Report Header, Detail and Footer, Report Layout, Sorting/Grouping and Exception Handling.

Confidential, Long Beach, CA

IT Consultant

Responsibilities:

• Attended phone conferencing and screen sharing, traveled to client’s sites, and interacted with stakeholders and customers to understand client business processes.
• Created use case diagrams and documentation using Visio to explain flow of events and how different software systems interact with each other.
• Worked in an Agile-Scrum project management environment and conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.
• Used project management methodology such as scoping, managing risks, milestones, UAT and coordinating and scheduling projects and providing status reports for development team and IT management on daily and weekly bases using MS Project and MS Excel.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation using MS SQL Server 2008R2 complex SQL queries.
• Created Forecasts, Dashboards and Predictive Models to provide meaningful and actionable insights for management’s ongoing business decision making.
• Design Data Marts that were used as the source for analytic reporting.
• Wrote reports using SSRS, SSAS and Crystal Reports to extract data for analysis using filters based on the analysis, performed QA connecting to the test database prior to deployment into production servers.
• Created Stored Procedures, Functions, Tables, Views, Indexes and Constraints using SSMS.
• Worked on complex information models, logical relationships and data structures.
• Consulted with business partners and made recommendations to improve effectiveness of Big Data systems, descriptive analytics systems, and prescriptive analytics systems.
• Extracted data from an existing database, web sources or APIs and supported the implementation of web apps in mobile devices and managing digital data and use of digital tools for efficient data collection.
• Designed, reviewed, implemented and optimized data transformation processes.
• Consolidated, validated and cleansed data from a vast range of sources and loaded into destination databases, files and Web services using MS SQL Server Integration Services (SSIS).
• Designed and implemented fast and efficient data acquisition using Big Data processing techniques and tools.

Confidential, El Segundo, CA

IT Consultant

Responsibilities:

• Attended and joined live meetings and web conferences for IT and BI design and gathered requirements for Agent Desktop single sign on version, Confidential (Active Decision Engine), BI and Champion Challenger projects, and created documents in MS Word.
• Joined web conference meetings to observe and analyze recorded live Agent Desktop application process for customer calls, treatments and offers and created complex documentation in MS Word.
• Managed CRM and applications using Salesforce as a centralized communication platform.
• Managed a team of 6 professional and technical team in an Agile project management environment, communicated and acted as a liaison, between senior IT management, business division management, solutions analysts, DBAs, BI Architects, SQL and ETL Developers, and QA Team.
• Provided support in the areas of data warehousing, database administration, operational and user issues.
• Created, updated and managed data dictionary/metadata, business rules, systems development and training documentation.
• Created reports, scorecards and dashboards using OBIEE, Cognos BI, SAP BD, Tableau and QlikView.
• Studied Confidential BI business rules, wrote queries using Teradata SQL Assistant 13.10, analyzed and documented Internal/External data issues and created complex spreadsheet reports in Excel.
• Traced ETL package scripts in Informatica, mapped and corrected logic for data extract, load and transformation from Oracle production source to Teradata BI target servers.
• Supported the implementation of web apps in mobile devices and managing digital data and use of digital tools for efficient data collection.

Confidential, Pasadena, CA

Data Consultant

Responsibilities:

• Attended phone conferencing and screen sharing, and interacted with stakeholders to understand client business processes and issues.
• Investigated and resolved data related issues by communicating with business users, querying, profiling and mapping data from source to target servers using SSMS.
• Documented and created test plans, scripts, data quality and integrity solutions.
• Created packages for ETL using SQL Server Integration Services (SSIS) and carried out deployment and supported development and administration teams.
• Analyzed, designed and developed Confidential Executive Dashboard, Scorecard, CRM Analytics and financial performance reports using MS SQL Server 2008 Reporting Services (SSRS),
• Converted complex Excel based reports into SQL Server Reporting Services reports for high profile users.
• Implemented report groupings to enable users access reports under each group.
• Designed and developed pop-up reports from URL action property in SSRS using JavaScript code.
• Added scripts to report columns, enabling users to send mail from reports.
• Performed data mining, used visualization objects, KPIs and charts to design and develop reports for various reporting periods using SSRS, Cognos BI and Business Objects/Crystal Reports.
• Created Stored Procedures, Functions, Tables, Views, Indexes and Constraints using SSMS.
• Communicated with the DBA and deployed Report RDL files to the Reports Server to be used on the Web.
• Created, updated and managed system and application development, and training documentation.
• Worked in OLTP and OLAP environments.
• Attended phone conferencing and conducted demos via screen sharing.