TECHNICAL SKILLS:

Business Object: R3.3 CMC, Universe Design, Web Intelligent (Rich Client, Infoview), Crystal Report, Xcelsius

JAVA/J2EE: JSP, Servlet, EJB, Web Service, hibernate, struts, Web Services

Programming languages: C, C++, C#, Visual Basic .NET, Java, Pascal

MSSQL: T - SQL, SSRS, SSIS, DTS Packages SQL Server 2000 and SSAS

Data base management: MSSQL, Oracle, Sybase and IBM DB2

Database/System design: UML

SAP BUSINESS ONE SKILLS:

SDK functionalities: SAP-B1 Developer Kit): DI API, UI API, DI Server, Magma, Dot Net (Vb Net, C#)

Reporting tools: CoreSuite, Crystal Report, SQL-B1 query generator

Functional skills: Accounting/Finance, Sales/Purchasing, Inventory, Production and Banking modules

Project Implementation of SAP Business One

Daily maintenance of SQL server, MS SQL backups & third party solutions backups

SQL Language and SAP Business One SQL based techniques (Formatted searches, Transaction notification etc.)

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Database Developer

Responsibilities:

• Wrote T-SQL queries, Store Procedures and functions for ad-hoc reports.
• Designed SSIS Packages to transfer data from legacy to SQL Server and for automation purposes using Business intelligence development studio.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS and Crystal reports.
• Created SQL Job to automate the reports to be run according to the frequency defined before.
• SQL Job monitoring and rerun failed reports.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Monitoring SQL Job agent for re running the jobs ended with failure.
• Data troubleshooting by debugging the script and analyze the raw data to obtain the obtained result and be able to explain it to the program director.
• Worked closely with the program director to discuss the business needs, gather the requirements and write the Business User Requirements.
• Wrote the technical specification for code documentation purposes.

Confidential, Bartlesville, Ok

SQL Server Developer

Responsibilities:

• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Designed SSIS Packages to transfer data from legacy to SQL Server using Business intelligence development studio
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Tools & Technologies: SQL Server 2008-2012 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003, DTS Packages.
• Experience in Microsoft Visual C# and vb.net in script component of SSIS.

Confidential, NYC, New York

MSSQL Developer/ SSIS/SSRS Developer

Responsibilities:

• Involved in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Interacted with the Business Admin and gather the requirements and analyzed & the Project Managers and the Field Managers who would be using the application the most.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Imported data from text files and excel spread sheets into SQL Server 2008r2 database using SSIS package.
• Created and updated complex Stored Procedures, Triggers and User Defined Functions for logical T-SQL implementation.
• Experienced in creating Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Built the SSRS reports from Different Databases like Oracle and SQL Server. Configured and deployed SSRS reports.
• Used SQL Server Analysis Services 2008 for interaction between client application and instance of Analysis Services.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.

Tools: & Technologies: SQL Server 2008 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i.

Confidential, Phoenix, AZ

SAP Business One Technical Developer

Responsibilities:

• Customization of Delta website used by their Technicians on mobile devices to retrieve their scheduled service calls and work orders from their old system (HTML, VB.NET, SQL Server).
• Develop Commission program add-on to manage the commissions of the technicians and develop reports to generate the payroll (SAP Business One SDK, VB.Net, and SQL Server2008).
• Develop an add-on for approval of purchase orders and AP Invoices generation.
• Technical evaluation and workload analysis of various developments.
• Analysis and development of specific solutions for SAP Business One.
• Supervising and maintaining MS SQL backups and SQL servers
• Developing Reports through crystal reports, Core Suite and ad-hoc report with T-SQL

Confidential

Senior SAP Business One and Business Object Developer

Responsibilities:

• Analysis of specific solutions for SAP Business One.
• Mentoring/ training of junior technical consultants.
• Personally initiated SAP B1 solution research ( User tables and fields management Add-on)
• Technical evaluation and workload analysis of various developments.
• In charge of technical specifications, and solution development follow-up.
• Developing Reports through crystal reports, Core Suite and ad-hoc report with T-SQL
• Supervising and maintaining MS SQL backups and SQL servers.