SUMMARY OF PROFESSIONAL EXPERIENCE

• 6 + years professional experience designing, developing and implementing databases, Business Intelligence (BI) solutions for various companies within healthcare and software development industries
• Expert in data warehouse and staging area design and development
• Design , develop and deploy SQL Server Integration Service (SSIS) 2008/2005 packages that extract, transform and load (ETL) data to SQL database, process OLAP cubes, and maintain database
• Create SQL Analysis Service (SSAS) 2008/2005 OLAP Cubes, and define hierarchies, calculations, Key Performance Indicators (KPIs), actions, perspectives, partitions, and security roles
• Write MDX scripts that process cube KPIs, create summarized reports, calculate members , charts, and line graphs
• Employ T-SQL queries to develop stored procedures, indexes, triggers, views and security roles
• Design and deploy KPIs, charts , graphs using SQL Server 2008 Reporting Service (SSRS) tools
• Use SharePoint 2010 - PerformancePoint (MOSS 2010 ) to design user friendly dashboards and hot-link reports
• Extensive skill in administrating and maintaining SQL Server database, optimizing queries, backup plans and recovery
• Architect database systems and an information systems using Unified Modeling Language(UML) tools like use case, sequence diagram, activity diagram, and state chart diagrams
• Experience in providing 24X7 technical support

TECHNICAL SKILL

Database Technology -

SSMS, SQL Server Business Intelligence (BIDS), MDX ,PL/SQL(Oracle), MS Access 2003/2007, XML, DMX

Relational Database programming

User Defined Functions(UDF), Stored Procedures, Views, Indexes

Programming Language -

C++,Visual Basic 6.0

Web Service tools -

SOA(UDDI,WSDL,SOAP),Html, Xhtml, xml, xslt ,xpath ,Php, VB script

Software Engineering Tools

UML,MS Visio 2005/2007,Rational Rose

Server Operating Systems -

Windows Server 2003/2008 Enterprise Editions ,Unix, Cisco IOS

Client Side Operating System -

Windows XP/VISTA/7

Application Software -

MS Office 2010/2007/2003/XP, Power Pivot Excel, MS Outlook

Source /Code Control Tools

-Visual Source Safe 6.0, Microsoft Team Foundation Server(TFS)

LINKEDIN CONNECTION

My BI Portfolio which has some of my works is available at:

WORK EXPERIENCE

Business Intelligence Developer -Consultant
Confidential, Linthicum, MD Jan 2012 -September 2012

• Gathered requirements and designed data marts.
• Designed and created SSIS packages to load data into data mart.
• Developed and deployed analysis service OLAP cube.
• Designed and developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements.
• Analyzed, revised and redesign existing reports.
• Troubleshoot and maintain existing reports
• Designed, created and implemented BI dashboards using SharePoint 2010 (MOSS 2010) ,SSRS and Excel Services.
• Created score cards using MOSS 2010 Dashboard Designer that feature executive summary, by extracting data from SQL Server 2008 OLAP data source and deployed to SharePoint sites
• Created business critical KPIs using the SSAS representing aggregations in various ways- hierarchically and using custom groupings, that the company will use to analyze performance.
• Created MDX queries to create reports, charts and KPIs, calculated members, filters and parameters
• Wrote various types of T-SQL queries, stored procedures and functions. .
• Worked on data cleansing in datawarehose by designing SSIS package (Fuzzy Grouping, Fuzzy Lookup ) , stored procedures and functions

SSRS /SSIS /SSAS Developer -Consultant
Confidential, Linthicum, MD June 2011-Dec 2011

• Design and Create Reports using SSRS 2008
• Write complex Stored Procedures Scripts, User Defined Functions ,Views to generate Reports
• Write MDX queries
• Gather requirements to meet users report need
• Troubleshoot and maintain SSRS Reports, MDX queries, and Stored Procedures, Functions
• Maintain OLAP cube dimensions and fact tables using SSAS 2008
• Maintain SSIS package that populate and process production reports and data warehouse staging area.
• Deploy SSRS reports in production site including SharePoint 2010 and Native Report Server.
• Configuring Report Subscriptions
• Provide Support in Production Environment
• Analyze and provide data to various users using SQL Server 2008 by writing various levels of SQL Scripts, Stored Procedures, and Functions.

