SUMMARY

• Over six years of experience in working with Business Intelligence and Data Warehousing applications using the Microsoft Technologies such as SSRS and SSIS.
• Expertise in system analysis, multidimensional data architecture modeling, data sourcing, mapping, and development for client/server, multi - tier, web based and corporate BI and data warehousing application for various line of business across multiple domains.
• Experienced in SDLC methodologies such as Prototying, Agile, Extreme, Programming, and RAD.
• Hands on experience in analyzing existing data warehouse and multidimensional structures, for identifying opportunities for redesigning to meet changing business needs.
• Extended used of SQL Datasource, Object Datasource, XML Datasource, VB, XML, HTML, Tables (physical/temp), Triggers (update/insert/delete/instead of), and Indexes (clustered/non-clustered) using T-SQL.
• Experience in migrating data from external system including flat files, excel, MS Access and oracle into SQL Server using SSIS/DTS packages.
• Involved in Designing Developing and Testing of the ETL strategy to populate the data from various source systems.
• Experience in creating and loading cubes from measures and dimension in OLAP environment using SSAS.
• Solid knowledge in complex SSRS reports with multiple charts through functionalities and Sub reports interfacing with MS Excel 2007.
• Experience in Performance Tuning of Data Warehouses including the creation of materialized views, bitmap indexes and partitions.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Solid management skills, demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity, while forming cohesive team environments.
• Analytical thinker that consistently resolves ongoing issues or defects, often called upon to consult on problems that have eluded resolution by others.

TECHNICAL SKILLS

Business Intelligence Tools: SQL Server 2000/2005 (Reporting Services, Integration Services, Analysis Services)

Reporting Tools: SQL Server 2005/2008 Reporting Services, SQL Server 2005 Analysis Services (SSAS), Crystal Reports Xi

ETL Tools: SQL Server 2000 DTS, SQL Server 2005 Integration Services (SSIS)

Data Process and Modeling Tools: Erwin 4.0/3.5, MS Visio 2002/03, UML 2.0, Smart Draw 7

Databases: MySQL, Oracle 10g/9i/8i/8.0, SQL Server 7.0/2000/05/08 , MS Access 97/00/03

Languages: T-SQL, SQL, SQL*plus, PL SQL, Reports 6i/3.0/2.5, Oracle Designer6i, Visual Studio, Visual Basic 6.x, XML, HTML, XML

Operating Systems: Windows 3.X/95/98/ME/NT/2000/XP, Vista and 7, HP-UX 10.6, Red Hat Enterprise Linux

Development tool: SQL, SQL*Plus, SQL Analyzer, SQL*Loader, Query Analyzer, SQL Server’s Show Plan

Office Tools: MS-Project, Smart Draw, MS-VISIO, MS-Excel, MS-Word, MS PowerPoint, MS FrontPage, Adobe Acrobat, Adobe Photoshop

PROFESSIONAL EXPERIENCE

Confidential, Honolulu, HI

SSIS Developer

Responsibilities:

• Updated and installed MS Visio on application server in development and configured MS SQL Server 2008 on application server.
• Gathered requirements from users and interact with business owners and documented them based on functional specification.
• Create mapping document based on VIP records and users requirements.
• Update the user’s access to the PCIS extracts.
• Responsible to ensure the validation of the creating tables, stored procedure, and SSIS packages.
• Developed ETLs architecture via MS SQL Server Integration Services.
• Participate in integration and system testing.
• Documented all the UTP, SSIS packages, SQL and Tidal job schedule.
• Developed SQL agent job in TIDAL scheduler to execute SSIS package.
• Developed and implement FTP server job to move file from server to server.
• Contribute to system architectural design and planning discussions.
• Identify issues and recommend and implement solutions.
• Standard all the procedure of Tidal jobs, SQL Agent job in Run document.

Environment: SQL Server 2008 R2, Windows 7, Microsoft Office, Microsoft Visual Studio 2008/05, Microsoft Access 2007, T-SQL.

Confidential, Hopkinton, MA

Sr. SSIS Developer

Responsibilities:

• Installed and Configured SQL Server 2008 and MS Visio on application server in development and testing.
• Gathered requirements from Sales department and interact with business owners and documented them based on functional specification.
• Scalability of reporting and centralized access to the RSAM report.
• Responsible to ensure the validation of the SSIS packages with the BA, DBAs, QA auditors, and Developers.
• Developed ETLs architecture via MS SQL Server Integration Services.
• Participate in integration and system testing.
• Automating repetitive tasks as needed.
• Contribute to system architectural design and planning discussions.
• Identify issues and recommend and implement solutions.
• Designed, write and implemented reports from SQL Server 2008/Macro building for reporting purposes.

Environment: SQL Server 2008, Windows 7, Microsoft Office, Microsoft Visual Studio 2008/05, Microsoft Access 2007, T-SQL.

Confidential, Appleton, WI

SSRS/SSIS Developer

Responsibilities:

• Responsible to ensure the validation of the reports with the Business Analysts, DBAs, QA auditors, and Developers.
• Performed database management and address internal database configurations (tables, reports) and configurations between systems.
• Primary source of contact for any reporting needs for Confidential IT department and other internal users.
• Support the data warehousing MDM project to facilitate the merger process of regional airlines.
• Responsible for gathered the requirements from the internal users of the Air Wisconsin team to meet their reporting needs and subscribe them with the appropriate authority.
• Developed database objects providing ad-hoc SQL scripts, stored procedures, Functions, and Triggers using T-SQL.
• Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical and free form reports from multiple data sources (relational and multidimensional) using SQL Server 2005 Reporting Services.
• Created reports using SSRS 2005/2008 and deployed them in the production server.
• Used SQL Server 2008 Integration Services to extracted data from flat file, and Excel spreadsheet to transform data and load the result into operational data store (ODS).
• Updates and inserts of records into data warehouse dimension tables using SCD type I, and type II in SSIS.

