Database Engineer (sql Server/datazen/powerbi) Resume
San Francisco, CA
SUMMARY:
- Around 8+ years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
- Strong technical knowledge in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
- SQL Server 2005/2008/2012/2014 RDBMS database development including T - SQL programming.
- Strong technical skills in writing advanced T-SQL queries with index tuning strategies.
- Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals.
- Performed daily tasks including backup and restore by using SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Working Experience on SQL 2000/2005/2008/ R2/2012/2014 including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
- Unit Testing the SSIS packages with respect to its flow and performance issues.
- Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012/2016 and Transformation.
- Installed patch sets and upgraded Teradata and performed database health checks and tuned the databases using Teradata Manager.
- Experience in working with Pivot Table configuration and manipulation and configuration to VBA scripting
- Experience with VB Script that sets up the Excel spreadsheet in pivot tables .
- Experience in import and export data to Office 365/ SharePoint 2010.
- Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
- Working Experience in creating SSIS packages using Active X scripts with Error Handling.
- Experience in creating Gauge Reports with KPI’s, Report Model and Report Builder 1.0, 2.0.
- Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
- Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
- ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
- Created Interactive reporting basing data from OperationalDataStore(ODS)
- SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
- Developing reports on SSAS & SSRS on SQL Server (2005/2008/2008 R2/2012/2014). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
- Working Experience on slowly changing dimensions
- Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Confidential schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
- Thorough understanding of SQL 2008/2012 Architecture.
- Worked on Data modeling, creating Confidential and snowflake schemas in SSAS.
- Hands on Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R 2/2005/2000/2012 and excellent communication and analytical skills, understands business requirements in various domains.
- Experience in reviewing Business Requirements and Use Case.
- Familiarity with Informatica 9.6.1
- Experience in creating Data Models for the Data Marts and Decision Support Systems
- Experience in writing the batch scripting and SQL CMD
- Domain Expertise in Financial, E-Commerce, Environmental and HealthCare sectors.
- Prepared the project management and technical documentation.
- Savvy with Collaboration tools and Agile/Scrum Development.
- Complete understanding in Database development utilizing SDLC process with technical expertise. And Quick learner of Organization specific SDLC process.
TECHNICAL SKILLS:
SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS,) SQL Server Data Tools (SSDT)
Database: MS SQL Server 2016, 2014, 2012, 2008 R2, 2005, 2000, SQLCMD, Microsoft
Office 2010/2007/2003 , MS: Access, Oracle, SAP ECC, DB2
Language: C+, HTML, XML, TSQL, MYSQL, DHTML, VB.NET, ASP.NET,.NET Frame Work, C#, JavaScript, PLSQL, Shell Scripts
Version Control: SVN, GitHub, TFS
Operating System: Windows XP/NT/ 2000/2003/2008/2008 r2, DOS, Linux
Tools: MS Visio, SAS/Access, CrystaReports 8.5, 10, XI, R2, Business ObjectsMaster Data Services (MDS), OperationalDataStore (ODS)MSOffice 2003/2007/2010 , Tableau, PowerBI, Informatica 9.6.1, Datazen.
PROFESSIONAL EXPERIENCE:
Confidential
Database Engineer (SQL Server/Datazen/PowerBI), San Francisco, CA
Responsibilities:
- Designed and Developed ETL Process using SSIS for integrating SQL Server with Salesforce CRM for Accounts and Orders
- Implemented Bulk and Incremental Load Packages using Bulk, REST and SOAP APIs
- Validated data using SOQL Queries on Workbench
- Generated and migrated Consultant Performance KPI information using TSQL Scripts and SSIS Task Factory components
- Researched and Developed Order Migration Solution using Pragmatic Works Task Factory as well as DB Amp and presented a POC to Business.
- Created a strategy plan for pushing large upstream data cleanups at SQL Server Source to Salesforce using Salesforce Bulk API in parallel mode through Jitter Bit Data Loading Tool.
- Used Master Data Services (MDS) to combine the data from Salesforce CRM and Ecomm applications.
- Built Custom solutions to display reports generated in PowerBI on salesforce using VisualForce pages.
- Researched on Embedded PowerBI to display Customer and related Order information on Salesforce.
- Involved in Designing DataMart & Data Warehouse using Confidential Schema for implementing Decision Support Systems and created the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
- Implemented perspectives and KPI using calculated measures based on requirements for sales teams
- Developed OLAP cubes using SSAS and calculate the metrics that were revealed in the functional analysis
- Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports. Report models and dashboard reports.
- Expert in calculating measures and dimension members using Multi-Dimensional Expressions(MDX) user-defined functions, mathematical formulas
- Created Dashboard pages in Performance point server that use different types of web parts and excel services for reports.
- Developed complex DML scripts to maintain and manipulate the data used by Hybris Framework application
- Monitored ETL jobs using SSIS & Dell BOOMI
- Worked on the Production environment and monitored all the applications performance
- Developed SSRS reports for Pulse application
- Created ETL to integrate Active MQ with SQL Server using SQL Integration Services
- Developed new stored procedures, which are used with API to make the business user GUI user friendly.
- Involved in fine-tuning of database objects and server to ensure efficient data retrieval.
- Worked on Data requests from the sales support team and other teams on the production environment
- Scheduled CronJobs on Linux box using Autosys JIL.
- Migrated the orders flow legacy ecommerce system to new system
- Query Tuning, Optimized queries and monitored server performance.
- Migrated reports from Datazen to SSRS 2016 and Power BI
- Researched on creation of Dashboards using Power BI Desktop Designer.
- Written shell scripts to debug the issues on Dynatrace box.
Environment: MS SQL Server 2012/2014, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS 2016), SQL Server Analysis Services (SSAS), ETL, Dell BOOMI, Splunk, Dynatrace Monitoring, SQL Sentry, Autosys JIL, Dashboards, XML, Power BI, EIS, JSON, Salesforce (SFDC), Hybris 6.0.
Confidential
SSAS Lead Developer (SSIS/SSRS/Data Modeling/SharePoint), San Ramon, CA
Responsibilities:
- Experience in Extract, Transform and Load Process/design, source-target mapping, reviewing, writing, tuning Complex ETL jobs - daily and high frequency.
- SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data
- Mining Models, developing reports using MDX and SQL.
- Worked on Data mashup in tableau.
- Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
- Maintained share point application.
- Migrated data onto share point using SSIS integrated for share point.
- Created roles for end users on share point.
- Exposure to complete development life cycle of Enterprise Data Warehouse design and Development
- Build data warehouse from Operational data store(ODS) and staging data
- Developed data warehouse in start schema, fully participated in Dimension modeling using Kimball model
- Proficiency in writing advanced SQL & PL/SQL programming
- Apply knowledge of ETL tools, business process and source systems to optimize performance of ETL jobs
- Manage workload to deliver according to business priorities
- Developed stored procedures with advanced programming techniques includes minimal logging, accurate execution plans and index seeking methodologies
- Creating & formatting Crosstab, Conditional, Drill down, Top N, Summary, Form, OLAP,
- Sub Reports, Adhoc Reports, Parameterized Reports, Interactive Reports & Custom Reports.
- Involved in physical and logical data modeling using Erwin(ER/Studio) along with the architects
- Deploying SSRS Reports, Dashboards in Share Point for Web based access for multiple end users
- Regular and timely communication of status of projects and issues to management team
- Developing and Extending SSAS Cubes, Dimensions and data source view SQL Server Analysis Services (SSAS) Data Mining Models and Deploying & Processing SSAS objects.
- SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
- Designing and Developing Unified Dimensional Model (UDM) in SSAS to combine data from multiple databases to single model.
Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Sql server Analysis services (SSAS), OLAP, Dashboards, SharePoint 2010, Tableau 9.2/9.3, Visual Basic6.0/VB.net, VB Script
Confidential
Data Modeler / Senior BI / C# Developer, Houston TX
Responsibilities:
- Actively involved in gathering and analyzing the user requirements in coordination with Business.
- Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
- Excellent hands on experience with SQL Server Integration Service (SSIS) and Reporting Services (SSRS).
- Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
- Developed new mappings using Look Up/Aggregation transformations to match the needs of the business case.
- Developed, monitored and deployed SSIS packages.
- Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Implemented Error Handling in SSIS packages and notified process results to various user communities.
- Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Temporary Tables, Cursors and other T-SQL code and SQL joins for applications following SQL code standards.
- Implemented different types of constraints on tables.
- Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
- Automated and enhanced daily administrative tasks including space management, database backup and recovery. Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, Database maintenance Plans and recovery.
- Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)
- Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Deployed reports in to Report Manager.
- Created Ad-Hoc reports using Report Builder.
- Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
- Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
- Experience in Creating Mapping documents (Data Mapping).
Environment: SQL Server 2000/2005/2008 R2/2012,BusinessIntelligenceDevelopmentStudio(BIDS), T-SQL, PL/SQL,SQL Profiler, Report Builder, SSIS, SSRS, SSAS, TFS 2010, Visual Studio 2005/2008/2010 , TOAD, Composite6.0
Confidential
Sr. SQL BI Developer, Teterboro, NJ
Responsibilities:
- Involved in reviewing the Investments application and interacting with business users to understand the user requirements.
- Actively involved in gathering and analyzing the user requirements in coordination with Business.
- Involved in migration of SQL Server 2000 to 2008.
- Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
- Transferred data from various data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005/2008.
- Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
- Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
- Implemented Error Handling in SSIS packages and notified process results to various user communities.
- Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
- Developed, monitored and deployed SSIS packages.
- Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
- Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
- Designed, developed, tested, deployed, supported, maintained and documented reports.
- Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
- Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.
- Optimized the database by creating various clustered, non-clustered indexes and indexed views.
- Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
- Automated and enhanced daily administrative tasks including space management, database backup and recovery. Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, Database maintenance Plans and recovery.
Environment: SQL Server 2000/2005/2008/ 2008R2,BIDS, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, Agile, XML, ER-Win, MS Visio
Confidential
SQL BI Developer (SSIS/SSRS/Crystal Reports), Atlanta, GA
Responsibilities:
- Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
- Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
- Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
- Excellent hands on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).
- Involved in designing cubes in SSAS environment using Snowflake/ and Confidential Schemas.
- Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
- Installation and configuration of SQL Server 2008.
- Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using Sql Server Reporting Services 2008.
- Enhancing and deploying the SSIS Packages from development server to production server.
- Created complex SSAS cubes with multiple fact measures groups.
- Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
- Developed the chart type, Tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
- Used performance Point Services, SSRS, excel as the reporting tools.
- Wrote the expressions in SSRS wherever necessary.
- Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.
- Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
- Migrated Crystal reports to SSRS
- Modifying report content and exporting reports in multiple formats based on the business requirements.
- Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
- Created derived columns on the final fact and dimension tables as per the business requirements.
- Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
- Played a major role in production support of SSAS (cube refresh), SSIS jobs.
- Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Environment: SQL Server 2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, Erwin, MS Project, MS Access 2008 & Windows Server 2008, Oracle, Crystal Reports.
Confidential
SQL Developer, Chicago, IL
Responsibilities:
- Designed and developed Web APIs for the application
- Participated in creating reports that deliver data based on stored procedures.
- Involved in Creation of Dimensions using Confidential and Confidential Schema
- Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
- Experience in creating SSIS packages using dashboard.
- Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
- Back end Experience in MS SQL Server development, writing T-SQL stored procedures, coding, triggers and cursors.
- Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
- ETL capabilities of SSIS were used to define imports of the data, build scheduling packages.
- Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
- Iteration planning for new features and user stories in Agile Development methodology.
- Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).
- Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes.
- Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
- Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
- Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
- Making a Report as per user requirement using MS Reporting Services 2008 (SSRS).
- Created SSIS Packages to migrate slowly changing dimensions.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
- Involved in the tuning of the existing Database Objects.
- Installed and configured SQL Server 2008
- Implemented Change Data Capture.
Environment: SQL Server 2008, SSIS, SSAS, SSRS, OLAP, XML, MS PowerPoint, MS Project, MS Access 2007/2003 & UNIX, .NET, C#, Agile Programming, Oracle
Confidential
SQL Developer /DBA
Responsibilities:
- Created new tables, written stored procedures for Application Developers and some user defined functions
- Created SQL scripts for tuning and scheduling
- Performed data conversions from flat files into a normalized database structure
- Created and managed users, roles and groups and handled database security
- Created Triggers to enforce data and referential integrity
- Defined Check constraints, Business Rules, Indexes, and Views
- Configured Server for sending automatic mails to the respective people when a DTS process failure or success
- Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server
- Data migration (import & export - BCP) from Text to SQL Server
- Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
- Performed development support, document reviews, test plan, integration of the system
- Creation/ Maintenance of Indexes for fast and efficient reporting process
- Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
- Creation/Deletion of Linked Servers
- Managing historical data from various heterogeneous data sources (i.e. Excel, Access)
Environment: SQL Server 2000/2005, T-SQL, PL/SQL, TOAD, Forms 6i and reports 6i.