SUMMARY OF QUALIFICATION

Sixteen years experience in analysis, design, development, implementation and testing of various IT solutions in ORACLE, UNIX and LINUX environments, including five years experience in Unix/Linux administration, vendor management and two years experience in IT acquisition logistics.Seven years plus experience in enterprise level data warehouse/business intelligence projects. Responsibilities ranged from Data Warehousing data population and data modeling techniques. Key strengths include strong troubleshooting, analytical and problem solving skills, effective leadership and team management skills. Excellent interpersonal communication skills.Experienced in all phases of the Software Development Lifecycle SDLC .

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows 2000 XP, Linux, Digital UNIX, AIX, HPUX 11.0

Software: Oracle 9i/10g/11g, SQL Server 2005, SQL Net, Oracle Enterprise Manager, Oracle Database

Replication, Unix shell scripts, Informatica, Cognos, Microstrategy

Database Tools: SQL Plus, SQL Loader, Erwin 4.x, Oracle Enterprise Backup Utility, Oracle Forms, Oracle Reports, Oracle Designer, Quest, PL/SQL, SQL, C, C Shell, MS Access, SQL Server.

Languages: Java, JSP, VBA, Oracle Programming, T-SQL, XML, Shell Scripts, C, PL/SQL,Pro c,

PROFESSIONAL EXPERIENCE

Sr. Technical Lead

Confidential

• Serving as the technical lead, I successfully designed and developed technical solutions for new andexisting IT systems for multiple HR Applications.
• Responsible for reviewing and approving design of subsystems and integrations between components, as well as impacts to other systems. Approved system interfaces and assisted in system implementation approach and operational concepts as necessary.
• Performed business and functional analysis using multiple/available resources including documentation, stakeholders and other functional users to identify key business, functional requirements, and technical requirements.
• Involved in execution of the Standard Software Development Life Cycle phases - including functional and technical requirements analysis, design, development, testing, implementation, training and system support.
• I have demonstrated significant consulting experience and ability to communicate effectively.
• Working with the functional users, I designed and implemented system enhancements, test patches and upgrades, and modified applications to support HR Applications.
• I provided Oracle PL/SQL support including diagnosing and resolving complex problems. Additionally I provided end user support including analysis, diagnosis and successfully resolved complex problems for an array of HR Applications.
• I created short-term technical solutions to achieve long-term objectives and solutions for HR Applications.

Management Information Specialist

Confidential

• Responsible for the initiation, development, implementation and ongoing review of policies, programs and initiatives for the Capital Fund. Responsible for oversight of management information systems, and provisions of administrative support services required for the operation of the program office. Planned, organized and assigned work to team members.
• Provide technical assistance, advice and guidance for a variety of MIS applications affecting certain aspects of the program office. Recommend actions and projects as appropriate, planning resources, projected time frames and required coordination.
• Represent the organization on project teams, which consists of program offices staff as well as contractor personnel. Assist with conducting and planning projected work processes, operational practices and needs assessments, which affect program office operations.
• Performed segments of difficult and responsible assignments concerning hardware and software planning, design,development, implementation, control and coordination of a unique set of complex management information processing systems. Involved in short term and long term planning of HUD's systems. Involved in architecture and infrastructure planning and management.
• Provide problem resolution regarding specific issues throughout the program office. Conducted preliminary analysis of systems to assist in determining the nature of requirements, logical work and whether advanced management information processing systems should be implemented. Evaluated alternative technologies and performed cost benefit analysis of different alternatives.

Sr. Systems Analyst

Confidential

• Served as a Systems Analyst /Acquisition Analyst and successfully coordinated and implemented multiple projects. Conducted technical evaluations of cost proposals and prepared independent cost estimates to support evaluation of alternatives.
• Gathered business requirements, translated them to functional and technical specifications and created System Design documents for multiple enterprise applications.
• Evaluated business requirements, identified and recommended hardware platforms and software technologies and participated in vendor selection process. Assisted in drafting vendor evaluation criteria. Responsible for ensuring the contract provisions were met.
• Developed data mart models, designed specifications to developed analytic and forecasting model to calculate unbilled revenue.
• Extensive experience in developing Public Objects Filters, Prompts, Metrics, Custom Groups, Consolidation and Templates to develop reports for executive management.
• Developed reports and dynamic dashboards for daily, weekly and periodic sales analysis
• Created ETL process flow Scripts and worked with DW Developers to automate data extraction.
• Wrote functional and technical specifications for PL/SQL to embed complex business logic in stored procedures and designed translation of business processes into DW mapping
• Interacted with the end users to define and document data warehouse business requirements as the foundation for database design, data extraction and analysis.
• Documented data mapping rules for movement of data between applications.
• Generated Physical Data model and Logical data models with Erwin.
• Evaluated processes, tools and on-going support structures to enable reuse and efficiency.
• Resolved data issues across platforms and applications, including discrepancies of definition, format and function.
• Created data models with entity-relationship-attribute and star schema with Kimball methodologies
• Created data flow diagrams and process models and integrated models across functional areas and platforms.
• Worked with DBA in transition of logical model to physical model

Oracle Technical Lead

Confidential