Environment: SQL Server, Visual Basic, Windows XP, Microsoft Office, Microsoft Visual Studio 2008/05, Microsoft Access 2007, T-SQL.

Confidential, Denver, CO

Database Analyst

Responsibilities:

• Responsible for job flow processes for client data added to the database.
• Enforced data entry guidelines to created consistency among users.
• Performed database management and address internal database configurations (tables, reports) and configurations between systems.
• Make recommendations for upgrading and maintaining software applications.
• Designed, write and implemented reports from SQL Server 2008.
• Performed in-depth diagnosed on abnormal conditions, and use expertise and experience to take corrective action to resolve problem.
• If uncertainty existed about what type of corrective action to pursue, ensure management or more experienced personnel are involved.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Setup and maintain daily, weekly and monthly backups. Restored files at the request of users or management.
• Maintained daily server backups of databases and ensure successful completion.
• Completed any other duties pertinent to the position as assigned by supervisor.
• Maintained confidentiality of proprietary information including HIPAA and patient information.
• Worked collaboratively with help desk staff to address user tickets and time-sensitive technology issues.
• Performed database maintenance.
• Created and implemented design upgrade to database.
• Assisted others in problem resolution and technology troubleshooting on as-needed basis.

Environment: SQL Server, Visual Basic, Windows XP, Microsoft Office, Microsoft Visual Studio 2008, Microsoft Access 2007, T-SQL.

Confidential, Maple Grove, MN

SQL Server/SSIS Developer

Responsibilities:

• Conferred with team leads and users to assist in establishing requirements for new systems, recommend application modifications needed for future releases, make recommendation for process improvement, and provide documentation to corroborate suggestions.
• Successfully migrated old data from legacy systems and external system including text and excel into SQL Server 2005 using DTS, BCP, SSIS and ActiveX scripts.
• Provided technical assistance to computer system users by answering all the questions or resolve application problems for clients in person, via telephone, or from remote locations.
• Investigated open issues using the following tools: SQL Server Management Studio, Visual Basic 6, Visual Basic .Net, Crystal Reports.
• Maintained accurate record of open issues such as created new support cases, collect case details, record actions taken and resolutions, and document communications between users and other support groups.
• Referred major software problems or defective products to vendors or internal level 2 support with detailed information for resolution.
• Documented existing processes for analysis by business analysts.
• Exercised sound judgment about the best way to resolve support issues.

Environment: SQL Server, Visual Basic 6, Visual Basic .Net, Ultra VNC, Crystal Reports, Windows XP, Microsoft Office, Microsoft Visual Studio 2005, Unite test plan creation, Test plan execution, FoxPro.

Confidential, Menomonie, WI

BI Developer

Responsibilities:

• Developed the ER diagram, data normalization, data loading with SQL
• Developed database and data models using Erwin tool and SQL Server 2005
• Strategically designed, coded, and implemented database architecture as well as related monitoring and testing tools for the complete range of the software products.
• Designed and involved in Data Modeling of major table objects.
• Written SQL subprograms i.e. procedures and functions for value calculations.
• Documented designed and development works for the analysis on the impact of education programs.
• Developed and customized the report generation for the business and customer application management purposes.
• Implemented online system for testing documentation, tracking and reporting that provided sharing of test plans/results among team members, reducing testing cycle duration, decreasing testing platform duplication, and improving racking of test areas of proven trouble spots.
• Established standardized testing methodology for unix platform integration, providing well defined testing procedures that allowed to execute testing functions freeing the engineering team to focus on test planning, and problem analysis and resolution.

Environment: UML, ER Win 3.5, MS-SQL Server 2005, SQL, T-SQL, Windows 2000, MS Access, MS Excel

Confidential, Jeffersonville, IN

SQL Developer

Responsibilities:

• Developed the Functional Specifications documentation and the traceability to the corresponding business requirements with Requisite Pro and updated the BRD document.
• Developed business and system use-cases with activity, sequence and class diagrams using UML and corresponding test plans.
• Used Rational Requisite Pro to document organizes, track and manage the evolving requirements.
• Used Vision document as a template to define the feature requirements. Communicated the requirements effectively to all stakeholders.
• Built advance reports such as Cargo Capacity Report and Range of each Transport Reports using report designer in SQL Server 2005 Reporting Services.
• Added drill down ability, totaling, grouping, multi-value parameters, queried data sets, and conditional formatting using IIS function.
• Used SQL Server 2005 Integration Services to extracted data from flat file, and Excel spreadsheet to transform data using data conversion transformation, derived column transformation, lookup transformation and to load the result into operational data store (ODS).
• Used SQL Server 2005 Integration Services using slowly changing dimension (type I, type II, and type III) for updating and inserting of records into data warehouse dimension tables.
• Maintained user/groups access and security permissions in accordance to policies and procedures using Integration Services.
• Worked with SQL Server management Studio to created tables, setup data types assign primary and foreign keys and define cardinalities.
• Participated in designing multi-dimension model (star schema and snowflakes schema), prepared ETL standards.
• Worked with SSMS to managed storage and execution of deployed packages and used the packages as direct data sources for Reporting Services.

Environment: MS-SQL Server 2000/2005 (Integration Services, Reporting Services, Analysis Services), Erwin 4.0, MS-SQL Server 2005, Oracle 9i, MS-Office suite, Rational Requisite Pro, Windows XP.