Sr. Bi Developer Resume
WA
SUMMARY:
- Over 7+ years of IT experience in analysis, design & implementation of Business intelligence solutions with Confidential SQL server 2014/2012/2008 R2/2008 in development, Testing & production environment.
- Strong experience with T - SQL(DDL & DML ) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
- Ability to work in all stages of System Development Life Cycle (SDLC).
- Experience in Error handling and debugging coding issues and troubleshoot production problems. Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
- Experience in data warehouse development with Integration Services, Analysis Services, Reporting Services and Report Development using POWER BI tools.
- Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
- Expertise in SQL Server 2005/2008 R2/2012 Reporting Services (SSRS), SQL Server 2005/2008 R2/2012 Integration Services (SSIS) and in SQL Server 2005/2008 R2/2012 Analysis Services (SSAS) in Business Intelligence (BI)
- Hands on experience with performing various SSIS data transformation tasks like Look-up, Aggregation, Merge, Multicast, Conditional Splits and Event Handlers, Error Handlers etc.
- Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
- Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R 2/2012/2014.
- Experience in Managing Security of SQL Server 2005/2008 R2/2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
- Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
- Experience in .NET/C# application development environment to use SQL Server Databases.
- Well-versed in usage of SSIS Control Flow items and SSIS Data Flow items.
- Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
- Good understanding of Confidential Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
- Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
- Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
- Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
- Expert in implementing star and snow flake schema methodologies for design cubes and applying dimensional modeling using SSAS.
- Extensive experience in Designing and Maintaining Data Cubes using ODBC to access data from heterogeneous databases.
- Thorough understanding of creating MDX queries and DAX queries for SQL Server Analysis Service.
- Worked Extensively for Designing, Maintaining and deploying cubes in the data warehouse using SSAS.
- Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
- Strong analytical, problem-solving and communication skills, with particular emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management.
- A strong team player with ability to learn new skills and adapt quickly, highly motivated with excellent interpersonal, communication.
TECHNICAL SKILLS:
Tools: SQL Server Management studio, Enterprise Manager, SQL Profiler, Business Intelligence Development Studio (BIDS), SQL Server Data tools 2012, DTS, Report Builder 9.0,TFS, SharePoint 2007, POWER PIVOT,POWER VIEW,POWER QUERY,POWER BI DESKTOP,COSMOS.
BI Tools: SSIS, SSAS, SSRS, IBM Datastage,IBM Cognos.
Databases: MSSQLServer 2014/2012/ 2008 R2/2008,MSAccess 97/2003/2005/2008, Oracle.
Language: T-SQL, PL/SQL, MDX,DAX, C, VB.net, C# (.NET)
Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.
Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services
Data Modeling Tools: MS Visio/Erwin
PROFESSIONAL EXPERIENCE:
Confidential, WA
Sr. BI Developer
Responsibilities:
- Worked on the dimensional model design (Star Schema and Snow Flake Schema design) by following Kimball methodology for designing the data warehouse and data marts.
- Extract the data from the replicated sql server to report sql server by using SSIS packages.
- Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS Tabular Models.
- Used SSIS packages to load Data warehouse and process the Tabular Models (daily).
- Scheduled a job in SQL Server Agent that runs on daily basis and creates a log file and maintained the Errors in Error log file.
- Extracted large volumes of data from various SQL Server and loaded the data into target data source by performing different kinds of transformations using SQL Server Integration services (SSIS).
- Used Sequence Containers in SSIS to group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow.
- Involved in Analyzing, designing, building &, testing of Tabular Models with SSAS 2012 and in adding calculations and calculated Measures using DAX.
- Implemented Hierarchies in Models and Optimized the Models to deliver better performance by reducing the redundancy in measure groups and combing the measure groups, used surrogate keys to avoid performance issues
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Creating and managing SSAS Tabular models. Creating Dimension Tables and Fact Tables as per the requirement .
- Used Joins and sub-queries for complex queries involving multiple tables from different databases.
- Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
- Created complex Stored Procedures, Tables and other SQL Joins and Statements for Applications by using T-SQL.
- Involved in fixing the bugs and handled the CR (Change Requests) & Interacted with client for the requirement for different CR's.
- Involved in migrating the Excel Power View Reports to POWER BI Designer Reports.
- Responsible for creating the reports based on user requirement in POWER BI Designer (POWER BI Desktop).
- Created KPI's, Scorecard's and Dashboard's using the POWER BI.
- Explored and used many enhancements of Power BI in Current Reports like Content pack and direct connection to databases like SSAS.
- Created Content Pack for the Dashboards and shared to the users so that they can customize the dashboard based on what data they want to see.
- Used Power BI Canvas to customize the colors of visualizations and font.
Confidential, WA
SSAS/SSIS Developer
Responsibilities:
- Worked on the dimensional model design (Star Schema and Snow Flake Schema design) by following Kimball methodology for designing the data warehouse and data marts.
- Used Scope Scripts to generate text files with data from cosmos.
- Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
- Used SSIS packages to load Data warehouse and process the Cubes (daily, weekly) and schedules the packages to run on regular basis (daily).
- Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
- Used Script task in SSIS to write custom code using Vb.net and C#.
- Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012 and in adding calculations using MDX.
- Implemented Attribute relationships, Hierarchies in Cubes and Optimized the Cubes to deliver better performance by reducing the redundancy in measure groups and combing the measure groups, used surrogate keys to avoid performance issues
- Extensively involved in the SSAS storage, partitions, Aggregations and calculation of queries with MDX.
- Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Extensively worked on OLAP cubes using SSAS.
- Used Joins and sub-queries for complex queries involving multiple tables from different databases.
- Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
- Responsible for documentation of system related activities.
- Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
- Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
- Created complex Stored Procedures, Tables and other SQL Joins and Statements for Applications by using T-SQL.
- Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2012 Analysis Services (SSAS) and Power BI for Reporting.
- Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
- Created a Historical Cube Based on user requirements and to process the cube I have created a SSIS Package with some VB.Net Script.
- Performed Many to Many Relationships in Cube.
Confidential, MN
Sr. SQL BI Developer
Responsibilities:
- Created several stored procedures, functions, triggers, views and cursors for building KPIs in dashboard.
- Used sub queries, CTEs, temp tables, while loops, union, SET operators, string functions, error handling and aggregate functions in different queries in SQL Server 2012.
- Used SQL Profiler to detect the problem areas and values being passed in the application to a stored procedure.
- Created SSIS packages to load data from different sources such as Excel, Flat file, DB2 to SQL server 2012 Data warehouse and SQL Server Transactional database.
- Used Control flow tasks such as Execute SQL task, Data flow task, For Each Loop, Sequence container, Execute Package Task, Execute Process task, Script Task, SMTP task and File System Task in SSIS package.
- Used data transformation like look up, Script component, Merge, Merge Join, Multicast, Derived column, copy column, condition split, sort, union all, data conversion, conditional split and row count to clean the data and modify it. Loaded the data in various destination like SQL server, flat file, excel in SSIS package.
- Used C# for reading and writing variable in Script Task of SSIS.
- Improved the performance of SSIS packages by using fast load options, converting the data type at source if applicable, parallel processing, using non-blocking, semi blocking components over blocking components, dropping and rebuilding the indexes during the SSIS package run.
- Ran the SSIS package through SQL job.
- Built MDX queries used in reports of various clients legal related documents using tuples and sets.
- Designed and built SSAS complex cubes which include millions of records which were complex and deployed them.
- Worked on cube partitioning, refresh strategy and SSAS performance tuning.
- Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
- OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
- SSAS, Created relationship in both cube structure as well as in Data Source view. Created relationship like fact, reference, and regular. Used refresh strategy after the modification made to the cube in Data Source view.
- Assigned to roles to particular user to access the SSAS cube. Deployed and processed the cube.
- Created SSRS reports such as drilldown, drill through, sub reports, tabular reports, chart reports, matrix report and document map.
- Created dynamic SSRS reports with the help of parameters which changes according to the user input.
- Created reports based on both cascading and standard parameters.
- Used standard and parameterized parameters in SSRS reports
- Created Group reports as well as controlled the number of records to be displayed in each page according to user.
- Added indicators, document maps to the SSRS reports.
- Created List report, dynamic report and enabling the sorting to the report.
- Exported reports in SSRS to Excel, PDF and word document
- Created Subscriptions for SSRS reports
Environment: MS SQL Server 2008/2012, SSIS 2008 R2/2012, SSAS 2008R2/2012, SSRS 2008R2/2012, T-SQL, VSS, Windows Sever 2008, SQL Server Management Studio, SQL Profiler.
Confidential, MN
Sr. SQL BI Developer
Responsibilities:
- Involved in planning, defining and designing data base using Erwin on business requirement and provided documentation.
- Installed SQL Server 2008 and management tools using SQL Server Setup Program Translating business requirements into technical design specifications. Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server2005/2008.
- Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models.
- Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column.
- Handled slowly changing dimensions to maintain the history of data.
- Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
- Wrote T-SQL queries, stored procedures, and used them to build packages.
- Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
- Created reports to retrieve data using Stored Procedures and parameterization.
- Used SQL Server Reporting Services (SSRS) delivering enterprise, and Web-enabled reporting to create reports that drew content from a variety of data sources.
- Generated sub-reports, drill down reports, drill-through reports and parameterized reports using SSRS.
- Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script.
- Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements. Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
- Created traces using SQL Server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
- Responsible for scheduling the SSIS packages and Jobs. Played an active role in the development of a SQL Server maintenance plan, scheduling jobs, alerts, and troubleshooting.
- Performed daily tasks including backup and restore by using SQL Server 2008 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
Environment: MS SQL Server 2005, MS SQL Server 2008, SSIS, SSRS, DTS, SQL Profiler, Windows XP / NT / 2000/2003, Confidential Access Erwin, MS Office 2003, Excel 2003, C#.
Confidential, New York, NY
SQL BI (SSIS/SSAS/SSRS) Developer
Responsibilities:
- Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2005.
- Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
- Implemented dashboards showing crosstab and tabular and graphical reports
- Implemented medium level complexity tabular and graphical time series and graphical reports
- Created Subscription of Reports in different formats like PDF, excel to be executed automatically on daily, weekly or monthly basis using MOSS ( Confidential Office SharePoint Server) tool.
- Created reports from complex SQL queries and MDX queries.
- Created and implemented the staging database prior to the final data warehouse.
- Involved in Migration of different DTS packages to SSIS packages, with upgraded system
- Created and scheduled SSIS packages to load the data form OLTP source system to data staging environment and then to data warehouse environment.
- Designed the SSIS Package for the Scheduling the task for the different operations like extracting the data, to perform appropriate transformation and Loading purposes.
- Involved in the performance tuning for the OLAP Cube.
- Involved in the SSAS partitions and calculation of queries with MDX, developing reports using MDX and T-SQL.
- Worked on Performance Tuning and other T-SQL actions
- Responsible for maintaining UAT (User Acceptance Testing) and Production environment.
Environment: SQL Server 2005/2008 R2, MS SQL Server Reporting Services 2005/2008 R2, MS SQL Server Integration Services 2005/2008 R2, SQL Server Analysis Services 2005/2008R2, Excel, Acrobat Reader, Confidential Office SharePoint Server.
Confidential
SQL Server Developer
Responsibilities:
- Extensively involved in interacting with the business users and gathering the requirements for the data warehouse.
- Worked on SQL Server Integration Services (SSIS) to integrate and analyse data from multiple heterogeneous information sources.
- Worked with different methods of logging and error handling in SSIS.
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Involved in Database Administration, Management using RDBMS such as SQL Server under WINDOWS environment .
- Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005
- Created ad-hoc reports, drill down, and drill through reports using SSRS.
- Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
- Developed stored procedures and triggers to facilitate consistent data entry into the database.
- Involved in migration of SSRS from SQL 2000 to SQL 2005.
- Building UAT and Test environments using Production backups.
- Maintained system monitoring jobs and provide high availability support.
Environment: Confidential SQL Server 2000/2005, SSIS, SSRS, T-SQL, SQL Profiler, Windows Server 2003.