Project Manager Sql Server
Resume:
Jawad Abdul Majeed
*******@*****.***
Summary:
- Over 8 years of IT experience, 6 years experience as Software Engineer, 5 years experience as a
Technical/Business Analyst.
- Bachelor of Science from University of Minnesota, Major: Computer Science Minor: Computational
Mathematics, GPA: 3.5/4.0
- Extensive experience in Java, J2EE, C++, Servlets, OOAD, JSP, JSTL, JSF, Hibernate3, EJBs, XML,
XSLT/XPATH, Spring2, Struts, AJAX, BEA Weblogic, IBM Websphere5.1/6.1, Tomcat & JBoss.
- Strong background in using XSLT/XPath & XML to develop front-tier
- Proficient in writing JUnit tests, including Cactus, Servlet, Mock & Live tests.
- Experience with Database Management Systems in SQL Server and Oracle.
- 5+ years of Oracle Technical Experience and 2 years of Oracle Functional Experience.
- Experience in implementing Oracle 12i - specifically in HR modules.
- Experience in implementing Oracle Application Modules 11.5.8 (Service Contracts & Install Base),
Reports 6i & Discoverer.
- Experience in data modeling and verifying source to target data using complex SQL queries, triggers,
procedures and functions.
- Extensive experience in SQL, Oracle, DB2, MySQL and writing stored procedures.
- Extensive experience in C/C++, PHP, Perl/CGI in developing Client-Server applications.
- Experience in Data Warehousing and generating reports using complex SQL queries for business community.
- In depth experience in RAD, Eclipse, MyEclipse and IntelliJ.
- Strong experience in Linux Ubuntu/Redhat and Batch/Korn/Shell/Python scripting.
- Strong experience in writing Technical/Design documents and managing requirements using standard tools like
JRules. Excellent skills in MS Word, Excel, Access, PowerPoint, Sharepoint, MS Project.
Technical Business Analysis Experience:
- Strong Experience in all stages of Software Development Life Cycle (SDLC) including Requirements
Gathering, Specifications Analysis/Design, and Testing as per the RUP’s Iterative Software Development Life
Cycle process.
- Experience in conducting Joint Application Development (JAD) sessions.
- Conducting Requirement Gathering sessions, Feasibility Studies and Impact Analysis and organizing the
software requirements in a structured way using Rational RequsitePro to track development.
- Analysis, creation and review of functional and Business Requirement Documents.
- Gathering Business and Technical requirements to best fit the needs of the technical architecture
development process.
- Interviewing Subject Matter Experts (SME), asking detailed questions and carefully recording the
requirements in a format that can be reviewed and understood by both business and technical people.
- Experience in UML modeling, including Use Cases, Sequence, State, Class and Activity diagrams using
tools such as Rational Rose and Microsoft Visio.
- Worked in close co-ordination with the testing team in developing test plan and test cases from functional and
business requirements.
Quality Assurance Experience:
- Strong experience in testing, tuning, profiling: RationalMercury/Test-Director/JProbe.
- Worked in close co-ordination with the testing team in developing test plan and test cases from functional and
1
business requirements.
- Used Rational Mercury for defect tracking and prioritizing defects and for enhancements after base lining
the requirements.
- Well versed in analyzing consumer behavior and understanding business functionalities.
- Highly motivated team player with excellent communication, presentation and interpersonal skills, always
willing to work in challenging and cross-platform environment.
Other Experience:
- Experienced in Document Management and Project Management cycle.
- Worked with multiple business groups: Finance, Purchasing, Pricing, Marketing, and Sales on enterprise wide
costing applications, while managing business vision and deliverables.
- Excellent analysis and documentation skills – project charter, WBS and project plans, scope/vision statements,
process flow, and ‘AS IS’ vs. ‘TO BE’ analysis.
- Coordinating with the Project Team and Deployment Team for build release.
- Focused on feature/use case based development and minimizing project payback time.
- Identified process/information gaps in the current financial, sales and pricing processes, writing
recommendations, and driving complex requirements for enhancements.
- Identified risks and developed risk mitigation & contingency plans.
- Expert in various project management methodologies –PMI, Iterative, Agile, Scrum, RUP, etc.
- Strong experience in managing offshore team, business and vendor relations, contracts, and service level
agreements.
- 4 years experience in Agile project development including SCRUM, RUP and XP
- Worked in close co-ordination with the testing team in developing test plan and test cases from functional and
business requirements.
Technical Skills:
2
Work Experience:
Zebra Technologies, Vernon Hills, IL Nov’05-Present
Tech Lead & Business/Technical Analyst
Zebra delivers innovative and reliable bar code, RFID and specialty printing solutions to businesses and
governments in 100 countries around the world.
Environment: Oracle, Java/J2EE, C, C++, SQL/MYSQL, Visual Basic, .NET, Crystal Reports, Cognos, ETL,
Informatica, Oracle Applications, Rational Suite.
- Worked with multiple business groups: Finance, Purchasing, Pricing, Marketing, and Sales on enterprise wide
costing applications, while managing business vision and deliverables.
- Managed a detailed survey, analyzing business processes at various levels in the truck manufacturing process.
- Upgraded the Enterprise Data Warehouse to store various data components associated with
manufactured/ordered vehicles, to provide better search and reporting capabilities.
- Managed multiple projects, involving offshore teams and 3rd party vendors.
- Focused on feature/use case based development and minimizing project payback time.
3
- Identified process/information gaps in the current financial, sales and pricing processes, writing
recommendations, and driving complex requirements for enhancements.
- Created project charter, WBS, project management plans, scope statements, work initiation document,
process flow, and DFD.
- Involved in the ERP selection process and conducting POC on various solution options.
- Led an analysis on ‘AS IS’ Vs. ‘TO BE’ (Gap Analysis) to drive business requirements and involving various
stakeholders: business sponsors, business users, and IT managers.
- Saved $300K while conducting in cost benefit analysis from the perspective of various business units as well as
enterprise wide.
- Maintained data under SOX/SAS 70 Audit Compliance.
- Provided business analysis during full implementation of Oracle 12i.
- Provided technical assistance in implementing Oracle 12i - specifically in HR modules.
- Provided business & technical analysis with setup of ADP with Oracle HR.
- Provided technical assistance in migrating existing Data to Siebel (CRM & UCM)
- Provided technical assistance in implementing Business Systems.
- Assisted with review and evaluation of proposed upgrade of Zebra’s business systems and related applications.
- Interacted with the Subject Matter Experts (SME) and stakeholders to get a better understanding of client
business processes and gather business requirements
- Facilitated Joint Application Development (JAD) sessions for communicating and managing expectations
and to discuss the different ways and means for the integration of Rational tools with the current system using
an “adoption through execution” strategy.
- Used Oracle Forms & Reports to create variety of forms & reports for business to use.
- Developed & maintained functional design documents MD-50’s.
- Developed & maintained technical documents (MD-70/71, MD-120).
- Created & Maintained Zebra Printers firmware programs to be downloaded from the website.
- Created Use Case diagrams using UML and Business Process Models using MS-Visio.
- Developing SQL test scripts according to ETL specifications.
- Validating source to target mapping using Informatica.
- Used Informatica to Extract, Transform and Load data from legacy systems.
- Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for
the change in the proposed system.
- Maintained documentation using MS SharePoint (Project Plan, MD-50’s. MD-70’s/71’s, Test Plans,
Calendars).
- Designed Web pages used with Java/JSP scripting interacting with database in order to retrieve and store
information.
- Performed as a Tech Lead on various projects designing, developing & implementing the processes.
- Lead onsite & offshore team through development.
- Converted Business Requirements Documents to Technical Design, distributed the work to developers,
updating the project plan and ensured delivery of project on budget and on time.
- Assisted the development team if necessary using J2EE, Spring2, JSF frameworks.
- Maintained Zebra homegrown applications using C/C++.
- Designed and Create Web Services (Outbound/Inbound) to transfer data from one platform to another.
- Designed BPEL Processes for specifying Interactions with Web Services.
- Managed Oracle, MY/SQL Server databases using PL/SQL (packages, functions, procedures, triggers,
cursors).
- Maintained & Created Shell Scripts to automate processes using UNIX.
- Developing and updating test plans, test cases and executing SQL test scripts for source to target mappings.
- Performed integration and functional testing using Mercury Quick Test Pro 9.0.
- Performed automated smoke testing using Mercury Quick Test Pro.
- Identified Critical Failures in the application and automated those scenarios for automated testing.
4
- Performed defect tracking and reporting to improve communications and reduce delay, using JIRA.
- Performed data validating using SQL scripts.
- Worked independently and in small teams to add new features and functionality to Zebra’s internal applications
- Used CVS for the content management.
- Assessed work & met deadlines; raised issues; developed alternatives and drove to closure.
Interwoven, Inc, Chicago, IL May’05-Nov’05
Technical Consultant
Environment: Oracle, Interwoven, Java, Websphere, RAD, SQL Server.
Interwoven is the Recognized Leader in Enterprise Content Management Solutions for Business
- Lead the development team in implementation of MVC architecture using Struts, Spring2,
XSL/XPath, Hibernate3
- Consultative post-sales role with customers regarding solutions, configurations and software development.
- Managed Oracle, SQL/ MYSQL Server databases using PL/SQL (packages, functions, procedures, triggers,
cursors).
- Worked with Systems Architect and Project Manager to ensure successful product rollout.
- Assisted PM in managing defect priorities.
- Worked with customer and Interwoven partner to provide a solution to the customer's problem(s).
- Responsible for preparing the Software Requirement Specifications (SRS) document, Standard Operating
Procedures, Functional Specification Document (FSD).
- Provided customers and prospects with service, support, problem solving and escalation.
- Interacted with R&D and Product Support to provide feedback and gain knowledge of current and future
products and services offered by Interwoven.
- Converted Data from DocsOpen to Interwoven for smoother transition.
- Wrote and executed SQL queries to verify and validate the data.
- Used RAD5 as IDE and WebSphere5.1 for web server.
- Developed test cases using different scenarios to verify that business systems were in compliance with
specifications.
- Executed test cases and tracked defects.
Manitowoc Ice, Manitowoc, WI Feb’05-May’05
Oracle Applications Consultant
Environment: Oracle Applications, SQL Server, Java/J2EE, Crystal Reports.
- Worked as a technical consultant implementing Oracle Application Modules 11.5.9 (Service Contracts,
Install Base, OM, INV, BOM, GL, AP, AR,), Discoverer.
- Used J2EE, Servlets and Struts framework in the development of their product.
- Collection, analysis and consolidation of users reporting requirements.
- Interacted with the end user to analyze their requirements.
- Assisted the PM with the product feedback and Functional/Technical Requirements.
- Responsible for handling, installing and effective troubleshooting.
- Created custom folders.
- Created new users and created business areas.
- Involved in upgrade process of discoverer.
- Collected the requirements from the users to develop the reports.
- Granted access and task privileges to the new users in Oracle Applications.
- Developed new reports and exported to other applications and enhancing the reports in those applications.
- Created complex folders and creating Item Classes.
- Involved in techno design documentation of the reports.
5
- Interacted with the users to know the requirement and also train the users.
- Exported the business areas from testing to production environment.
- Involved in training sessions with the users.
- Installed Discoverer on the user machines.
- Granted access permission to business areas.
- Maintained scheduled workbooks.
- Responsible for writing the queries and involved in tuning the queries.
- Involved in training the Super User to create new work sheets using Discoverer.
- Executed SQL queries to validate the data.
Motorola Inc, Schaumburg, IL Jun’04-Jan’05
Oracle Applications Consultant
Environment: Oracle Applications, Java/J2EE, .NET, PL/SQL.
- Worked as a technical consultant implementing Oracle Application Modules 11.5.8 (Service Contracts &
Install Base), Reports 6i & Discoverer.
- Involved in writing the Detail Design Documents for the Customized Reports.
- Designed and developed Custom Report named Statement of Work Report using Reports 6i for Motorola
business requirements using Service Contracts.
- Designed and developed Custom Report named Service Delivery Plan Report using Reports 6i for Motorola
business requirements using Service Contracts. Designed and developed Custom Report named Customer
Support Plan Report using Reports 6i for Motorola business requirements using Service Contracts.
- Developed and Design Numerous Discovere Reports – Product & Profitability Report.
- Developed PL/SQL packages for Articles in Service Contracts Module. This package is developed for
Articles to see if they need to be included in the Statement of Work.
- Developed PL/SQL Procedures to validate if the technology complexity matches according to Motorola
Business Requirements.
- Developed packages to manipulate the data before incorporating it on a report. Used Oracle functionality,
provided in Reports 6i, to manipulate the output according to Motorola Requirements.
- Handled complex Report issues (Formatting, PDF output, Parameters, Exceptions).
- AOL was used for registration of the Reports and Responsibilities were assigned to various users. Concurrent
programs were defined and assigned to request groups.
- Involved in the testing process by running sample data to verify the execution of the reports and documenting
the observations.
Minnesota Power an Allete Company, Duluth, MN Jun’02-May’04
Software Consultant
Environment: Oracle, Java/J2EE, SQL Server, Brio.
- Analyzed Minnesota Power’s business processes and suggested solutions to help increase the efficiency of the
overall process. Designed Web pages used with Java/JSP scripting interacting with database in order to
retrieve and store information
- Worked independently and in small teams to add new features and functionality to Minnesota Power’s internal
applications. Managed Oracle, MySQL/SQL Server databases using PL/SQL (packages, functions,
procedures, triggers, cursors). Created tables and views to develop and enhance internal systems and
customer facing features.
- Reporting & Analysis Service: Used Brio Enterprise to take the data from its source and eventually made it
accessible to information consumers and analysis.
Digiport INC, Duluth MN May’03-Aug’03
6
Software Engineer Consultant
Environment: Oracle, Java/J2EE, C, C++, .NET.
- Designed with Digiport development team a solution to managing digital objects
- Wrote development cycle and schedule for solution deadline
- Coached software programmers in time management and solution efficiency.
- Designed the Front End of the software using Java, Struts Tiles, CSS JSP and SSL technology. Created
tables and views to develop and enhance internal systems and customer facing features. Designed the Back
End of the software using Java to integrate back end systems with website
I have worked with various other clients as Systems/ Programmer Analyst with similar job duties as stated in above
projects:
Tech Consultant, Information Technology Systems and Services, UMD 2001 to 2004.
Programmer Analyst, Information Technology Systems and Services, UMD Spring, 2002.
7
Contact this candidate