SUMMARY

• Over 2 years of IT experience in Software Design, 发展, 集成, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Worked in all phases of BW/BI full life cycles including analysis, 设计, 发展, 测试, 部署, 后期生产支持/维护, 文档和最终用户培训.
• Strong understanding of project life cycle, SDLC methodologies of Waterfall and Agile.
• Over 1 Years of experience working on Tableau (Desktop, Server).
• Good understanding of Data ware housing, Data modeling (Dimensional & 关系)的概念，如星型模式, Snowflake schema using fact and dimension tables and relational databases.
• Strong hands on experience implementing dash boarding, 数据可视化, and analytics using Tableau desktop and Server.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements. Proficient with MS SQL Server, SSIS, SSRS, SSAS.
• Experience in Data Extraction and Transforming and Loading (ETL) using SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQLServer.
• Extensive experience in Tableau and SSRS for creating Dashboards, stories and published.
• Expertise in generating reports using SQL Server报表服务(SSRS) and MS Excel spreadsheets.
• Programming in SQL Server - Using the stored procedures, 触发器, 自定义函数和视图, 等.
• 强大的SQL Server DDL, DML skills with understanding of writing efficient queries and troubleshooting complex queries.
• Experience in tuning the performance of stored procedures, database activities like maintenance and performance monitoring and tuning using SQL Profiler and other troubleshooting and monitoring tools.
• Expertise in Enterprise Reporting includes generating reports using linked reports, 子报表和筛选器, 图表s in SQL server reporting services (SSRS).
• Experience in developing management reports using SSRS (SQL Server Reporting Services)
• 对技术趋势有很好的理解, architectures and highly motivated to know more about latest technology, 新软件和新产品.
• Team player with good communication and interpersonal skills.
• 查询优化经验,Database Consistency Checks using DBCC Utilities and analyzing the execution plan and index management for better Query Optimization.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non-Clustered indexes on tables.
• Exquisite skills in Creating and scheduling jobs, 警报和操作符与SQL Server代理, 处理数据库的本地备份/恢复, 数据库维护规划.
• Excellent backend skills in creating SQL objects like Tables, 存储过程, 的观点, 索引, 触发器, 规则, 违约, 用户定义的数据类型和函数
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources

技术技能

编程语言: T-SQL, PL/SQL, R Script, Python, Javascript .

RDBMS /数据库: MS SQL Server, MY SQL, PostGreSQL, mongodb

BI工具: SQL Server报表服务(SSRS), SQL Server集成服务(SSIS), SQL Server分析服务(SSAS),Visual Studio, 投标,表9 x / 10.0

版本控制系统: GIT

发行跟踪系统: JIRA

SDLC: Scrum敏捷,

专业经验

保密

Jr. SQL Server开发人员

职责:

• 为建议的数据库创建ER关系图.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• 从事数据仓库的开发工作.
• Implemented the Error handling in the 存储过程 and also Modified existing stored procedures according to the requirement.
• Created data base objects such as tables, views, stored procedures, triggered 等.
• Designed SSIS packages, extracted data from OLTP to OLAP.Creation of SSIS packages to load into data marts.
• 识别并包含报告参数.
• 良好的OLTP数据库知识.
• 下钻工作, 穿透钻取, 参数化, 图表, 仪表, data driven reports using SSRS and successfully deployed on report manager.
• 较强的计算类写作能力, publishing customized interactive reports and dashboards using Tableau server.
• Created bar 图表s, scatter plots, pie 图表s & 参数按所需的功能.
• Developed Tableau data visualization using Pareto's, 组合图, 热点图, 方框图和须状图, 散点图, 地理地图, 交叉选项卡, 柱状图等.
• Generated Tableau dashboards for sales with forecast and reference lines.
• Performed various tasks like creating cubes, task processing and update using SSAS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Developed monthly reports using SSRS to generate drill down, drill through reports.
• Performed data extraction from various data sources (SQL server) and Data loading into target sources using SSIS.
• Created reports using SQL Reporting Services (SSRS) for Customized and Ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Performed database and BI (ETL, OLTP, OLAP, and Reporting) services for various applications.
• Design, 部署, and maintenance of various SSRS Reports in SQL Server.
• Queried against Heterogeneous Data Sources to retrieve records for data loads using SSRS.
• Created 触发器 to enforce data and Referential Integrity.
• Worked on SSRS to generate drill-down, 穿透钻取, 参数化 and ad-hoc reports.

环境: SSMS, SSIS, SSRS, SSAS, MS SQL SERVER 2008 R2, Windows Server .

保密

SQL软件开发暑期实习生

职责:

• 为建议的数据库创建ER关系图.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• 从事数据仓库的开发工作.
• Implemented the Error handling in the 存储过程 and also Modified existing stored procedures according to the requirement.
• Created data base objects such as tables, views, stored procedures, triggered 等.
• Designed SSIS packages, extracted data from OLTP to OLAP.
• Performed various tasks like creating cubes, task processing and update using SSAS.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Developed monthly reports using SSRS to generate drill down, drill through reports.
• Performed data extraction from various data sources (SQL server) and Data loading into target sources using SSIS.
• Created reports using SQL Reporting Services (SSRS) for Customized and Ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Performed database and BI (ETL, OLTP, OLAP, and Reporting) services for various applications.
• Design, 部署, and maintenance of variousSSRSReports in SQL Server.
• Queried against Heterogeneous Data Sources to retrieve records for data loads using SSRS.
• Created 触发器 to enforce data and Referential Integrity.
• Worked on SSRS to generate drill-down, 穿透钻取, 参数化 and ad-hoc reports.

环境: SSMS, MS SQL SERVER 2008 R2, Windows SERVER .