Technology Lead\msbi Developer Resume
Denver, CO
SUMMARY
- Over 9+ years of experience using Microsoft Business Intelligence (MSBI) Stack, SSIS, SSRS, SSAS/OLAP and Microsoft SQL Server 2005/2008/2008 r2/2012/2014 in various Banking, Finance and Healthcare domains.
- Extensive knowledge and experience in dealing wif Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL.
- Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
- Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using, Data Transformation Services (DTS) and SSIS wif MS SQL 2005/2008/2012.
- Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
- Experienced in migration from SQL Server 2008 to SQL Server 2012.
- Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations and involved in package configurations and deployment process.
- Proficiency in creating different types of reports such as Parameterized, Linked, Snapshot, Cached, Ad-hoc, Clickthrough, Drill-down, Drill-through, Sub reports, and formatting them.
- Experience in creating different data regions such as Table, matrix, List, Chart, Gauge, Map.
- Experience in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
- Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
- Experience in building Star schema and Snow Flake schema depending on business requirements.
- Experience in creating Perspectives, Partitions, KPI’s and Design Aggregations in cubes using SSAS.
- Able to work wif minimal supervision in any collaborative environment.
- Knowledge of Data Warehousing (DW) concepts and Data warehouse applications.
- Has experience in PowerShell scripting.
- Working knowledge in Agile/Scrum Environment and used TFS team foundation server.
- Highly motivated wif an ability to learn new systems and business processes.
- Excellent verbal and written communication skills combined wif interpersonal and conflict resolution skills and possesses strong analytical skills
TECHNICAL SKILLS
Databases: MS SQL SERVER 2014/2012/2008 R2/2005/2000
Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
Database Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Data Tools Enterprise Manager, SQL Profiler, Query Analyzer
Programming Languages: C#,T-SQL, asp.net, HTML, XML
Data Modeling: ERwin, MS Visio, Star, Snow flake schemas
Operating Systems: Windows (XP, 2008 server), Windows 7
MS Office: Word, Excel, PowerPoint
PROFESSIONAL EXPERIENCE
Confidential, Denver, CO
Technology Lead\MSBI Developer
Responsibilities:
- Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
- Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE accommodating complex filters and database links.
- Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
- Extensively used BI tools like Integration service, Reporting Services and Analysis services in MS SQL server 2008R2 and 2012.
- Developed SSIS packages and SSRS reports in SQL Server 2005/2008/ 2008 R2/2012.
- Filtered and cleansed bad data from legacy system using complex Transact- SQL statements in staging area, and implemented various constraints for data consistency.
- Developed Packages using most of the Tasks, Containers, Transformations and Implemented Error Logging using SSIS.
- Strong background in Data Warehousing principles and methodologies.
- Designed different kinds of reports like Linked, parameterized reports and Worked on Drill Down and Drill-through Reports wif different data regions like Tabular, Matrix etc.
- Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
- Created Report Models for building Ad hoc reports using SSRS and deployed reports into SharePoint.
- Created and managed roles for security in Reports.
- Created Cubes wif Star schema in SSAS and developed SSRS reports based on the cubes.
- Worked in AGILE methodology in development of Database Objects in SQL Server 2008R2/2012.
- Worked very closely wif Business Customers, End Users and resolved any business process related issues.
Environment: MS SQL Server 2012, 2008R2, VS2010, Business Intelligence Development Studio (BIDS), T-SQL, XML, SSIS, SSRS, SSAS, OLAP, OLTP, Windows 7, Microsoft Excel.
Confidential - Somerset, NJ
Technology Lead\MSBI Developer
Responsibilities:
- Designed logical and physical model of OLTP database using ER-Win and later forward engineered the physical model to Microsoft SQL server 2008
- Assisted in designing both the relational data warehouse and the staging databases, ensuring the quality and consistency of the data in both repositories.
- Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
- Created various database objects such as tables, indexes and views based on the requirements.
- Optimized several stored procedures using SQL profiler for report latency and fast delivery access.
- Responsible for the architecture, design, development and implementation of SSIS templates and packages.
- Designed and created user based reports, admin level reports against the SSIS logs and report server to monitor the SSIS packages and the reports for the execution time using SSRS 2005 and 2008.
- Optimized SSIS packages for the performance as the high volume data flows were taking more TEMPthan the desired time to execute.
- Created drill down Reports, which gives all the details as per business requirements. Designed and implemented stylish report layouts.
- Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
- Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
- Created OLAP applications wif OLAP services in SQL Server and build cubes wif many dimensions using both star and snow flake schemas.
- Created hierarchies and aggregates that will optimize the analysis against the cubes that uses MDX queries.
- Scheduled and monitored various jobs using the SQL Server Agent like package execution and cube processing as well as notification associated wif each process.
- Created weekly database backup jobs and schedules using SQL Agent.
- Created Logins and server roles.
- Responsibilities include meeting wif users to define business rules and requirements and ensuring proper documentation for all phases of the project.
Environment: SQL Server 2005 Enterprise Edition, SSIS, SSRS, SSAS, XML, T-SQL, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 2008/2005.
Confidential, Merrimack, NH
SQL server Developer\MSBI Developer
Responsibilities:
- Worked on T-SQL skills in creating stored procedure, functions, views, triggers.
- Creating tables wif cluster and non-clustered indexes on columns and created various database objects such as tables, indexes and views based on the requirement.
- Performed security updates for all user types and responsible for Clustering.
- Expertise in Performance Tuning, Index Tuning wizard, maintenance, troubleshooting and Query optimization skills.
- Modified the existing stored procedures to get the new functionality depending on the client requirement.
- Created ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
- Developed the packages wif monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.
- Hands on experience in using different transformations like Script task, Fuzzy Lookup, Derived column, Conditional split, Multicast transformation, Pivot etc., using SSIS.
- Expert in Creating Complex SSIS packages using proper Control and Data Flow elements wif the error handling.
- Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server.
- Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
- Generated various reports wif drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.
- Deployed the SSRS reports in Microsoft office share point portal server.
- Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
- Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs.
- Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
- Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL 2008 databases.
- Experience in working on Agile/scrum.
- Experience wif full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
- Worked wif product development teams and senior designers on complex program designs to develop architectural requirements that meet design and performance requirements
Environment: MS SQL Server 2012, 2008R2, VS2010, Business Intelligence Development Studio (BIDS), T-SQL, XML, SSIS, SSRS, SSAS, OLAP, OLTP, Windows 7, Microsoft Excel.
Confidential
SQL Developer\MSBI Developer
Responsibilities:
- Developing T-SQL queries, triggers, functions, cursors and stored procedures.
- Responsible for logical and physical design of SQL Server databases.
- Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
- Alter the schema for the required objects. Designed and optimized all the SSIS packages.
- Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
- Designed SSIS packages for synchronizing the data between two different servers.
- Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
- Created Ad-hoc reports and cascading reports, Pivot Tables for historical data using SSRS 2008.
- Involved actively as a part of team for collecting and analyzing the needs of end user requirement.
- Generated various reports wif drilldowns, calculated members, and dropdowns from the cubes by connecting to Analysis server from SSRS.
- Generated Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports etc.
- Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy the various report items like charts, maps, images, graphs, tables etc. to the R2 report server along wif the reports.
- Worked wif various Delivery mechanisms of Reports including Email /PDF/Schedules.
- Created subscriptions to provide a daily basis reports.
- Managed and troubleshoot report server related issues.
- Created Dimensions wif the cube wizard and also individually Generated Named calculations and Named queries.
- Involved in defining referenced relationships wif measure group and fact tables.
- Experience in writing PowerShell scripts.
- Performed day to day Database Maintenance tasks - Database Backups, Space Management, and Resource Utilization, responsible for performing object Migration.
- Worked under Team Foundation Server (TFS).
- Created and scheduled jobs for various tasks and also was responsible for maintaining jobs
- Provided on-call support to production system to resolve any issues.
Environment: MS SQL Server 2012, 2008R2, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Business Intelligence Development Studio-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.
Confidential
SQL server Developer\MSBI Developer
Responsibilities:
- Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 wif latest Service Packs.
- Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
- Created various database objects such as tables, indexes and views based on the requirements.
- Responsible for the architecture, design, development and implementation of SSIS templates and packages.
- Designed and created user based reports, admin level reports against the SSIS logs and report server to monitor the SSIS packages and the reports for the execution time using SSRS 2005 and 2008.
- Optimized SSIS packages for the performance as the high volume data flows were taking more TEMPthan the desired time to execute.
- Created drill down Reports, which gives all the details as per business requirements. Designed and implemented stylish report layouts.
- Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
- Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
- Designed the data models to meet the requirements of each report.
- Responsible for the architecture, design, development and implementation of the SSAS 2005/2008.
- Created OLAP applications wif OLAP services in SQL Server and build cubes wif many dimensions using both star and snow flake schemas.
- Created weekly database backup jobs and schedules using SQL Agent.
- Created Logins and server roles.
- Responsibilities include meeting wif users to define business rules and requirements and ensuring proper documentation for all phases of the project.
Environment: MS SQL Server 2008R2, 2008, 2005, SSIS, SSRS, SSAS, XML, T-SQL, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 2008/2005.
Confidential
Business Intelligence MSBI Developer
Responsibilities:
- Responsible for getting, understanding the business specifications, preparing technical specifications.
- Responsible for creating appropriate loaders and relational writes to load the Data using SSIS.
- Involved in migration of DTS packages to SSIS.
- Created jobs for scheduling the SSIS packages.
- Used different transformations like excel source, data conversions, lookup, Merge, Merge Join, OLEDB command, derived columns, OLEDB destination, etc.,
- Designed dynamic SSIS wif C#.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
- Designed multiple reports such as linked reports, sub, drill through and drill down reports depending up on the client’s need.
- Participated in report deployment, report authoring, used conditional formatting to make the reports more user friendly.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Wrote and integrated stored procedures to generate the reports.
- Used various report items like tables, sub report and charts, Graphs to develop the reports in SSRS.
- Multilingual SSRS reports are built based on client specifications
- Fine-tuned the complex database stored procedures and increase performance up to 5%.
Environment: MS SQL Server 2005 Enterprise Edition, SSIS 2005, SSRS 2005, XML, C#,T-SQL, Windows 2000/2003 Advance Server, MS Excel, Visual Studio 2005
