Sql Server Quality Assurance
Resume:
MASOOD A. KHAN
**********@***.***
http://www.linkedin.com/in/khanmasood
EXECUTIVE SUMMARY:
• 10+ Years of professional experience in developing reporting solutions for diverse industries.
• Worked extensively in developing and implementing Crystal Reports on Crystal Reports 2008, Business Objects
Enterprise XI R3, XI R2, XI, and Crystal Enterprise 10.0, 9.0 and 8.5.
Business Intelligence Consultant with a skill set of Business Objects XIR3 / XIR2 / XI and Crystal Xcelsius 4.5 - 2008,
Universe Designer, Desktop Intelligence, Web-Intelligence, BO Live Office, Query as a Web Service.
Demonstrated expertise in Reporting Tools including: Crystal Reports 2008/XI, 10, 9, 8.5, Web Intelligence, Desktop
Intelligence, Microsoft SSRS Reporting, Coldfusion Report Builder and MS Access Reports
Worked extensively in developing SQL Stored Procedures, Triggers, Views, cursors, DTS Packages and functions on MS
SQL Server.
• Expertise over preparing report specifications, database designs to support the reporting requirements.
• Highly motivated and adaptable person with an excellent understanding of Project Development &
Management with
outstanding analytical and organisational skills
• Background includes the ability to build solid, long-term client relationship, a commitment to work as a team
player.
TECHNICAL AND PROFESSIONAL SKILLS:
Crystal Reports 2008, XI, 10, 9, 8 .5, 8.0,7.0 ; SAP Business Objects (6.x/XIR2, XI R3.1)
BI & Reporting:
U niverse Designer, Supervisor, Reporter, Desktop Intelligence, Web-Intelligence (WEBi), Info
View, Broadcast Agent, CMC Performance Management, BO Live Office, Query as a Web Service,
Java SDK, BO Auditor, Report Conversion tool and Import Wizard, Crystal Xcelsius 2008, Business
Views, Crystal Dictionary, Crystal Analysis, Microsoft SSRS, ColdFusion MX7 Report Builder.
Languages: Visual Basic 6.0/5.0, VBScript, JavaScript, HL7, XML, Transact-SQL, PL/SQL, Excel Macros,
BASIC & C/C++
Dev. Tools: MS Project, QuickBase, Microsoft SharePoint, MS Visio and Visual SourceSafe.
Databases: Microsoft SQL Server 2005/2000, Microsoft Access, Sybase 11.0 and Oracle 7.x/8i
Internet Tools: ColdFusion MX8, 4.5/4.0, ASP, HTML, IIS 6.0/5.0 and Websphere.
WORK EXPERIENCE:
July 2009 – Present
Health Solutions Plus Inc, Melville NY
Title: Business Objects / Business Intelligence Analyst
Responsibilities:
• Main responsibilities including but are not limited to: Working with HSP’s product data model including
HSP Admin, Meditrec, Uniflow, Perfect Claim, Verifier and designing and developing reports with different
versions of Crystal Reports, Business Objects WEBi Reports, working with MS Reporting Services and
Crystal Xcelsius and Business Objects Universe Designer .
• Designed and developed WEBi and Crystal Reports for different Meditrec modules including: Financial,
Memberships, Groups, Claims, Brokers, and Providers against SQL Server 2008 database. Generated Crystal
Reports for workflow letters and Customized templates for Auditing, Capitation, EOB, Billing checks and
Invoices, Members ID cards, HCFA and other claims.
• Created all above customized letters, Templates, Forms and listing reports features grouping, sorting,
summary operations, sub-reports, parameter passing and simple formulas. Successfully rolled out Live
Office. Created dashboards in the Xcelsius for the executive users. Created various dashboards to displays
utility usage on the area basis and the number of customers with high utility drain. Created critical
visualization using Business Objects Crystal Xcelsius 2008 for the Business Dashboard.
• Created critical visualization using Business Objects Crystal Xcelsius 2008 for the Business Dashboard.
• Assisted in designing complex Universes for Business Objects XIR3 with multiple Contexts to resolve loops
and traps of the schema, Created Prompted and complex objects for excessively easy reporting, Aggregate-
Aware objects for better performance, and multiple hierarchies for effective OLAP functionality, Deployed
Business Objects, created multi Universe and Document domain based repository, created department based
user groups and restricted their access to different BO modules and universes.
• Created automated (LIVE) Xcelsius dashboards from various data sources such as XML and Query as a Web
Service
• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts,
1
Query Prompt and Drill filters. Also used Cascaded Prompts to fulfill complex conditions described by users.
Created Multi tab reports using multiple data providers and applied different Webi functionality such as
hiding and filtering tables based on specific prompt conditions.
• Helped client to setup their BOE Environments to have complete Life Cycle of the Reports and the
Universes.
Published reports into the repository for the test cycles.
• Scheduled the reports on daily run in xls and WEBi instances for the end users.
• Created Ad-hoc Reporting menu in Xcelsius with the use of Opendoc URL call procedure.
• Created repository, using Supervisor, Database connections, Managed user privileges, created users and groups, assigned
rights to users and groups. Import/export of universes in production environment.
Designed complex report using Web Intelligence with several variables, distributed the reports to different users.
Developed and Deployed complex reports. Used multiple data providers, Union, Intersection, minus and aster/Detail,
cross tab, Charts. Designed and developed standard reports and summary reports. Linked reports in Web Intelligence
using OPENDOC functions
Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompt
and Drill filters. Created Slice and Dice, Drill down and Cross Tab reports Webi Reports. Used the formatting options
like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
May 2009 – July 2009
Ryders Health Management, Stratford CT
Title: Business Objects / Business Systems Analyst
Responsibilities:
• Installed ColdFusion Report Builder. Configured RDS Server and Data Sources.
• Assisted in upgrading the Patient Relationship Management Software, a web based ColdFusion Application from
version 4.5 to MX8, which improved the performance and scalability, and easier integration with enterprise IT
environments. Migrating ColdFusion Application server from ColdFusion 4.5 to ColdFusion MX8.
• Converted 70 clinical Crystal Reports 10 to Coldfusion reports using Coldfusion Report Builder. Incorporate
sub-report features and Export reports to PDF and excel formats.
• Designed and Developed new complex professional web based ColdFusion MX reports dynamically within
application by utilizing Cold Fusion Session and Application variables to create user specific reports. Clinical
Reports include Care Plan, Admission Analysis, Discharge Summary, Treatment and Infection Logs, Census,
Nursing & Physician Notes and Credentialing and Privileging Reports.
Unit, functional, performance and regression report testing including creating and updating test scripts. Maintained the
repositories for different environments like Dev., QA and Prod. Servers and regularly synchronized the QA, Dev.
environments with Production reports.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting
department. Assist with training of Ryder’s Health Management’s IT staff to facilitate them after completion of
implementation.
• Created new SQL views and Stored Procedures in SQL Server 2005 for the reports.
• Provided live support to client-specific requirements, tasks, issues & queries related to current upgrade
problems occurs to existing applications. Assists assigned clients with questions/problems relating to new
features in Patient Relationship Management Software including troubleshooting and analysis.
Nov. 2008 – April 2009
Eclipsys Corporation (Premise Corp), Farmington CT
Title: Business Analytics Consultant
Responsibilities:
Business Analyst:
• Assisted in defining strategy for Company’s Business Analytics path.
Assisted the management of the effort to complete Base New Reporting Module.
Defined requirements & make technology decisions regarding advanced analytics offerings.
Helped in completing the requirements for New Reporting Module.
Participated in Development cycle, including shell architecture, report templates, usability, GUI, QA, deployment,
training and documentation.
Defined template of documentation for New Report Module. Managed versions of report module and client base.
Installed, managed and maintained all required software to provide an end-to-end business intelligence solution
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in
understanding the reports.
Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
Created reports in Webi involving objects with complex calculations using various functions.
2
Implemented Row-Column level security to restrict users depending on their privileges.
SQL 2005 Reporting Services (SSRS):
• Install, configure, and develop SQL Server 2000 Reporting Services
Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services.
Perform migration from ASP Reports to SQL Server 2000 Reporting Services.
Architect data solutions to improve performance of SQL Server 2005 Reporting Services.
SQL 2005/2000 Developer:
• Designed and developed new SQL queries, views, functions and stored procedures, loading data into tables from
different data sources.
o Modified existing stored procedures and functions for a report conversion project and transformed reports
from web based ASP pages to SSRS reports.
• Data extraction, transformation and load using structured query language (SQL)
Xcelsius Developer:
• Created several Dashboards for graphical presentation.
Used QaaWS (Query as a Web Service) to feed data into Xcelsius 2008 to show product portfolio.
Created dashboard by using Xcelsius retrieved data from Excel file by using Live Office.
Created complex Xcelsius dash boards to reflect User Adoption Metrics.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
Feb. 2003 – Oct. 2008
Chart Links, New Haven CT
Title: Manager in Business Reporting & Analytics
Responsibilities:
Systems Analyst:
• Projects Coordination.
Analyze operations, procedures and identify problems.
Determine user needs and program functions and steps required to develop or modify computer programs.
Prepare workflow charts of computer programs.
• Analyze, test and upgrade Data Modeling systems.
Crystal Report Team Lead/Developer:
• Established and managed an offshore development team of three members to design and develop Business
Objects reports. The assignment was to get over 300 reports developed through BO XI platform in a short
span of time leveraging offshore team in Asia. Monitored day-to-day progress of the development phase.
• Communicate and correspond with Off Shore Developers for their daily assignments regarding Business Objects
reports, Universe design, SQL Server Stored Procedures/Views/Cursors Script and creating new Crystal reports
with various ODBC.
• Develop creative and complicated reporting solutions to analyze data and created hundreds of professional quality
Reports to meet Chart Links requirement.
• Designed, Created, and Documented customized Web's accessible dynamic interactive Crystal Reports that will
integrate with any extranet, intranet or Internet application.
Created professional web based reports dynamically within applications with Symmetric used complex formulas, totals,
summaries, sub-reports and specified order grouping to display and summarize the skill set statistics.
Involved in all phases of migration from Crystal Enterprise 10 to XI R2.
Evaluated usage of Xcelsius for adhoc reporting.
• Provided cascading prompts in the reports as well as the Universe to create more interactive reports for the
users.
• Trained offshore developers on steps involved in migration of reports from Crystal 8.5 to 9.0 and then 9.0 to
10.0.
• Created sub-reports to enhance the existing capabilities, to drill down summarized reports to a detailed,
composite level and by involving complex sub-report linking scenarios with data accuracy verification, in order
to meet the requirement.
Created Stored Procedures, Views and functions in SQL server for the reports. Used ODBC connectivity to set the data
source in crystal reports. Compiled and distributed the reports across the company.
• Incorporate tables, cross tabs, charts, maps, and Embed hyperlinks, HTML documents within reports also Export
reports to PDF, RTF, HTML, CSV and various data formats.
• Remotely support and trouble shooting for production servers at Client’s hospitals all over USA.
Experience with all the modules of Seagate/Business Objects Crystal reports i.e. Designer, Analysis, Enterprise and
Crystal Dictionary with different database SQL, Oracle MS Access etc on OLTP, OLAP, Analysis services and Data
3
warehouse.
Directly working with the clients, create/modify/troubleshoot Crystal reports based on ODBC, ADO and dynamic XML
dataset generated for Business Activity SQL queries.
Crystal Report Quality Assurance (QA)/Testing:
• Demonstrated success in team management and the development of Crystal reports quality assurance processes
by creating test plans, test cases, test execution, defect reporting & tracking; user training, user guides, online
helps for end-users, structured walkthroughs and various testing plans for deployment and implementation.
Designed, built and implemented defect tracking database in MS Access
Reports testing experience includes various testing methodologies and techniques.
• Worked with clients to customize the reports to their individual business requirements and manage the changes
through the development process.
Put together and managed Crystal Report QA team. Created Unit testing policies using code reviews. Initiated policies
and procedures across development, test, QA and production environments. Test release and conduct acceptance reviews
with end users. Wrote complex specifications and status reports.
SQL 2005/2000 Developer:
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building referential
integrity constraints. Involved in data modeling for the application and created ER diagram using Erwin.
Creating, Analyzing and Implementing SQL scripts of views, stored procedures, cursors, DTS Packages and functions for
multiple databases. Excellent backend skills in creating SQL objects like Tables, Indexes, Triggers, Rules, and user
defined data types. Defined relationship between tables and enforced the referential integrity constraints. Created
Clustered and Non-Clustered Indexes. Implemented database standards and naming convention for the database objects.
Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan and Performance Monitor.
Tuned the SQL queries using SQL profiler. Involved in tuning the database and trouble shooting the problems by using
SQL server profiler. Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler
Developed Database Backup Scripts and automated this process.
Interacting with the users and troubleshooting the problems involved with the development of stored procedures. Created
and maintained users and user groups
• Updating the databases by creating/executing queries, views and stored procedures, loading data into
tables from different data sources.
MS Access Developer:
• Experienced Microsoft Access application developer. Worked on almost all the objects of MS Access
including VBA, Macro, Query, Report, Form, Tables, ODBC Connection, and application level security.
• Migration of an MS Access application to SQL Server 2000. Database redesign and normalization, conversion of
VB code from DAO to ADO, implementation of stored procedures, and other refactoring to maximize the
efficiency of the application while preserving the existing UI.
• Created and maintained an Access database used to consolidate Help Desk ticket & call tracking statistics from
Lotus Note. Used Excel & Access VBA, SQL Server 2005, DOS batch file processing, and Lotus Notes
Scripting.
• Created and maintained an Access database used to consolidate Help Desk ticket & call tracking statistics from
Lotus Note. Used Excel & Access VBA, SQL Server 2005, DOS batch file processing, and Lotus Notes
Scripting.
• Designed and developed Access databases to track patient history, appointment schedules, Fee Ticket Accounts and
billing reports. Tools mainly used to fulfill the task to the desired expectation and specifications. Worked closely
with end users to get the most work done in short amount of time and produce efficient product. .
• Created Access reports dynamically within applications with Symmetric used complex formulas, totals,
Summaries, sub-reports and specified order grouping to display and summarize the skill set statistics.
Data Import Package Developer using SQL DTS & Microsoft EXCEL MACROS:
• Designed and developed customized data import packages for Patient, Physician, Employee, Insurance, and
various types of codes using MS Excel Macros and SQL DTS packages.
Scripted Excel Macros to validate data imported from csv data files and wrote custom SQL DTS Packages and queries to
transfer data from Excel to temporary lookup tables.
• Created SQL stored procedure to perform further data validation, wrote data-verification queries, and scripted
updates and inserts to final database.
Nov. 2000 – Sept. 2002
PRMsoft Inc., Stratford CT
Title: Senior Systems Analyst
Responsibilities:
Crystal Report Developer:
4
• Designed and developed Financial, Clinical, Human Resources and Credentialing & Privileging crystal reports
(Seagate Crystal 8.0 & 8.5) against SQL Server (7.0/2000) database. Created views in SQL server for the reports.
Used ODBC connectivity to set the data source in crystal reports. Compiled and distributed the reports across the
company.
Created views in SQL server for the reports. Used ODBC connectivity to set the data source in crystal reports. Compiled
and distributed the reports across the company.
• Converted complex financial reports out of Legacy System into Crystal Reports, with multiple parameters.
• Unit testing of the reports with all possible parameters and backend data values, comparison results and problem
solution.
Documentation of all phases of report development, versioning, backend databases, tables, fields, parameters and sub
reports.
• Presenting Graphical presentation of reports data different Chart formats (Bar, Line, Pie, 3D Riser, & 3D
Surface)
• Perform all phases of report development life cycle from report requirements gathering to implementation.
• Initiated and introduced the discipline of using views with Crystal Report Designer to improve overall report
performance.
Communicate and correspond with Remote Developers for report problem and debugging.
Cold Fusion Developer:
• Assisted in designing the architecture of the PRMsoft applications using Cold Fusion framework.
• Created and implemented the database driven Menu system to the application.
• Used JavaScript functionality to increase the efficiency of the application.
• Designed and developed the application using SQL Server 7.0 and used more than 100 database Tables, Views
and Stored Procedures into the application.
• Integrate exception handling into the application. Used CFML scripting for server-side processing.
• Designed, Developed, Testing and Production stages with better source Code Control methodologies
Mar. 1998 – Oct. 2000
Advansoft International Inc. Arlington Heights, IL
Title: Senior Software Engineer
Responsibilities:
• Creating and validating Cold Fusion forms using the Cold Fusion Web Application framework.
• Designed, Created and Documented customized dynamic and interactive adhoc Crystal Reports that will integrate
with any extranet, intranet or Internet application. Incorporate tables, cross tabs, charts, maps within reports also
export reports to PDF, CSV, XLS and various data formats.
• Created Crystal Reports dynamically within applications with Symmetric used complex formulas; totals, summaries, sub-
reports and specified order grouping to display and summarize the skill set statistics.
• Designed and maintained MS ACCESS 97 databases. Responsible for running quarterly reports for finance and
accounting. Case history and search engine to produce reports on different category of cases. Data collection from
various sources and importing them into Access tables. Easy to follow user interface.
• Designed adhoc queries and reports, writing complex queries, stored procedures, and code in Ms Access.
• Database design in Sybase 11.0, and MS SQL 7.0. Using SQL Queries for advanced, dynamic interaction with
SYBASE 11.0/SQL 7.0 databases, connectivity was done using Native Drivers/ODBC through Cold Fusion
Administrator. Created database tables enforced referential integrity and prepared user administration.
• Used Stored procedures for fast performance of application.
• Other features of ColdFusion utilized include Mail-based functions using CFMAIL and configured the Verity.
• Porting the content of the site to work to use content management options available in Allaire Spectra 1.0.
EDUCATION:
• Minnesota State University, Mankato, MN. 1991 – 1995
1. Bachelor of Science (BS) Minor: Mathematics
2. Bachelor of Science (MIS) Interdisciplinary with Business
5
Contact this candidate