Project-Oriented Business Intelligence Masters Program
Confidential, Parsippany, NJ Dec 2010- Apr 2011

• Designed and Implemented a Labor Analysis Business Intelligence solution for a national construction company, AllWorks.
• Used ETL capabilities to import heterogeneous data sources as xls, xml, and csv into SQL Database, validate data quality, build scheduling packages, and define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Analyzed existing requirements of the company and identified functional requirements of a data warehouse - AllWorksDW as fact tables, dimensions including role playing dimensions, and relationship constraints.
• Built the AllWorksDW using T-SQL Scripts.
• Created OLAP cubes, dimensions, and business critical KPIs using the SSAS representing aggregations in various ways- hierarchically and using custom groupings, that the company will use to analyze performance.
• Created MDX queries to process AllWorks Cube, design reports, charts and KPIs, calculated members, filters and parameters.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Designed, created and implemented BI dashboards using SharePoint 2010 (MOSS 2010) ,SSRS and Excel Services producing different summary results based on user view and role membership.
• Created score cards using MOSS 2010 Dashboard Designer that feature executive summary, profitability, machine downtime trends by extracting data from SQL Server 2008 OLAP data source and deployed to SharePoint sites.The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.
• Utilized key product tools include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.
• Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions. Possess solid knowledge of writing, tuning and optimizing T-SQL queries.

BI Support
Confidential, Washington, DC Mar 2009 - Aug 2010

• Designed and developed, SSIS Packages , SSRS 2008 reports and SSAS Cubes
• Wrote Stored Procedures and MDX queries for SSIS packages and Reports
• Provided support for users on SharePoint dashboards and reports
• Designed and deployed packages for Database maintenance using SSIS 2008
• Provided technical support for users as to health applications ,MS Office Suite, etc
• Gathered report requirements
• Installed, configured, troubleshoot and maintained Windows Server 2003/08 in order to support BI activities
• Provided support in production environment
• Worked with Information Systems team to provide support and resolve issues

Database Developer /DBA
Confidential, Dec 2005 - May 2008

• Identified System Requirements, designed and implemented health database, DHIS, in team with Health Systems Analysts, Health Researchers, and Developers.
• Installed and configured SQL server 2005 instances on Server Operating Systems
• Created database, tables and relationship constraints using T-SQL scripts.
• Developed T- SQL stored procedures, functions, according to the specs, joining different tables and views.
• Implemented trigger to maintain data integrity and consistency.
• Installed and deployed the health database at regional health bureau, 24 health centers, and 7 regional hospitals.
• Performed full backups, differential and transactional log backups; Restored them whenever necessary
• Maintained User Databases and System Databases.
• Used SSIS packages to plan and automate backup ,indexing and shrink DHIS database
• Planned and scheduled automated backups & performed recovery.
• Granted and revoked users login and system access
• Provided (24 X7 ) technical support
• Trained health professionals on how to use the DHIS system to generate custom as well as pivot reports

Environment: Windows 2003 Server, MS SQL Server 2005, Visual Basic 6.0, Crystal Report 7.0., Integration Service

Database Engineer
Confidential, Sep 2004 - Nov 2005

• Participated actively in all phases of Issue Tracking Systems (ITS) analysis, design, development and implementation.
• Analyzed functional requirements including datasets and various scenarios as well as non-functional requirements of the ITS
• Designed the ITS using UML tools: to model functions of the system in Use Case; different scenarios using Sequence diagram and the States of issues using state chart diagram
• Created database diagrams, tables according to the system requirement.
• Wrote SQL stored procedure queries including drop and execute statements for Order management, ticket management, and article search modules.
• Designed front end User Interface, and code application using MS Visual Basic 6.0 programming tool
• Developed and maintained technical documentation and operational procedures for areas of responsibility.
• Worked on different departmental remote servers to extract and import data to the ITS using ETL tools.

Environment: Rational Rose, UML, MS Visual Basic 6.0, SSIS, DTS, SAD

EDUCATION

• Masters of Science in Information Systems
• Bachelor of Science, Information Systems