Sr Sql/ Bi Developer/ssis/ssrs/ssas/power Bi Resume
Kansas City, MO
PROFESSIONAL SUMMARY:
- Over 8+ years of professional experience in SQL Server database development, SSIS, SSRS & SSAS. Extensively worked in Production, Test, Development, Replication, Cluster Server Environments & databases as a Developer/ DBA.
- In - depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.
- Excellent experience in developing complex Stored Procedures, Views and Indexed Views.
- Efficient in creating joins and sub-queries for complex queries involving multiple tables
- Valuable experience in creating User Defined Functions and Triggers in observing Business Rules.
- Involved in Database Design, Data modeling, Development, Implementation, ETL(SSIS) and Reporting in SQL Server 2008/2012/2014.
- Expertise in using variables, property expressions, script tasks in SSIS.
- Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
- Expertise in developing application using.NET, C#, SQL Server.
- Experience in creating Jobs, Alerts, and schedule ETL(SSIS) Packages.
- Very good experience in import/export data to Office Share Point 2013.
- Transformed data from various data sources using OLE DB / MS ACCESS connection by creating various SSIS packages.
- Experience in designing Database Models using MS Visio and Erwin.
- Expert in extracting and transforming data using SSIS Import/Export, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP.
- Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS), Crystal Reports, Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
- Strong experience in creating complex reports that use cascaded parameters.
- Very good experience in writing expressions in SSRS.
- Expertise in upgrading or migrating Analysis Services.
- Proficient in building Star schema and Snow Flake schema depending on business requirements in SSAS.
- Experience on working with Multidimensional Expressions (MDX).
- Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
- Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.
- Experience with Database Backup, disaster recovery and Disaster recovery drill.
- Knowledge of DB high availability concepts like MS SQL Clustering, replication and log shipping, DB Mirroring.
- Experience in query optimization, running DB Consistency Checks using DBCC commands.
- Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
- Experience in troubleshooting SQL issues by using SQL Profiler.
- Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
TECHNICAL SKILLS:
SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio
Languages: C, C++, C#, T-SQL.
Operating Systems: Windows 7/8, UNIX
Databases: MS-SQL Server 2016/14/12/08/05
ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)
Scripting: HTML, XML, Shell Scripting, VB Script
Reporting Tools: SSIS, SSRS, SSAS, Crystal Reports, Power BI
PROFESSIONAL EXPERIENCE:
Confidential, Kansas City, MO
Sr SQL/ BI Developer/SSIS/SSRS/SSAS/Power BI
Responsibilities:
- Developed complex programs in T-SQL, writing Stored Procedures, Views, Triggers and Queries with best execution plan.
- Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
- Defined Check constraints, Business Rules and Indexes.
- Worked with Exception handling with @@error and with Try/catch.
- Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
- Configured replication servers and transactional replication between production & standby server for disaster recovery. Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
- Provided day-to-day administration tasks like space and log management.
- Configured MERGE Replication using Snapshot agent and Merge Agent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
- Developed physical data models using ERWIN/ ER Studio and created DDL scripts for database schema and objects.
- Have skillful hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
- Designed and created MDX queries to retrieve data from cubes using SSIS.
- Created Linked Servers to connect OLE DB data sources and providers in SSIS.
- Developed Query for generating drill down and drill through reports in SSRS 2014.
- Uploaded reports on to the report manager and organized them into folders in SSRS.
- Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts in SSRS.
- Used ProClarity for accessing and analyzing cubes and dimensions, and worked on integration of SharePoint with SSRS
- Responsible for scheduling the subscription reports with the subscription report wizard.
- Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Created reports in Power BI portal utilizing the SSAS Tabular via Analysis Connector.
- Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
- Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
Environment: MS SQL Server 2014, Windows 7, MS-Excel, Business Intelligence Development Studio(BIDS), Erwin, MS Visual Source Safe, FTP Communication, MS-Visual Studio, UNIX, XML, XSLT, ADO.Net.
Confidential, Chicago,ILMS SQL Server Developer/SSRS/ SSIS/SSAS Developer
Responsibilities:
- Proficient in Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
- Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
- Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
- Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
- Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
- Created SSIS packages to get data from different sources, consolidate and cleanse the data and merge it into one single source.
- Responsible for ETL operations using SQL Server Integration Services (SSIS) and Worked with users in training and support and also has experience in incremental data loading.
- Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Built SSIS Packages for Processing cubes and Dimensions.
- Developed Custom Sales, Inventory and financial reports for seasonal, quarterly, monthly and weekly using SSRS and also Created SSRS reports for Health Reports.
- Developed various kinds of Tabular, Matrix, Drill-down, Drill-through, Charts, and web receiving reports using SSRS.
- Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
- Responsible for scheduling the reports based on the subscriptions defined.
- Worked with the Planning team to forecast the business requirements.
- Implementation of SQL Server Analysis Services (SSAS), Design/Change/Deploy OLAP Cubes.
- Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
- Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX .
Environment: Microsoft SQL Server 2012, SSIS 2012, SSRS 2012, SSAS 2012, Visual Studio 2012, Microsoft Office Performance Point Server, Planning Business Modeler, Microsoft Office share point 2007, windows 7, .NET Framework, C#.
Confidential, Dallas, TXSQL Server Developer/ DBA, SSRS/ SSIS/ SSAS Developer
Responsibilities:
- Gathered requirement and designed technical document to implement the application.
- Designed and developed data model in SQL Server using Visio.
- Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. Consolidated two databases into one which maintains customer profile information.
- Implemented security for customer information by encrypting sensitive data using SQL Server 2012 encryption. Used AES algorithm for encryption and decryption.
- Created SSIS packages to transfer data from AS/400 to SQL server using different SSIS components and used configuration files and variables for production deployment.
- Extensively used the dataflow task to transfer data from AS/400 to SQL.
- Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
- Used various Control Flow tasks in SSIS like for Each Loop Containers, Sequence container etc. and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
- Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files.
- Created parameters (multi value, hidden, default etc.) for the required fields using the report designer in order to see the dropdowns in the end report in SSRS.
- Used various types of report layout options like charts (bars, lines, pie etc.), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable in SSRS.
- Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
- Worked on storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models in SSAS.
- Created Scorecards based on Key Performance Indicators(KPI’s), and generate KPI Score-card dashboard and pivot tables/charts for decision making, data mining in SSAS
- Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
- Involved in Unit testing and System Testing for the application.
Environment: Windows 7/8, .NET Framework, MS Excel, Microsoft SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2012, Team foundation server (Version Control Systems).
Confidential, Grapevine, TXSQL BI Developer
Responsibilities:
- Export production database backup and import it in UAT and Development Databases Performed manual unit testing when the code is in different stages.
- Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
- Performing query plans and making sure each and every query is using appropriate useful indexes.
- Created ETL to load transactional data to GameStop Data Warehouse and built Analysis Services Database to provide summarized data to Targit Client for dashboards.
- Created Custom Measure groups (Calculated Members) in cube to implement business logic
- Created Scopes in the cube to provide flexibility for users to see revenue in their local currencies.
- Imported data into Performance point server from SQL database through csv files
- Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
- Written custom tasks using C# within SSIS to enhance processing of both Excel and flat-files into SQL Server in Business intelligence studio (BIDS).
- Created SSIS package to get data from share point and load Cubes.
- Deployed SSIS packages with minimal changes using XML configuration file.
- Created the test data to test the performance and functionality of the SSRS Reports.
- Redesigned/ Deployed reports using Reporting Services 2012R2.
- Worked with report manager for deploying the reports across all the environments.
- Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS) Report Builder.
- Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
- Involved in creating windows installer to install the application in SIT/UAT/Production environments.
- Created work flow items in version control system (Visual Studio TFS) to assign work to team.
- Created mail notifications to notify success and error notifications using Sp send dbmail.
- Tuned the performance by making use of clustered and non-clustered indexes.
Environment: Microsoft SQL Server 2012, SSIS 2012, SSRS 2012, SSAS 2012, Visual Studio 2008/2010, Microsoft Office Performance Point Server, Planning Business Modeler, Microsoft Office share point 2007, Targit, windows 2007 vista, .NET Framework, C#, VB, ASP.NET.
Confidential, Wilmington, OHSQL/SSIS/SSAS Developer
Responsibilities:
- Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
- Responsible for creating Databases, Tables, Clustered/Non-Clustered Indexes, Unique/Check Constraints, Views, Stored Procedures & Triggers.
- Monitor SQL Error Logs/Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
- Responsible for optimizing indexes, SQL queries, store procedures to improve the quality of software.
- Scheduling Jobs and Alerting using SQL Server Agent.
- Created the SSIS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server
- Developed packages using SSIS and controlled its execution, by implementing the infrastructure that enables execution order, logging, variables, and event handling.
- Created ETL for data Transfer and Migration.
- Constructing the data flows in a package, viewing the execution progress of the package.
- Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
- Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
- Created dimensions in the performance point server.
- Enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
- Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Environment: SQL Server 2008 Enterprise Edition, Enterprise Manager, ERWIN, UML, MS Project, .NET, C#, ASP.NET, SSIS, SSAS.
Confidential
Software Associate
Responsibilities:
- Participated in the requirements elicitation and technical specification processes.
- Configured SQL Server Environment.
- Experience in mapping multiple related systems.
- Used BCP command line utility to replicate a database.
- Designed Entity-Relationship diagrams and thus the database schema
- Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL..
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005/2008.
- Performed job scheduling in the SQL Server Environment.
- Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
- Developed stored procedures, triggers, row level audit tables in SQL Server.
- Developed cursors and views to improve performance in data transactions.
- Created SSIS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
- Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Conducted data import and export operations using the DTS wizard.
- Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
Environment: MS SQL Server 2005/2008, MS SQL Enterprise Manager, SSIS, DTS, T-SQL, and Windows NT.