OBJECTIVE:

• Seeking a position, which utilizes my experience in database and reporting program.

SUMMARY:

• Collaborates with business partners and development team members to achieve business results.
• Analyzes business requirements and provides feedback to business on reporting projects.
• Builds Crystal reports and related T - SQL stored procedures that are consistent with the objective stated reporting.
• Maintains up to date understanding of SQL and Crystal Reports technology.
• Recommends new reporting and strategies and procedure improvements to the development team.
• Creates test cases for ensuring reports meet stated business objectives. Performs testing on reports before moving into a production environment.
• Works continually on improving performance of queries and reports using industry standard methodologies for SQL generation.
• Ability to define problems, collect data, establish facts, and draw valid conclusions.

TECHNICAL SKILLS:

SKILLS: SQL Server R2, and DB2 building Tables, T-SQL, creating Store Procedures, SQL Services and views (9 years). Crystal Reports (9 years). Cognos Reports (1 year). VBA Application development for Microsoft Excel (4 years).

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA & Crystal Report Developer

Responsibilities:

• SQL Server Database Administrator.
• Upgrade SQL Server R2.
• Build data warehouse design, and clean up Views, and Store Procedures.
• Reduced Nightly operation, and enhance download.
• Convert Old DTS to Stored Procedures, and schedule them to run nightly.
• Upgrade Business Objects XI 3.1 to BI 4.0 platform.
• Working with Business View Manager.
• Working with CMC adding users and group, and schedule reports .
• Upgrade report server from Crystal Business Objects XI to SAP Business Objects Enterprise.
• Convert Old reports to the new Crystal 2011, and build new ones upon request.

Confidential

SAP Crystal Report 2011 Developer

Responsibilities:

• Modifying existing reports on SAP 2011 and develop new reports..
• Create reports from Xml files as a data source.
• Create Views look up from SQL 2008.
• Create BAQ and Report Style from ERP program to call reports.
• Call reports from ERP Ebicor program.

Confidential

SQL Server & Crystal Report Developer

Responsibilities:

• Ran and tested required queries and reports before publishing.
• Created and scheduled a DTS package to run our stored procedures to create the output report tables and regenerate reports automatically.
• Used Merge Join extensively to load the data from production database to operational database and to perform basic de duplication.
• Wrote T-SQL queries, Store Procedures and used them to build faster running report.
• Managing and developing Reporting tool for webs.

Confidential

Crystal Report Developer

Responsibilities:

• Build various reports using Crystal report for international languages use.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using.

Confidential

SQL Server & Crystal Report Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Lead and assisted the decision making team to finalize the crystal products after analyzing their Impromptus reports.
• Experience in SQL Server transforming unstructured data from various data sources using DTS Transformations like Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Developed Financial Reports using Crystal Report 8.5. With on demand sub reports attached to a single report.
• Web-enabled Management reports were created using Crystal Report attached to both SQL Server 2000, And DB2. Reports made use of embedded hyperlinks, charts and cross tab etc.
• Cognos support: Supporting existing reports, changing catalog to extract data from different sources.

Confidential

DBA Assistant

Responsibilities:

• Scheduled tasks to run every day to update changes in the database tables.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Provided back-end support for functional testing and performance testing.
• Performed data analysis and designed source to destination mapping.
• Extracted the data from Excel, Flat Files, OLE DB, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using DTS.
• Extracted the data from Client Access DB2/AS 400 to SQL Server.
• Wrote various stored procedures for generation of Audit reports and used BCP (Bulk Copy Process).
• Created DTS Packages to move data and run SQL Scripts across NT and DB2 .
• Mapping tables between DB2 AS 400 and SQL Server 2000.
• Writing triggers to track changes on tables SQL Server 2000.

Confidential

Programmer Analyst

Responsibilities:

• Several application were developed using: VBA as front end, SQL Server 2000 as back end.
• VBA as front end, DB2 as back end and created a custom-reporting tools using Excel.
• VB6 and VBA Application using Excel as front end, SQL Server 2000 as back end along with VB interface.
• VB6, SQL Server 2000, heavy store procedures and views were created for Crystal 8.5

Confidential

Computer Operations

Responsibilities:

• Working in the MIS department to perform level 1 support to employees.
• Interfaces with different platforms to maintain backup library for HP-UX 9000 Unix, RS6000, AS400, MS Exchange, and Intergraph. Files using TCP/IP (Telnet, FTP) through many systems, using MS SQL 7.0 to import file from AS400, EDI and Paragon.
• Processing company bills, invoices payroll report, plus maintaining performance.
• Process STS orders, update the orders, send EDI orders, process ASN, update store mailing.