SQL Server DBA & Crystal Report Developer Resume - Hire IT People (2024)

We provide IT Staff Augmentation Services!

Sql Server Dba & Crystal Report Developer Resume

0/5 (Submit Your Rating)

Hire Now

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.

    Hire Now

    Report an issue

    Privacy Policy
    Resume Categories
    • .NET Developers/Architects Resumes
    • Java Developers/Architects Resumes
    • Informatica Developers/Architects Resumes
    • Business Analyst (BA) Resumes
    • Quality Assurance (QA) Resumes
    • Network and Systems Administrators Resumes
    • Help Desk and Support specialists Resumes
    • Oracle Developers Resumes
    • SAP Resumes
    • Web Developer Resumes
    • Datawarehousing, ETL, Informatica Resumes
    • Business Intelligence, Business Object Resumes
    • MainFrame Resumes
    • Network Admin Resumes
    • Oracle Resumes
    • ORACLE DBA Resumes
    • Other Resumes
    • Peoplesoft Resumes
    • Project Manager Resumes
    • Quality Assurance Resumes
    • Recruiter Resumes
    • SAS Resumes
    • Sharepoint Resumes
    • SQL Developers Resumes
    • Technical Writers Resumes
    • WebSphere Resumes
    • Hot Resumes

    SQL Server DBA & Crystal Report Developer Resume - Hire IT People (3)

    • Contact
    • Schedule A Meeting
    • Franchise Opportunity
    • Suppliers
    • LCA Posting Notices
    • Hire IT Global, Inc - LCA Posting Notices
    • Electronic PERM posting Notice
    Client Services
    • IT Staff Augmentation
    • Hire Programmers
    • Government Services
    • IT Project Management
    • Industry Expertise
    • Resume Database
    Job Seekers
    • Browse Jobs
    • Upload Resume
    • Employee Benefits
    • Resume Marketing
    • Us Citizens/Green Cards
    • Visa Sponsorship
    • Employer on Record Services (EOR)
    • Forms Checklists
    Visa Sponsorship
    • H1B Visa Transfer
    • E3 Visa Sponsorship
    • TN Visa Sponsorship
    • EB3 to EB2 Porting
    • Green Card Sponsorship

    Loading, Please wait...

    SQL Server DBA & Crystal Report Developer Resume -  Hire IT People (2024)

    References

    Top Articles
    Latest Posts
    Recommended Articles
    Article information

    Author: Frankie Dare

    Last Updated:

    Views: 5866

    Rating: 4.2 / 5 (53 voted)

    Reviews: 84% of readers found this page helpful

    Author information

    Name: Frankie Dare

    Birthday: 2000-01-27

    Address: Suite 313 45115 Caridad Freeway, Port Barabaraville, MS 66713

    Phone: +3769542039359

    Job: Sales Manager

    Hobby: Baton twirling, Stand-up comedy, Leather crafting, Rugby, tabletop games, Jigsaw puzzles, Air sports

    Introduction: My name is Frankie Dare, I am a funny, beautiful, proud, fair, pleasant, cheerful, enthusiastic person who loves writing and wants to share my knowledge and understanding with you.