• Served as a Vendor Manager/ Sr.Technical Lead for the Digital Media Platform. Responsibilities included daily interactions with the vendor, troubleshooting and coordinating any issues related to failures in the daily processes. Assisted in writing vendor contracts and drafting SLA for the vendor. I was also responsible for preparing and developing the criteria for evaluating vendor proposals, tracking and enforcing vendor Service Level Agreements SLAs .
• Led a team to gather business requirements and writing functional and technical specification documents for the project to unify the Sprint and Nextel digital media platforms.
• Involved in long term and short term planning of IT systems. Developed system development schedules. Planned organized and delegated work to sub ordinate staff.
• Conducted JAD sessions involving the Business Users and Development Team to identify the Business Requirements. Served on the Joint Review Committee to improve the system availability to 99.9 while reducing the maintenance costs.
• Led and coordinated working sessions with internal IT departments and external vendors to resolve and fix issues. Conferred with development staff to monitor development and maintenance projects.
• Responsible for compiling vendor compliance reports and keeping track of all associated penalties. Served as a mentor to other team members. Provided training to off shore resources, to provide a 24/7 coverage for vendor support.
• Developed detailed Test Strategy, Test Plan, Test cases, and Test scripts. Established and developed the performance criteria. Formulated the Test approach and carried out elaborate system testing. Designed and developed a roadmap to identify and resolve production issues. Responsible for streamlining and refining the existing processes and served as the organization's POC to engage the vendor.

Senior Systems Analyst/System Administrator

• Confidential
• As a Systems administrator, I was responsible for installation, management, and monitoring of Solaris systems and associated hardware/software for enterprise systems. Setup various user profiles, environment variables/security to ensure smooth operation.
• In addition to my duties as a Unix Admin, I routinely provided system analyst support which included systems and software troubleshooting, Windows desktop troubleshooting/support. I have also on occasion taken on Oracle DBA responsibilities when needed, and provide operational support to any group requiring data backup/archival, job automation and scheduling, or nightly reporting.
• Responsibilities as a Unix System Administrator included monitoring and tuning systems to ensure optimum level of the performance, periodic software maintenance, system upgrades, tuning of system parameters for optimal performance and development of Korn Shell scripts necessary to maintain a consistent operating environment.
• Created disk groups, volumes, volume groups and RAIDs using VERITASVolume Manager. Created Korn shell scripts to monitor system resources and maintenance and scheduled cron jobs.
• Involved in preparation of functional and system specifications. Estimated storage requirements for applications.
• Responsible for tracking the progress of the project, collecting daily or weekly status from team members, contractors both on shore and off shore, addressing their problems, communicating problems and finding resolutions with other work streams, mitigating bottleneck issues and compiling project progress reports.
• Provided direction and technical guidance to team members in order to complete deliverables before the deadline and within budget.

Systems Analyst/Design Lead

Confidential

• Responsible for managing an Oracle decommissioning project involving 8 team members.
• Managed and led a group of developers working on decommissioning of the Oracle Data warehouse and migration to Teradata, flagging and addressing potential bottlenecks or barriers and performing all the administrative duties.
• Lead the efforts of the client architecture team in defining the Business Intelligence / Data Warehouse end-to-end architecture.
• Interacted with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community.
• Designing and architecting end-to-end ETL process including data Extraction, Transformation and Loading from source systems
• Designing and creating the architecture of data warehousing star schema logical database model with Kimball methodologies
• Generated Physical Data model and Logical data models with Erwin.
• Investigating and resolving data issues across platforms and applications, including discrepancies of definition, format and function.
• Worked with Lead Data Architect to transition logical model to physical model.
• Generating High Level Architecture, High Level Design, ETL Mapping, OLAP Reporting and Process Flow diagram documents.
• Translated the business processes into Informatica mappings.

Oracle Systems Analyst/System Administrator

Confidential

• Designed the ETL processes using Informatica tool to load data from Oracle 9i,into the target DW.
• As an Informatica/ETL consultant, designed, modeled, developed ETL software for a data mart in Informatica
• As an ETL consultant designed and created 200 mappings/sessions/workflows to move data from source to reporting data warehouse for complex Cognos Business Intelligence
• Served as a Data Warehouse Specialist/Consultant in the development of an enterprise data warehouse/business intelligence application for gathering and tracking the emission of pollutants by industries into the air, water and soil. Primary focus and/or development efforts were in the reengineering of the ETL processes
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created Reports, Documents, Dashboards and Scorecards according to client/business requirements. Created Ad-hoc Reports by drilling up, down, with across hierarchies.Developed Reports enabling Data Drilling across multiple Dimensions.
• Performed overall planning of personnel, software and hardware for implementing IT solutions. Assigned staff for approved projects. Evaluated staff performance and identified training requirements.
• Conducted and participated in the architecture and model review meetings.
• Conducted certifications and security reviews and solicited third party security software vendors. Coordinated development of a System Security Plan, Security Review and Security Assessment. Analyzed, designed, implemented and tested Information Technology IT systems under development.

ORACL DBA/Software Development Lead

Confidential

• Served as the Development Lead responsible for leading a team of software engineers in the design, code and unit test, and integration testing of a custom Extract Transform and Load ETL tool.
• Analyzed, designed, optimized and tuned PL/SQL code. Designed various report layouts for new contracting strategies and providing the baseline sales and monthly sales to track customer performance.
• Involved in writing complex PL/SQL scripts. Wrote shell scripts for scheduling various jobs.
• Analyzed procedures, database triggers, and various ORACLE DBMS utilities. Performed enhancements for a Web-Enabled Publication Information System.