Sql Server Data
Resume:
Ahmed, Irfan
*******.*****@*****.***
SUMMARY
* Over 9 plus years of Experience in Software Development life-cycle and
implementing Data Warehouse, Business Intelligence, Client/Server
Technologies and E-Commerce Applications for Financial, Insurance,
Banking, and Production systems.
* Experienced in Translating Business needs into end-user reports with
Business Intelligence Tools like Business Objects, Crystal reports and
Crystal enterprise.
* Data warehousing experience in Data Modeling, Data Extraction, Data
Integration, and Data Mining for Decision Support System as a Data
Warehouse Developer using ETL and OLAP tools.
* 3+ years in developing the report architecture as per the requirements
right from blue print design and gathering the requirements from end
users, SME's and Sr. Analyst's
* Strong Experience in Logical and Physical Data Modeling using Erwin
tool including Star Schema and Snowflake Schema, designing of Data
Mart, Fact and Dimension Tables.
* Strong experience in RDBMS (Oracle, SQL Server, and MS Access).
* Excellent in coding using C, C++, ASP, .net, Visual Basic, Java
Script, VB Script.
* Expertise in writing and implementation of the Packages, Triggers,
Stored Procedures, Functions, Views, Materialized Views, Indexes at
Database level and Form level using PL/SQL and Oracle.
* Excellent Programming skills using Shell scripts and PL/SQL for
Automation of ETL process.
* Excellent knowledge in Batch Jobs using UNIX CRON, AWK, UNIX Shell
Script (csh, bash, ksh) and PERL Scripts.
* Good experience especially in the domain areas of E-Commerce and
Client/Server technologies using Visual Basic, ASP, COM/DCOM, XML,
MTS, Developer 2000, MS SQL Server and Oracle.
* Clear understanding of business procedures and ability to work as an
individual and as a part of a team.
* Excellent analytical and logical programming skills with a good
understanding at the conceptual level and possess excellent
presentation, interpersonal skills with a strong desire to achieve
specified goals
TECHNICAL SKILLS
Operating System DOS, UNIX (HP-Unix, Solaris 2.7/2.8, Linux 7.1),
Windows
98/NT/2000/XP, Red Hat Enterprise Linux, AIX
ETL and Reporting Data Integrator XIR2, 3.0, Ab Initio, Business
Objects 4.x/5.0/5.1/XI/XIR2/3.1 R2,Crystal Reports
6.0/7.0/8.0/8.5/9.0/XI, Crystal Enterprise
8.0/8.5/9.0/9.5/XI, Cognos Impromptu 6.0/7.0
Data Modeling Erwin 3.5/4.0
Languages Java, C++, C, C#, SQL, PL/SQL, PERL 5
Web Technologies ASP 2.0/3.0, VB script, JavaScript, JAVA 2.0, EJB,
JNDI, Servlets, JSP, XML, JDBC, Java Beans, HTML,
DHTML, COM, DCOM, MTS, RMI, CORBA
Application/Web Server Tomcat, IIS, BEA Web logic
Databases SQL Server 2005, Oracle 7.x/8i/9i/10g, MS-Access, MS/SQL Server
7.0/2000/Analysis Services/2005, DB2UDB, Red Brick
5.1 and Teradata V2R3/V2R4/V2R5
GUI Tools/ VB.NET, ASP.NET, Visual Basics
5.x/6.0,Developer 2000 (Forms 4.5/5.0/6.0/9i AS,
Reports 2.5/3.0), and Visual Interdev
Enterprise Planning Software Cognos Planning 8.4 FP1
Tractor Supply Company, Brentwood, TN Jan
2008 - Till Date
Business Objects Architect/Administrator/Developer, HyperRoll Administrator
Developer, ETL based Data warehouse Developer
Responsibilities:
* Involved in implementation Business Objects XI 3.1 infrastructure
architecture installation configuration and software delivery to the
business users.
* Played the role of BO Architect/Project Manager of Business Objects XI
3.1 Upgrade from BOXI R2 environment.
* Designed the strategy of migration cut over planning for the BOXI 3.1
Upgrade
* Designed complex Xcelsius 2008 SP3 based Dashboard for deployment over
InfoView
* Xcelisus 2008 Dashboard now forms the cornerstone of Executive
Reporting which report over 6 years of DW data with a small footprint
over CPU and memory
* Involved in installing, configuring and development for HyperRoll
Release 5.1.1 aggregation engine. Streamlined the load processes of
the Hyperroll Environment on a daily/weekly/adhoc basis through the
Enterprise Scheduler.
* Also involved in developing new HyperRoll Definition Files (HDF) for
instant reporting through business objects front end with HyperRoll-
Oracle heterogeneous services.
* Involved in developing and automating jobs through the Enterprise
scheduler in Tidal. The process also involved gathering business
requirements and developing the datawarehouse load process around the
down time designated by business
* Involved in configuring Business Objects Xi R2 environment, also
participated in development of reports on Desktop Intelligence, Web
Intelligence and Crystal Reports XI.
* Primary contact for the Business Objects 3.1 R2 upgrade from the
previous environment. Involved in the process of reviewing the
software with the vendor, arranging a demo with the business team,
procurement, formulating the architecture of the new environment,
installing, configuring and migration from the earlier environment
etc.
* Completed the upgrade of Cognos Planning 7.3 to Cognos Planning 8.4 FP
1 was involved in all tasks right from procurement to final delivery
of the configured software with the migrated libraries to the new
environment while meeting the objectives as defined in the project
plan in the defined timeframe.
* Rated as Tier 1 in the first year for quality and timely delivery of
projects.
* Involved the assessment (both software and business), design,
prototyping, test and delivery of the existing legacy Oracle Forms
application into a Crystal Reports 2008 V2 based application which is
visible both to vendors and to the Support Centers. Estimated users
are about 4000.
* Involved in writing several ETL processes to enable migration and
cleansing of data between POS, SAP, E3-Replenishment, Intactix
(Planogram Design) systems to the Datawarehouse on a
daily/weekly/monthly/adhoc basis based on the requirements using Data
Integrator XI R 2 on both Windows and AIX.
* Also involved in maintenance the legacy datawarehouse process designed
around Oracle 9i, 10 g with Oracle job scheduler. These processes were
automated to an extent using the new development in Tidal Scheduler.
* Involved in training both business users and IT support in the new
tools for automation.
* Was critical in designing a new process for Change Control and IT
Support Ticket management using the Remedy software while working
closely with First Level Helpdesk Support. Helped them get visibility
of the data in a simple dashboard format using Business Objects on the
Remedy Application Database.
* Was also assigned the role of an Administrator for Source Code Version
management System Spectrum for any code moves to production.
* Duties also included being on-call on a rotation basis for any
production related issues.
Environment:
Crystal Reports XI, Crystal Reports 2008 V2, Crystal Enterprise XI,
Business Objects Designer 11.5, XIR2, HyperRoll 5.1.1.1, Central Management
Services, Central Management Console, Import Wizard, BO-XI Query Builder,
Desktop Intelligence, Web Intelligence, BO-XI Instance Manager, PL/SQL,
XML, Windows 2000, Windows 2003 Server, Microsoft Project Server, Oracle
9i,10g, Cognos Planning 8.4 FP1, Data Integrator XI, 3.1, SAP, Business
Objects Enterprise XI R2, 3.1 SP2, Xcelsius 2008, Live Office, QaAWS.
Deloitte and Touch , Harrisburg, PA Oct
2006 - Dec 2007
Sr. Business Objects Administrator & Crystal Reports Developer
Responsibilities:
* Involved in meeting and gathering requirements from clients and
creating Sup-Spec's to be uploaded to e-room a content management
site.
* Involved in maintaining the visual source safe for reporting subsystem
* Involved in maintaining the e-room a share point platform of Microsoft
for content management
* Created complex crystal reports with dynamic LOV's along with complex
sub reports.
* Created complex Desktop Intelligence and Web Intelligence reports
based on business views
* Designed complex linked Universes for Ad hoc reports
* Involved in designing and creating business views with location based
groups to filter user based on their LDAP group association.
* Designed and implemented a normalized method of data population for
easy development of ad hoc reports
* Developed highly complex Stored Procedures, Views and also helped in
performance tuning using an explain plan for better performance.
* Created a Visual Studio .NET 2003 solution to enable an overnight run
of a batch process to run and populate tables used in the reports.
* Involved in scheduling nightly, weekly, monthly run of the batches in
the Dollar universe
* Involved in Repository management and migration across development,
testing and production environments.
* Involved in clustering business objects servers for a failover system
* Working closely with the security team to integrate Site Minder Single
Sign On authentication with Info view.
* Involved in designing change management processes for Rational Clear
Quest administrator around reports testing process
* Also involved in designing pivot table for incident management for
better defect tracking.
Environment:
Crystal Reports XI, Crystal Enterprise XI, Crystal Analysis 10.0,
Business View Manager 11.5, Business Objects Designer 11.5, Central
Management Services, Central Management Console, Import Wizard, BO-XI
Query Builder, Desktop Intelligence, Web Intelligence, BO-XI Instance
Manager, BO-XI Schedule Manager, SQL Server 2005, SQL Server 2000,
Microsoft Visual Source Safe 6.0, Rational Clear Quest, Rational
Requisite Pro, PL/SQL, XML, Visual Studio .Net 2003, Windows 2000,
Windows 2003 Server, Microsoft Share Point Server.
America Online, Herndon, VA Feb
2005 - Sep 2006
Crystal Reports Developer
Responsibilities:
* Design and development of the complete Decision Support System using
Crystal Reports
* Developed various PL/SQL stored procedures, cursors and functions for
data input to the Crystal Reports
* Created complicated formulae and running totals for business measure
calculations based upon various end user requirements.
* Created various reports like the Combined Queries, Drill Down, Cross
Tab, Master Detail to make the reports easier for analysis.
* Generated sub reports, linked and unlinked reports, reports on demand.
* Used prompts to generate Parameterized reports allowing the user to
limit the reports to particular cases.
* Raised report alerts when certain conditions are met as requested by
the user.
* Involved in creating measures and metrics required in Crystal Analysis
Reports (CAR) for slicing and dicing.
* Involved in managing users, groups, folders and published reports
using crystal management console, in exporting and scheduling of
reports using Crystal Enterprise and generated WEB Reports by using
Reporting Portal.
* Exported the reports developed using the Crystal Reports to the
Repository.
* Scheduled the reports, maintained the events, set permissions using
Crystal Management Console.
* Created nested and conditional groups and formatting features in
reports
* Published reports on web using the e-Portfolio to make the reports
available on the web.
* Performed data validation using validate components and Sample
Component
Environment: Crystal Reports 10.0, Crystal Enterprise 10.0, Crystal
Analysis 10.0, Ab Initio Co>Operating System 2.10, Erwin 3.5.2, HTML, VB
6.0, ASP 2.0, IIS 4.0,Oracle 8i/9i, DB2 UDB V8.1, MS Access, SQL Server
2000, ODBC, ADO, SQL Query Analyzer, SQL* Loader, PL/SQL, XML, Sun Solaris
2.8, Windows NT, UNIX
BCBS, Jacksonville, FL May 03 - Jan 05
Crystal Reports Developer
Responsibilities:
* Developed several Complex Reports (include multiple groupings,
drilldowns, parameter fields, formulas and retrieving data from
more than one database) using Crystal Reports.
* Involved in gathering Business Principles and standardization for
reports.
* Worked on complex reports that require running totals, sub-totals, sub-
reports, cross-tab, multiple groups and conditional display of groups,
fields, and messages.
* Created number of formulae, running totals conditional display of
fields for complex calculations and used them in different sub
reports, container reports.
* Created design for running multi flavor reports like - Date,Weekly and
Monthly as well.
* Experience in Data Modeling, Data Extraction, Data Migration, Data
Integration, Data testing and Data Warehousing using Crystal
Reports.
* Involved in the operations for migrating legacy data from old system
to Oracle database.
* Involved integration of reporting portal with the company Intranet.
Involved in creating the custom web pages using HTML, JavaScript,
Visual Basic and ASP.
* Involved in displaying data from legacy systems and relational
databases and also in creating, modifying reports using tables, views,
functions and stored procedures.
* Created and Tuned complex Stored Procedures for faster execution.
* Published reports using Crystal Management Console, in exporting and
scheduling of reports using Crystal Enterprise and generated Web
Reports by using e-portfolio.
* Developed required SQL scripts for database testing using SQL and
PL/SQL. Extensive experience in Database Testing on Oracle.
* Involved in customization of the Web Reporting portal using HTML, Java
Script and ASP.
* Scheduled the report by setting the run-time parameters and charted by
customizing the options.
* Involved in unit testing, Integration Testing and UAT testing of the
crystal reports generated. Developed user guide for the web-reporting
portal.
* Involved in production support and user support for the implemented
reports in production.
* Provided guidance/training to Application Users.
* Prepared timely and accurate financial modeling scenarios to assist
network management with provider network strategies.
* Created detailed analytical information to support critical decision-
making in contract negotiations with providers
* Communicated with various business units to ensure consistency with
enterprise reporting standards and financial goals while utilizing
advanced information access tools and relational database software.
* Worked closely with the Provider Contracting department in assisting
with open negotiations including review of contract terms and
implementation of standard model contract agreements while assisting
network managers in understanding key modeling points, issues, and
financial impact of new legislation.
* Assisted in the preparation and distribution of internal financial
reports, including division reporting.
* Prepared internal supplemental reports for the technology services
companies.
* Prepared and distributed the internal financial reports.
* Participated among cross-functional teams in projects related to
understanding and improving the business and financial performance of
the company.
* Prepared ad hoc supporting documentation for senior financial
management.
Environment: Crystal Reports 10.0/ XI Crystal Enterprise 10.0/XI, Visual
Basic 6.0, HTML, Java Script, ASP 2.0, ODBC, ADO, IIS 4.0,Oracle 8.1.6, DB2
UDB 8.0, SQL Server 2000, SQL* Loader, PL/SQL, Sun Solaris, and Windows
2000
CitiBank, New York, NY
Aug 02 - Apr 03
Crystal Reports Developer
Responsibilities:
* Generated complicated Financials reports using sub reports, developed
parameterized reports and created charts by using Crystal Reports 9.0.
* Developed Reports with parameters, Sub-Reports, cross-tabs and charts
based on Stored Procedures and Queries by using Crystal Reports 9.0.
* Analyzed and created Data Marts, Dimension and Fact Tables according
to the Business Rules.
* Designed measures for OLAP models and followed Star Schema methodology
to organize the data in the Warehouse database.
* Developed portfolio based reports for stocks, securities and
investments.
* Designed and maintained logical and physical enterprise data warehouse
schemas, developed and deployed new data marts along with modifying
existing marts to support additional business requirements.
* Worked on database connections, SQL joins, Loops, Materialized Views,
Indexes, Aggregate Conditions, Parsing of objects and Written PL/SQL
procedures and functions for processing business logic in the database
* Generated reports by using Stored procedures and generated
Parameterized, Drill down reports
* Created report templates, developed Ad-hoc reports, complex reports
(e.g. reports from multiple data sources, drill down capabilities by
using Crystal Reports
* Involved in conversion of Actuate Reports to Crystal Reports
* Generated various reports for Accounting, Budgeting, Revenue analysis
by using Crystal Reports.
* These reports are helpful in capital cost analysis, to track business,
and communicate to capital investment group and to analyze company's
performance.
Environment: Crystal Reports 9.0, Crystal Enterprise 9.0, VB.NET, Oracle
8.1.6, SQL Server 2000, Erwin 3.5, SQL Loader, PL/SQL, Sun Solaris 2.7 and
Windows 2000
FedEx, Memphis, TN
Aug 01 - Jul 02
Crystal Reports Developer
Responsibilities
* Involved in collecting the requirements and writing the specifications
in technical aspects.
* Enhancements to the existing applications written in ASP, SQL Server,
Crystal reports and also new development.
* Working on applications like Distribution center, Options, Sales
Applications, Accounting, Value Creators, Production schedule.
* Worked on about 60 reports developed in crystal reports 8.5 and moving
them to the crystal reports 9.0
* Created tables, views and Store Procedures using SQL server
* Worked as a Crystal report specialist in resolving the issues on the
production and developing new reports.
* Created Reports using formulas, groups, hierarchal, standard and Cross-
tabs.
* Used DTS to import and export data into the tables.
* Loading and extracting the data into multiple tables using the DTS.
* Involved in writing the store procedures and improving the performance
of some procedures to make the reports run faster.
Environment: Crystal Reports 8.5/9.0,ASP, SQL Server 2000, VSS, Windows
2000
Bombay Stock Exchange, Mumbai
Nov 2000 - Jun 2001
Oracle Developer
Responsibilities:
* Responsible for conducting users meeting for business development.
* Responsible for conducting the project kick off meetings between users
and development teams.
* Gather the requirements from the users for the creation of the logical
data model for the data warehouse at data mart level, using data
modeling tools and naming standards.
* Responsible for the analysis of data, planning the physical model for
development.
* Responsible for preparing mapping and data definition documents,
prioritizing business and operational strategies.
* Designing the tables using star and snowflake schema and confirmed
granular dimensions with the FACTS tables.
* Analysis was done using existing transactional database schema and
designing star schema model to support user needs for reporting.
* Involved in conducting the users interviews, business analysis and
documentation for the database design.
* Worked in the Business process of reviewing the data model for the
various data marts
* Responsible to prepare the BA check list for the development, UAT and
Production implementation.
* Worked with business teams to determine the data dependency and data
consistency.
* Creation of mappings using VISO diagrams, Data Modeling for data marts
and transformation rules for ETL process.
* Detail Design for mappings and reusable business process.
* Responsible in the data migration, planning, table space and
interacting with the team for the development, UAT and Production
implementation.
* Responsible to check the post production for ETL scripts and Reports
using Crystal Reports.
Environment: Solaris, Oracle 8, SQL*Plus, PL/SQL, UNIX Shell Scripts,
Crystal Reports, Java, Java Scripts
Contact this candidate