SUMMARY

• Over 7 years of strong experience in the IT industry as a BI Developer and SQL Server Developer.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2000/2005/2008/2008 R2/2012 and hands on Experience in installing, configuring, managing, 监控和排除SQL Server 2000/2005/2008/2008 R2/2012.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• 对数据仓库方法和概念有较强的了解, including star schemas, ETL processes, dimensional modeling and reporting tools.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• 有使用商业智能开发工作室(BIDS)的经验, Graphical User Interface (GUI) to design SSIS (SQL Server Integration Services) packages for Data Management applications.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expert in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS 2005/2008/2012.
• 精通在门户上创建和部署SSRS报告，以实现用户可访问性.
• 有编写参数化查询以生成表格报表的经验, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, 使用SSRS 2005/2008/2012为报告定义数据源和小计.
• Developed Drill through and Drill down reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• 熟练使用T-SQL开发复杂的存储过程, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Proficient in T-SQL queries DDL/DML
• Having a good knowledge of ActiveX Scripts
• Knowledge of Oracle 10g
• Highly proficient in unit testing skills.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• 高效的升级和迁移SQL Server 2000/ 2005/2008/2012.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, 备份和灾难恢复过程和复制.
• 在团队和独立工作环境中学习能力强，表现良好.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008/2008 R2/2012, MC Access, MYSQL, Oracle 10g

Database Reporting Tools: Microsoft SQL Server 2005/2008/2012商业智能开发工作室(BIDS), Microsoft SQL Server 2005/2008/2012集成服务工具包(SSIS), Microsoft SQL Server 2005/2008/2012 Analysis Services Toolkit (SSAS), Microsoft SQL Server 2005/2008/2012报表服务工具包(SSRS), Crystal Report, Autosys, Sharepoint

Data Modeling Tools: Erwin, VISIO, SQL Profiler, Tableau, Cognos, Cosmos

Programming Languages: C, T-SQL, C#, ASP.NET, PHP, HTML, JAVASCRIPT, Microsoft Visual Studio 2008/2012, Silverlight, JQuery, Informatica

Operating System: Windows 2008/2003 Enterprise, Windows 2000 Datacenter, Windows XP, Vista, Windows Server 2003/2008.

Architecture: 关系型DBMS，客户端-服务器体系结构和OLAP，面向服务的体系结构

Network: TCP/IP, DNS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MS SQL BI Developer

Responsibilities:

• Involved in Planning, 根据业务需求和提供的文档定义和设计数据.
• Used SSIS and T-SQL stored procedures to transfer data from OLAP databases to staging area and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• 负责使用SSRS 2012根据需求创建powerpivot报告.
• 定义报表布局并确定报表生成的数据集.
• 创建不同类型的报告，包括交叉选项卡, Conditional, Drill-down, Sub reports also parameterized reports.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed MDX for cube calculations and KPIs.
• Scheduled the monthly/weekly/daily reports
• Created performance point dashboard
• Developed, 实现和维护各种数据库对象，如存储过程, Triggers, Functions, Indexes and Views.
• Implemented the scoreboard reports
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• 创建了用于对逻辑相关的列类型进行分组和传输数据的包
• Used VSS to store, run, view, 在系统崩溃的情况下，编辑并恢复到设计的不同版本.
• Established the terms and procedures

Environment: MS SQL Server 2012, SQL Server Reporting Services (SSRS 2012), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Erwin, Sharepoint, Tableau

Confidential, NY

MS SQL BI Developer

Responsibilities:

• 参与安装和迁移遗留数据库到SQL Server 2008
• Worked in a group of 4 and got the chance to involve into performing the database administration
• 履行处理小组事务和管理工作的职责
• 收集团队成员的工作并实现最终结果
• Worked on the data warehouse and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• 使用SQL Server Agent将ETL作业设置为每晚在数据集市中运行.
• Created SSIS Packages for Incremental Loading, slowly changing dimensions, data Importing
• 在Drill模式下使用表格、交叉表和图表创建多个报告(SSRS).
• 在SQL Server 2008中设计、部署和维护各种SSRS报表
• Implemented powerpivot reports
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear view of the reports
• Scheduled monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes
• Created cubes and MDX
• 为客户端实现计分板解决方案
• Backing up, restoring system & 其他数据库根据需求，也安排了这些备份.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Erwin, Sharepoint, Cosmos

Confidential, NJ

MS SQL SSIS/SSRS Developer

Responsibilities:

• 收集用户需求，分析设计软件解决方案和数据库.
• 更新功能规格书和技术设计文档.
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, 用于应用程序的视图、SQL连接和语句.
• 使用动态生成的SQL开发T-SQL (DDL, DML)语句.
• Created the codes using XPATH and XSLT.
• 利用ERWIN软件设计OLAP系统，实现数据结构的可视化.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2008.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Improved query performance by cube partitioning.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008.
• 使用SSRS 2008生成每日、每周和月度报告.
• 根据客户需求实现powerpivot报告
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Developed MDX for cube calculations and KPIs.
• 创建并实现了性能点仪表板解决方案
• 使用管理工作室实现物理度量汇总的计算.
• 使用脚本命令识别和定义范围分配.
• At the end created the scoreboard reports
• 定义了与度量组和事实表的引用关系.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• 建立了完善的备份和恢复策略和流程.

Environment: MS SQL Server 2008/2008 R2 Enterprise Edition, MS SSAS 2008/2008 R2, MS SSRS 2008/2008 R2, MS SSIS 2008/2008 R2, Erwin

Confidential, NJ

MS SQL SSIS/SSRS Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2008 with latest Service Packs
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, 为许多应用程序的不同数据加载操作创建了包.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Developed Event Handlers for executing Stored Procedures and storing the rows Inserted, rows Selected, rows Rejected, 在适当的SQL表中行已更新，行未更改
• 在包中使用检查点，使包能够从故障点运行
• 通过调用Parent中的子包来创建包依赖关系
• 使用配置对包进行动态更改
• 已经使用了XML、SQL Server和环境变量等配置.
• 使用默认日志和自定义日志来跟踪包
• 设计、管理和开发星型模式数据市场
• Designed and created OLAP cubes defining the dimensions and relationship between dimensions and measure groups
• Created webpages using Asp.Net and connected it to the database
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosses tabs and charts.
• 为高性能报表构建有效的查询，并将其呈现为HTML, XML, PDF and Excel formats using Reporting Services.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis
• 在SQL Server 2008中设计、部署和维护各种SSRS报表
• Created powerpivot reports
• Developed stored procedures, triggers, views, 以及为数据加载和转换添加/更改表, and data extraction
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, and Implementation
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008/2008 R2, MS SQL Server Reporting service 2008/2008 R2, MS SSIS, T-SQL, Erwin, Asp.Net

Confidential

MS SQL Developer

Responsibilities:

• Upgraded to latest version from SQL server
• 为应用程序开发编写了各种存储过程.
• 调优SQL语句(使用索引)和存储过程
• Replication of data using Transactional method
• Created the Webpages using Asp.Net
• Created connection between the Asp.Net and SQL
• 从文本文件到SQL Server表的数据转换
• 创建约束并验证数据库完整性.
• Designed and implemented data access stored procedures and triggers for automating tasks. Job scheduling and alerts
• Designed and implemented user log in and security.
• Extracted Data from MS Access
• 创建了许多复杂的存储过程/函数，并在矩阵报表中使用它们.
• 为用户创建报告并将其托管在网络上.

Environment: MS SQL Server 2005, T-SQL, SQL Server 2005 Reporting Service, VSS, Windows 2005 Server, Enterprise Manager, Query Analyzer, SQL Profiler, Asp. Net