Sql Developer/msbi Developer Resume
Columbus, OhiO
SUMMARY
- 7 years of SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS), DTS, performance tuning, Designing logical/physical databases and troubleshooting
- Experience in Database Design, Development, Implementation and Support of Microsoft SQL Server 2012/2008R2/2005, MS Access, and Windows 2000/2003/2008
- Good understanding of Normalization /De - normalization, Normal Form and database design methodology
- Solid knowledge of Data Analysis, RDMS, OLTP, OLAP and experience with MS SQL Server in writing T-SQL, SSIS, SSRS
- Working knowledge of Software Development life Cycle (SDLC) and N-tier Application Architecture
- Migrating data from other sources like excel sheet, flat files, Oracle etc.
- Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading
- Experience in Data warehouse created star schema and snowflakes schema data model and fill data using ETL process using SQL server integration Service (SSIS)
- T-SQL coding and testing: Function, Views, Triggers, Cursers, Stored Procedures
- Good knowledge of Data Marts, Data warehousing, and operational data store (ODS), data modeling such as Dimensional, star schema, snowflakes and good understanding of Facts and dimensions
- Experience in calculating measures and dimension members using multi-dimensional expression (MDX), creating data source views, named queries, mathematical formulas and user-defined functions in SSAS, and deploying of analysis services projects
- Hands on experience in Designing and Building the Dimensions and cubes with star schema using SSAS 2008 R2/2012
- Designed, developed and implemented Tableau Business Intelligence reports.
- Experienced in development of Dashboards in Tableau 8/9.1
- Experienced in creating aggregates, charts, hierarchies, filters, quick filters, table calculations in Tableau 8/9.1
- Competent, reliable and committed professional with a proven track record of successful implementations
- Have relevant technical skills, analytical skills, managerial skills, interpersonal skills and organizational skills along with strong verbal and written skills
TECHNICAL SKILLS
Core programming: T-SQL,C#
Databases: Microsoft SQL Server 2014/2012/2008 R2, Microsoft Access
Tools: MS-Office, MS Visio, MS Project, SSIS 2012/2008R2/2005,SSRS 2012/2008R2/2005, SSAS 2012/2008R2/2005Business Intelligence Development Studio, Tableau
Operating Systems: Windows XP/2003/2000
PROFESSIONAL EXPERIENCE
Confidential, Columbus, Ohio
SQL Developer/MSBI Developer
Responsibilities:
- Involved in Analysis, Planning and Defining data based on business requirements and provided documentation
- Created extensive stored procedures and updated tables and trigger as per the changes in the requirement
- Very good T-SQLProgramming skills. Experience in query optimization & performance tuning used SQLProfiler, Execution Plan, Performance Monitor and DBCC Commands
- Created SSIS packages for data conversion using Data Conversion Transformation
- Created package configurations for dynamic connection string to enhance the ease of package deployment, implemented Event Handlers and Error Handling in SSIS packages
- Designed and developed SSIS Packages to import and export data from MS Excel,SQLServer2008 R2 and Flat files
- Created corresponding RDLs by using the stored procedures on New System
- Using SSRS creating well-formed reports and web-based reports for Finance related applications and transactions
- Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS
- Advanced extensible reporting skills using SQL Server 2012/2008 Reporting Services (SSRS)
- Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements
- Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012
- Defined Key Performance Indicator metrics to create scorecards
- Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters)
- Worked on all types of report types like tables, matrixes, charts, sub reports etc.
- Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the ReportServerto reduce the repetition the reports
- Involved in Dimensional modeling by identifying the fact and dimension tables based on the user and reporting requirements
- Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
- Optimized queries by using Execution Plan for better tuning of the database
- Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
- Created aggregates, charts, hierarchies, filters, trend lines calculated measures
Environment: SQL Server 2012/2008/2008 R2 Enterprise Edition, VB Script, ASP.NET,XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Tableau
Confidential, Ann Arbor, MI
SQL Server SSRS/SSIS Developer
Responsibilities:
- Designed SSIS Packages to handle data migration (ETL Processes) from transaction system to dimensional model
- Created the Staging tables, successfully migrated old data from legacy system into SQL Server using SSIS Packages
- Used Sequence Container in Control Flow for linking all dimension tables
- Extensively used SSIS transformations such as Slow Changing Dimension, Lookup, Conditional split, Sort, Merge Join, Aggregate, and Execute SQL task etc.
- Created star schema in SSAS and developed SSRS reports based on the cubes
- Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source Views
- Using SSRS creating well-formed reports and web-based reports for financial applications and transactions
- Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
- Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server
- Scheduled the monthly/weekly/daily reports to run automatically. Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email
- Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the generated reports directly on the client’s workstation
- Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server
- Performed activities like creation and indexing of the tables
- Developing reports on SSRS on SQL Server
- Created Views and Indexed Views to reduce database complexities for the reports
- Enhancing and deploying the SSIS Packages from development server to production server
- Involved in developing test cases for Unit Testing
- Generated tableau dashboards with combination charts for clear understanding.
- Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS) 2005, SQL Server Reporting Services (SSRS) 2005, T-SQL, Erwin Data modeler, Tableau, MS Office, Windows Vista
Confidential, Virginia
SQL Server Developer
Responsibilities:
- Day-to-day Technical Support on MS SQL Server 2012 and 2008 Servers Platform for Production, Test and Development Environments
- Migrated and transferred data from various data sources/business systems including MS Excel, MS Access, Flat files etc to SQL server using SSIS
- Developed data importing processes and designed processes/applications to help increase automation, efficiency, flexibility and extensibility by creating T-SQL Scripts, Stored procedures, functions etc.
- Responsible for scheduling jobs weekly and monthly to update the database with new customer details and also maintaining other SSIS packages which updates daily the existing tables
- Worked on various reports like parameterized reports, cascading reports, ad-hoc reports and dynamic reports using SQL Server Reporting Services (SSRS) and Crystal reports on daily/weekly/bi-weekly/monthly basis
- Generated multiple enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP)
- Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS
- Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server
- Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the generated reports directly on the client’s workstation
- Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server
- Performed activities like creation and indexing of the tables
- Provided training and expertise to business users and other stakeholders on utilizing SSRS Reports for their reporting needs
Environment: SQL server2012/2008R2/2005,SSRS2012/2008R2/2005,SSIS 2012/2008R2/2005, SSAS 2012/2008R2/2005 Visual Basic 5.0, MS Excel 2003/2007MS Access 2003, Management Studio
Confidential
Sr. Analyst - SQL Server
Responsibilities:
- Created tables, views, stored procedures as per design needs and also incorporating company's standards
- Supported existing data warehouse reporting platform and applications to ensure operational availability and scalability
- Work directly with functional analysts and business users in understanding the information needs of the business and developing Reporting Services new data warehouse/BI functionalities or tools to meet these requirements
- Created detail design, work on development and perform code reviews
- Research, define and deploy BI improvement opportunities and streamline the business intelligence process
- Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints
- Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs
- Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
- Rebuilding the indexes at regular intervals better performance
- Written various stored procedures for the purpose of application development
- Design and implemented data access stored procedures and triggers for automating tasks
- Used joins and sub-queries to simplify complex queries involving multiple tables
- Worked on crystal reports with many complex stored procedures
- Worked on importing /transferring the data to database tables using DTS, Import and Export Utility
- Support for Database programming related issues
Environment: SQL server 2005, SSRS, SSIS, Visual Basic 5.0, MS Excel 2003/2007, MS Access 2003, Management Studio
Confidential
Jr. SQL Developer
Responsibilities:
- Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program
- Develop and support reports built with Microsoft Reporting Services on SQL 2005 SSRS
- Migrated access objects to SQL Server 2005, created tables, indexes and constraints
- Wrote database triggers in T-SQL to check the referential integrity of the database
- Defined stored procedures for module integrity and application
- Involved in performance tuning of the database and T-SQL queries using Explain Plan
- Done data transformation tasks like BCP, bulk inserts to import/Export data from clients
- Major role in project documentation and maintenance
Environment: SQL server 2005, SSRS, SSIS, Visual Basic 5.0, MS Excel 2003/2007, MS Access 2003, Management Studio