System Analyst - Erp Resume
Gaithersburg, MarylanD
PROFESSIONAL SUMMARY:
- 14 Years of experience in Software Industries and worked on various kind of technologies.
- 9+ Years of experience in SAP Business Objects 4.0,XI 3.1, Crystal Reports 8, 9, XI, 2008,2013 which includes 3 End to End Implementations
- Experience in Business View Manager to implement the Dynamic Prompt in Crystal Report
- Followed SDLC for Implementation and Enhancements.
- Worked and supported in all phases of Development.
- Excellent Knowledge in Implementation of Relational Database and Data Warehousing systems and Data Marts.
- Strong experience in analysis, designing, creating/enhancing Universes and retrieving data from Universes, stored procedures, personal data files and free hand SQL.
- 7+ Experience in VB, ASP, C#, ASP.NET, VB.NET, VB Script, Java Script, and HTML which includes Windows Based application and Intranet based applications development.
- Experience to design, develop and enhancements and test the big web and windows based applications.
- Strong Experience and analysis skills in Oracle, SQL Server, DB2, databases implementations and SQL*PLUS, PL/SQL, Stored Procedures, Views
- Worked on multiple industry verticals such as Consumer Goods, Pharmaceuticals, al, ERP
TECHNICAL SKILLS:
Business Intelligence Tools: SAP Business Objects XI R2/3.1/4.0, Web Intelligence, Universe Designer, WEB Intelligence Rich Client, Crystal Reports 8, 9, XI, 2008/2013, Business View Manager
Operating Systems: UNIX, Windows (3.x, 95, NT, 2000, XP, Windows 7 Enterprise).
Languages: C#, VB, VB.NET, ASP.NET, COBOL, Pro*COBOL
Web Scripting Languages: Java Script, HTML, VB Script
Databases: MS SQL Server 2008, 2005, Oracle 10g, DB2, Oracle SQL Developer
Source Controls Tools: VSS, Borland STAR Team
PROFESSIONAL EXPERIENCE:
Confidential, Gaithersburg, Maryland
System Analyst - ERP
Responsibilities:
- Developed the quality reports and as per the customer standards and covered all the technical challenges.
- Designed the universe and done the unit testing for the universe.
- Creation of Technical/Detailed Design documents for both Universe and Reports.
- Coordinating with various SIT & UAT teams for testing activities.
- Scheduling of the reports based on the user requirements.
Environment: SAP Business Objects XI3.1, Crystal Reports 2008, Business View Manager, Oracle 10g, Oracle SQL Developer
Confidential, Somers, NY
Senior BO & Crystal Report, SQL Developer
Responsibilities:
- Worked with client and analyzed the requirements.
- Created the data model for ERT application usage tables.
- Involved to gather new requirements and build new BO reports and testing.
- Enhanced existing BO reports based on new business requirements
- Involved to fix the bugs in existing BO reports and done the regression testing.
- Involved to design the universe and data model for new BO Ad-hoc and canned reports.
- Created the Technical documents for both Stored Procedures and Freehand SQL of Crystal reports
- Setup the Test Environment for Stored procedures to validate results with old and New Procedures.
- Maintain the release document to migrate the production environment.
Environment: SAP BO BI 4.0, Oracle, DB2, Crystal Reports 2011, Rapid SQL, Notepad++, SQLinForm, WinMerge
Confidential, Plano, Texas
SAP BI 4.0 BI Lead
Responsibilities:
- Coordinate with onsite Team and analysis the requirements.
- Developed the quality reports and as per the customer standards.
- Involved to design the universe and unit testing universe.
- Creation of Technical/Detailed Design documents for both Universe and Reports.
- Coordinating with various SIT & UAT teams for testing activities.
- Scheduling of the reports based on the user requirements.
Environment: SAP Business Objects 4.0, Teradata
Confidential
SAP BO - Senior Developer
Responsibilities:
- Coordinate with onsite Team and analysis the requirements.
- Analyzing the BMC universe and requirement.
- Estimating the report development and prioritizing the tasks for planned activities.
- Creation of Technical/Detailed Design documents for both Universe and Reports.
- Mentoring the team and allocating tasks based on priorities
- Prepared weekly status report and shared same with client/onsite during the status update.
- Overseeing the Report & Universe quality procedures
Environment: SAP Business Objects XI 3.1, SQL Server
Confidential
SAP BO - Senior Developer
Responsibilities:
- Upgraded the Desk I reports to BO XI R3.1 Web I reports.
- Estimating the report development and prioritizing the tasks for planned activities.
- Creation of Technical/Detailed Design documents for both Universe and Reports.
- Unit Testing and System testing
- Overseeing the Report & Universe quality procedures
Environment: SAP Business Objects XI 3.1, Oracle
Confidential
SAP BO - Technical Lead
Responsibilities:
- Understanding and analyzing the requirements.
- Designed the Universe and Developed the WEB Intelligence & Crystal Reports.
- Created QAAWS and integrated with ASP.NET.
- Manage the team and delivered the 30 reports successfully.
- Prepared unit and sit test cases
- Successfully delivered the project with minimal issue
Environment: SAP Business Objects XI 3.1, Oracle
Confidential
Senior Software Engineer
Responsibilities:
- Responsibilities involved for Requirement Analysis.
- Individually worked on 250 Crystal reports and done the required changes.
- Modified the Stored procedure to apply the filter conditions.
- Development and coding
- Unit & System testing
Environment: C#, ASP.NET, Crystal Reports 2008, Oracle, Sybase
Confidential
Senior Software Engineer
Responsibilities:
- Responsibilities involved for Requirement Analysis.
- Development and coding
- Unit & System testing
Environment: C#, ASP.NET, SQL Server 2000, Oracle, Dynamic PDF
Confidential
Senior Software Engineer
Responsibilities:
- Responsibilities involved for Requirement Analysis.
- Development and coding
- Unit & System testing
Environment: VB, ASP, VB.NET, C#, ASP.NET, SQL Server 2000, Dynamic PDF
Confidential
Team lead
Responsibilities:
- Roles as a Team Member & lead
- Responsibilities involved for Requirement Analysis.
- Development and coding
- Unit & System testing
Environment: VB.NET, C#, ASP.NET, SQL Server 2000, Crystal Reports XI
Confidential
Senior Engineer
Responsibilities:
- Key role to manage the customizations of application for various customers.
- Development and Coding.
- Unit & System testing
Environment: ASP, SQL Server 2000, JavaScript, VB Script, Exact SDK, Crystal Reports XI
Confidential
Software Engineer
Responsibilities:
- Prepared the System test cases and executed successfully.
- Analysis and understand the Existing DB2 query’s and replaced the relevant ORACLE Query’s with Pro* COBOL.
- Used the Unix Shell scripts to execute the COBL Coding.
Environment: Micro focus COBOL, DB2, Oracle 9i, Pro*COBOL, IBM AIX
Confidential
Programmer Analyst
Responsibilities:
- Involved the requirement analysis with existing healthcare systems.
- Development and coding with Visual Basic & SQL Server
- Unit & System testing
Environment: VB6.0, ADO, COM+, Crystal Reports, MS SQL Server