John Developer Email & Phone Number

San Jose, Ca, Us

Responsibilities:• Understanding Customer requirement via interaction and writing functional specification.• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements. • Involved in designing and implementing database applications using MS SQL Server 2008/2012 and Business Intelligence (BI) tools to support transactions and business decision-making.• Developed complex T-SQL code for the application. • Created Stored Procedures, Triggers, User defined Functions, Constraints etc on various database objects to obtain the required results.• Created various database objects such as tables, indexes and views based on the requirement.• Implemented constraints on tables.• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).• Responsible for stylish design layout like Pie charts, Graphs and Linked Reports.• Used various report items like tables, sub report and charts to develop the reports in SSRS.• Created Report Subscription and Data Driven Subscription using SSRS 2012.• Created Sub-Reports, Drilldown-Reports, and Summary Reports in SSRS.• Designed and implemented Parameterized and cascading parameterized reports using SSRS• Adept in creating Reports using SSRS 2008/2005 like drill down, cross tab, matrix style layouts, performance issues handling, Ad-hoc Reporting framework design• Implemented security to restrict the access to users and to allow them to use only certain reports.• Involved in creating Cubes using SQL Server Analysis Services (SSAS).• Monitor and provide support to the application during the testing and production environments

1506 Ma Zaandam, Nl

● Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008R2/2012.● Experience with all phases of software developmentlife cycle (SDLC) and project methodologies. ● Excellent skills in implementing ETL Packages using Data Transformation Services (DTS) and SSIS 2005/ 2008/2008R2/2012.● Migrated DTS packages to SSIS and modified using DTS editor wizard. ● Developed a dashboard solution for analyzing STD statistics by building SSIS 2012 cubes and Tableau● Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.● Worked with the Version control Systems like Team Foundation Server (TFS), Visual Source Safe (VSS).● Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).● Trained and experience in working on Splunk and developing dashboards on Splunk server.● Extensively worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.● Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.● Experience in writing Multidimensional Expressions (MDX) and used the MDX queries in the report generation● Designed and implemented solution to integrate fanatics applications with partner company like GSI,DAX for more than 36 applications.● Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.● Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.