Sql Bi Developer (ssrs, Ssis) Resume
Norfolk, VA
SUMMARY
- Over 8 Years of experience in SQL Server 2012/2008R 2/2008/2005/2000 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
- 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 Managing Security of SQL Server 2012/2008R2 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
- Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
- Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
- Developing reports on SSRS on SQL Server (2000/2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
- Experience in writing expressions in SSRS and Power BI and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
- Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
- Great ability to create and manage various database objects like tables, views.
- Worked Extensively on ETL process using SSIS package.
- Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
- Experience in using T-SQL in SQL Server 2000/2005/2008 and 2012 platforms.
- Experience in Performance Tuning and Query Optimization.
- Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS.
- Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
- Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI and also deployed dashboards onto SharePoint.
- Proficient knowledge in TIDAL Enterprise Scheduler.
- Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Experience in creating packages to transfer data between ORACLE, MS ACCESS and Flat Files to SQL Server using DTS/SSIS.
- Expert in creating Parameterized Reports.
- Hands on experience in Creating datamarts in Star Schema and Snow Flake Schemas.
- Working with Project ManagementTeam Foundation Server, SharePoint, Microsoft Project, and JIRAand source code version control SVN environment.
- Ability to work independently or as part of a team to accomplish critical business objectives.
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
TECHNICAL SKILLS
SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Power BI, SQL Server Data Tools.
Database: SQL Server 2012,2008 R2,2008, 2005, 2000, SQLCMD, Microsoft Office 2007/2003, MS-Access, SharePoint.
Language: C,C++,HTML,XML, T-SQL,MYSQL,DHTML,VB.NET,ASP.NET,.NET Frame Work, C#, JavaScript, Web Services.
Operating System: Windows XP/NT/ 2000/2003/2008 , DOS
Tools: Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports8.5,10,XI,R2,BusinessObjects,Microsoft office 2003/2007, TFS, PowerShell, Tableau, JIRA, Tidal.
PROFESSIONAL EXPERIENCE
Confidential - Norfolk, VA
SQL BI Developer (SSRS, SSIS)
Responsibilities:
- Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
- Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
- Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
- Excellent report creation skills using Microsoft SQL Server 2008/2012/2014 Reporting Services.
- (SSRS) with proficiency in using Report Designer as well as Report Builder.
- Migrated data from different sources (text based files, Excel spreadsheets,Sybase,Oracle) to SQL Server databases using SQL Server Integration Services (SSIS).
- Created SSIS package to load data from Flat File (2GB -- 4GB) to Flat File and Flat File to SQL Server 2012 using transformations including Lookup, Derived Columns and Condition Split.
- Deploy and Schedule SSIS packages using SQL server agent for incrimental load of datawarehouse.
- UsedDTS/SSISandT-SQLstored procedures to transfer data fromOLTPdatabases to staging area and finally transfer into data marts and performed action in XML.
- Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
- Responsible for migrating legacy VB6 code to VB.Net using in-house developed tool.
- Experience in creating VB.Net batch jobs for mass uploads.
- Helping Scrum master across the company to customize JIRA for their requirements and for move tasks from one activity to another.
- Creating and managing scheme objects such as tables, views, clusters, Indexes, Procedures, triggers and maintained Referential Integrity.
- Developeddatabase triggersand stored procedures using T-SQL cursors and tables.
- Implemented automated jobs for Database Backup on a weekly and monthly basis.
- Implemented complex conceptual database design and database architect into SQL Server 2012/2008R2 using various constraints and triggers.
- Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
- Using Visio 5.0 design different kind of Data Models for various kind of databases as per the requirement.
- Implemented the project using ASP.NET, C# and back-end database as SQL Server 2012.
- Worked on querying data and creating on-demand reports using Report Builder in SSRS reports, using Power BI and send the reports via email.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
- Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
- Executed workflows using Tidal scheduler.
- Utilized Agile Scrum practices to help the team increase their velocity by 63% within the first year of Agile adoption.
- Responsible for maintaining Sharepoint platform and reporting any issues to the IT director.
- Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts.
- Created ad-hoc reports using SQL server 2012/2008 R2 Reporting Services (SSRS) and Power BI.
- Deployed 2008 R2 Reporting Services (SSRS) RDL files to Reports server.
Environment: SQL Server 2012/2008R2, SQL Server Reporting Services 2012(SSRS), PowerShell Scripting, SQL Server Integration Services 2012(SSIS), Microsoft Visual Studio, SSMS, Power BI, MS Excel, SharePoint, .NET, T-SQL, JIRA, Tidal.
Confidential - Hartford, CT
SQL Server/SSIS/SSRS Developer
Responsibilities:
- Translated business needs into data analysis, business intelligence data sources and reporting solutions for the clients.
- Transformed data from different data sources like Oracle to SQL Server 2008/2005 using ODBC connection providers by creating various SSIS packages. Data is transformed from data warehouse to hub.
- Extensive T-SQL Programming using Views, Functions,Stored procedures, CTE’s and functions.
- Performed performance tuning by analyzing indexes, queries, and table size etc Database Engine tuning advisor and query execution plan tools.
- Developed and maintained various cubes using MDX complex queries using SSAS.
- Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
- Working with various business groups while developing their applications, assisting in Database model design.
- Created package configuration in XML and used them to deploy packages across Test and production SQL servers.
- Designed and generated reports with different layouts using SSRS 2008R2 and exported them into Excel, PDF and HTML.
- Responsible for reverse engineering the company intranet and collaboration portals built up SharePoint 2013 and SharePoint 2010.
- Analysis and documentation of SharePoint architecture including central administration, SQL & Windows 2008R2.
- Involved in debugging the ASP.NET code and fixing the bugs.
- Performed Tableau type conversion functions when connected to relational data sources.
- Maintained and Installed Tableau Server in all the environments.
- Created incremental refreshes for data sources on Tableau server.
- Developed several REST web services supporting both XML and JSON to perform tasks such as remote thermostat and demand-response management. REST web services leveraged by both web and mobile applications.
- Design and development for the Crystal Reports which work as a feed for the dashboard.
- Created WebI reports for P2P/OTC and FI reports for base of the dashboard development.
- Implemented PowerShell scripts that automated creation of contacts from Active Directory usersand updating of address books -increasing productivity and efficiency.
- Designed and developed various Service Management Reports like Cascading Prompts, Sales Reports, Portfolio Report, sub-reports, charts, and parameterized reports, conditional and dynamic reports and deployed various reports on Share Point Portal.
- Created report models for ad hoc reports when the end user wants to see the reports on fly.
Environment: SQL Server 2008R2/2008, SSIS,SSAS,SSRS,Windows Server 2003, SSIS/SSAS/SSRS, SharePoint, Crystal reports, Web Services, PowerShell, Tableau and MS access Excel.
Confidential - Houston, TX
SQL Server / BI Developer
Responsibilities:
- Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
- Involved in designing the physical databases model on SQL Server 2008R2/2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
- Extensively used T-SQL to manipulate and architect to produce results for users.
- Performance tuning of Queries and Stored Procedures.
- Worked with development teams in the design of physical databases and in modification.
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
- Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
- Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
- Implemented business logic as .NET Framework assemblies (C#, VB.NET).
- Extensive Excel work using pivot tables and complex formulas to manipulate large data structures.
- Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
- Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
- Developed data mining algorithm from energy bill data using RDBMS and .Net technologies.
- Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
- Designed and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 Reports Services (SSRS).
- Developed Data Interface layer using ADO.NET and C# for data access.
- Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
- Developed SSIS process design architecting the flow of data from various sources to target.
- Built ETL SSIS packages both design and code to process data to target databases.
- Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
- Created data entry both web and windows application, with LINQ to query XML Documents.
- Help in leading team in creating SSIS templates for developing SSIS Packages.
- Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
Environment: Windows 2003/2008 Server, SQL Server 2008R2, BIDS, ASP .NET, XML, SSIS, SSRS, Power BI, Service Broker, C#, PowerShell, MS VSS
Confidential
SQL Server BI Developer
Responsibilities:
- Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
- Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
- Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
- Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
- Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
- Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
- Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
- Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
- Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2000 using Data Transformation Services (DTS) and T-SQL scripts.
- Created views to restrict access to data in a table for security.
- Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
- Designed SSIS Packages to extract data from various data sources such as Access database, Excel (with PowerPivot) spreadsheet, and flat files into SQL Server 2005 for further Data Analysis by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
- Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
- Supported Application Development team with any database issues, updates or new releases. and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
Environment: SQL Server 2000/2005, SSMS, SSIS, SSRS, SSAS, HTML, CSS, Java Script, Team Foundation Server,IIS 7.0
Confidential
SQL Server Developer
Responsibilities:
- Maintain database dictionaries, monitor overall standards and procedures, and integrate enterprise systems through database design.Develop, review, and optimize queries for data retrieval and update.
- Developed shell scripts in PERL for the application server.
- Written and developed shell scripting for application performance, system maintenance and backup.
- Performed T-SQL programming for writing stored procedures, user-defined functions, Triggers, Cursors, Views on SQL 2000 servers.
- Installed & configured Web server IIS 4.0 and SQL Server 7.0 and hosting websites.
- Develop and create data dictionary, tables, views, indexes, and functions advanced queries for databases using Query Analyzer and Enterprise Manager.
- Developed necessary data access programs using JDBC and Data Express and developed the web pages using HTML and Java Scripting.
- Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
- Configured securities and access to product databases in SQL Server 2000, Windows 2003 Server.
Environment: SQL Server 2000 Enterprise Version, SQL Query Analyzer, T-SQL, Java Script, C++ Microsoft IIS 4.0, VB 6.0, HTML, XML, Windows 2003, PERL, Shell scripting.
