SUMMARY

• Over 8+ 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.
• Experience in SDLC methodologies such as Prototyping, Agile, Extreme, Programming, and RAD.
• Experience in pulling data from Oracle Database using ETL tools.
• Hands on experience in analyzing existing data warehouse and multidimensional structures, for identifying opportunities for redesigning to meet changing business needs.
• Experience in extensive use of SQL Datasource, XML Datasource, VB, XML, HTML, C#, 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 2003/07.
• 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 2005/08/2012 (Reporting Services, Integration Services, Analysis Services)

Reporting Tools: SQL Server 2005/2008 Reporting Services, Crystal Reports

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

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

Databases: MySQL, Oracle 10g/9i/8i/8.0, SQL Server 11.0/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 Basic 6.x, C#, XML, HTML, XML

Operating Systems: Windows 7 professionals, Windows 3.X/95/98/ME/NT/2000/XP, Vista

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

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

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

SQL Reporting Developer/SSIS

Responsibilities:

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Migrating DTS packages to DTSX using DTSX-change.
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSIS.
• Implemented failure alerts using email in Integration packages.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Created and used extended stored procedure for SQL Server Integration Services.
• Snapshot Replication was been used to synchronize the data between their Different Stores.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS.
• Created jobs, alerts to run SSAS, SSRS packages periodically.
• Created the automated processes for the activities such as database backup processes, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Reporting Services 2008 (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Used DBCC commands to troubleshoot issues related to database consistency
• Scheduled SSIS Package in IBM Tivoli job scheduler.
• Created work flow diagram and database diagram in Microsoft Office Visio 2007.
• Migrated entire 2008 SSIS package to 2012 Microsoft SQL Server Data Tools (SSDT).

Environment: SQL Server 2008, Oracle, MS Access, Excel, Windows Server 2008, Microsoft Visual Studio, MS Visio, MS Integration, and Reporting Services, Management Studio, Oracle SQL Developer, FileZilla, WinSCP, SSDT.

Confidential, Philadelphia, PA

SSIS/SSRS Developer/Analyst

Responsibilities:

• Responsible for developing and managing reports that impact the customer’s experience and improved business results.
• Utilized forecasts to measure accuracy by interval, daily, monthly measures, and headcount expense.
• Updated and configured MS SQL Server 2008 on application server.
• Actively involved as part of a team for gathered requirements from users and interact with business owners and documented them based on functional specification.
• Created mapping document based on call center, PEGA and COMET records and users requirements.
• Evaluated and implemented new methods and techniques for operational improvement and automated migrating data.
• Designed, developed and implemented staging tables, cursor, stored procedure and views using TSQL.
• Updated and loaded data to staging tables to generate reports in Excel.
• Analyzed data using SQL Server and third party software and prepared recommendations and reports to drive high-impact process improvement efforts.
• Designed new extract applications, support applications under development, and customized current applications using SSIS packages.
• Responsible to pull data from Oracle Warehouse to SQL Server.
• Worked with QA team to determine if applications fit specification and technical requirements. Tested and evaluated systems, subsystems, and components.

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

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.
• Actively involved as part of a team for gathered requirements from users and interact with business owners and documented them based on functional specification.
• Created mapping document based on VIP records and users requirements.
• Updated the user’s access to the PCIS extracts.
• Designed, developed and implemented staging tables, stored procedure and views using TSQL.
• Written VB code to date and time stamping which goes to different network folder as well as archiving folder.
• Responsible to ensure the validation of the SSIS packages and TIDAL Job.
• Developed ETLs architecture via MS SQL Server Integration Services.
• Participated in integration and system testing.
• Created Dynamic SSIS packages that a result in flat files/excel on a different time frame based on business requirement.
• Documented all the UTP, overview SSIS packages flow, SQL stored procedure and Tidal job schedule.
• Scheduled the Main Stored procedure on a schedule basis by creating a SQL Server Job agent and also implemented efficient error handling techniques.
• Scheduled SSIS Jobs on daily/weekly/quarterly basis to analyze the data in TIDAL Scheduler environment.
• Developed and implement FTP server job to move file from server to server.
• Contributed to system architectural design and planning discussions.
• Identified issues and recommended and implemented 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.
• Designed, developed and implemented staging tables, stored procedure and views using TSQL.
• Written VB code to date and time stamping which goes to different network folder as well as archiving folder.
• Developed ETLs architecture via MS SQL Server Integration Services.
• Participated in integration and system testing.
• Automated repetitive tasks as needed.
• Contributed to system architectural design and planning discussions.
• Designed, wrote and implemented reports from SQL Server 2008/Macro building for reporting purposes.
• Participated in planning, design, development, and testing the Vmax and VmaxE Data Warehouse/data mart application utilizing used cases and ETL tools to extract data from excel.

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 addressed 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.
• Supported the data warehousing MDM project to facilitate the merger process of regional airlines.
• Responsible for gathering 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).
• Updated and inserted 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 addressed internal database configurations (tables, reports) and configurations between systems.
• Made recommendations for upgrading and maintaining software applications.
• Designed, wrote and implemented reports from SQL Server 2008.
• Performed in-depth diagnosis on abnormal conditions, and used 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 maintained daily, weekly and monthly backups. Restored files at the request of users or management.
• Maintained daily server backups of databases and ensured 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, collected case details, recorded actions taken and resolutions, and documented 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 checking account 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