Lead Analyst Resume
SUMMARY:
- His experience has been focused on various industries including manufacturing, financial, healthcare, retail and distribution with specific interests in warehouse management, automation, shop floor control, accounts payable and receivable, customer billing and inventory management. In addition various projects involving Application Integration and Business Intelligence have allowed SA to utilize the industry and database experience in delivering quality solutions to his clients.
- His strengths include strong technical knowledge and understanding, as well as excellent communications and organization skills. He has worked with all major relational databases including Oracle database suite, Microsoft SQLServer and DB2, both in a developer and a DBA role. Saads technical skills in various platforms include microcomputers/Windows, VAX/VM5, HP/UX as well as radio frequency data communications and other data collection systems.
TECHNICAL SKILLS:
Languages: RedPrairie Toolset (MOCA, Integrator, DDA, MCS), SQL, PL/SQL, C/C++, Java, Groovy, Visual Basic, OneWorld ER, SQR, XML, HTML, Perl, Zope DTML, JavaScript, Uniface, Shell Scripting (Korn Shell, C Shell)
Tools: RedPrairie Toolset, Oracle Developer, Automated QA, Microsoft Project, OneWorld, Cold Fusion, RedPrairie Dlx Integrator, Oracle Discoverer, Oracle Portal, ERWin
Databases: Oracle, Microsoft SQLServer, IBM DB2/400 and UDB, Microsoft Access
Web Application Servers: Oracle Application Server, IBM Web Sphere, Apache, Zope, Red Prairie Application Server
System Administration: Database performance tuning, database release install, device configuration, backup configuration and management, database tuning on specific platforms, including Oracle, JDEdwards, Windows NT and UNIX.
Design: Data flow diagrams, entity - relationship diagrams, testing and acceptance plans, specifications development, estimating.
PROFESSIONAL EXPERIENCE:
Confidential
Lead Analyst
Responsibilities:
- Design appropriate WMS business processes for various customer scenarios
- Analyze the various systems to develop appropriate business process integration strategy
- Plan and implement the data and business process integration
- Analyze the existing business processes to discover the integration points
- Analyze the existing systems to devise a technical strategy for the interfaces
- Develop interface mappings between the various systems
- Utilize industry standard techniques including EDI, XML, SOA, and Web Services
Confidential
Project Leader
Responsibilities:
- Lead a team of developers in a JD Edwards World - JD Edwards One World upgrade
- Designed and Developed several Custom Interfaces to allow easy data set up and entry into One World for various modules
- Designed and developed the various enhancements to the system as specified by the customer
Confidential
Lead Data Warehouse Analyst
Responsibilities:
- Designed the data warehouse schema based on customer requirements
- A combination of star and snow-flake schema approaches
- Designed the specs for the sending systems
- Developed documentation and process flow diagrams using Erwin
- Lead the development effort
- Over 10 sites sending daily OLTP data
- Data was loaded into an Oracle 8i database
- Created data marts for reporting needs using PL/SQL
- Provided row-level security in the data mart
- Developed reports using Oracle Reports and Oracle Portal
- Developed dynamic drill downs using Oracle Discoverer
- Developed user documentation
Confidential
Oracle Portal Consultant
Responsibilities:
- Assist in the design and use of Oracle Application Server suite as a solution for the company intranet
- Prototype the use of various Portlets for providing access to various database and non-database data souces
- Educate the customer on the use and concepts behind the Oracle Application Server suite.
- Prototyped, Designed, and Developed custom portlets to be used in the final solution.
Confidential
Lead Data Warehouse Analyst
Responsibilities:
- Designed the data warehouse schema based on customer requirements
- A combination of star and snow-flake schema approaches
- Designed the specs for the sending systems
- Developed documentation and process flow diagrams using Erwin
- Lead the overall development effort
- Over 200G Data Warehouse on an 8 CPU Server
- Over 70 data sources providing daily feeds
- Using Oracle 8i with partitioning
- Developed a data loader for the data warehouse
- 100% generation of C code based on meta-data
- Employed POSIX threads to allow for simultaneous loads
- Employed bulk operations for fast loads
- Developed a data mart for the data warehouse
- Employed materialized views and PL/SQL for summarization and replication
- Employed Oracle Advanced Queues for job orchestration
- Employed Oracle jobs for scheduling, batch processing, and parallel operations
- Using Oracle 8i with partitioning
- Most dynamic web pages were guaranteed to return data in less than 30 seconds
- Developed an infrastructure for deploying reports on the web
- Deployed Oracle Reports using CGI
- Deployed drill-down reports using Zope
- Provided row-level and object-level security
- Developed user documentation
Confidential
Project Leader
Responsibilities:
- Lead a project involving data integration for reporting needs
- Data was loaded into a data warehouse
- A data mart was created for reports
- Developed user documentation
- Team Lead and Lead Architect for an Enterprise Application Integration product. Some information about the product is as follows:
- Allow for B2B and B2C communication
- Event-driven data extractor
- Allow many sources to communicate to many destinations
- Support XML, Fixed Byte Files, CSV Files, and database tables
- Lead a team of software engineers
- Managed the product life cycle
- Developed training material for the product
- Developed presentations for customers and upper management
- Developed training course for new recruits
- Developed complete documentation for the product
- Designed the functionality for Red Prairie’s Warehousing product.
- Performed gap-analysis for projects to pin point the customization points
- Created high level and detail designs
- Enabled the product for internationalization and localization
- Developed an infrastructure to develop forms such that the screen titles were rendered based on the user’s preferred language
- Developed an infrastructure to allow the data to be stored in multiple languages
- Developed an infrastructure to store the measurement information such that it could be rendered in multiple units of measure
- Developed an infrastructure to store the currency information along with the monetary data
Software Engineer
Responsibilities:
- Worked in a team on a warehouse management project
- Designed and implemented functionality as requested by the customer
- Provided customer support