SUMMARY

• Have 8+ years of IT experience in Microsoft Business Intelligence tools like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading
• Skilled at developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T - SQL
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments
• Experience in dimensional modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse
• Expertise in creating ETL DTS packages and SSIS packages for integrating data from heterogeneous data sources by using different transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all
• Experience in creating and managing Event Handlers, Package Configurations, Error Handling, Logging, System and User-defined variables for SSIS packages
• Deployed the SSIS packages from development server to production server
• Experience in Designing and Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS)
• Developed OLAP cubes using SSAS and defined data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using Multidimensional Expressions (MDX)
• Involved in developing reports from SSAS cubes using client tools like SSRS, Excel and Report Builder
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS)
• Experience in SQL Server 2012 Self Service BI tools like Powerview, BI multidimensional models and SQL Server Data Tools
• Extensive experience and in depth working knowledge in various SQL Server tools and IDE to work with database, reporting and business intelligence based applications like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio and Query Analyzer
• Strong experience in Oracle database, worked with versions Oracle9i, 10g, 11g
• Strong experience in creating dashboards using gauges and charts for analysis using SSRS
• Experience in integrating SSRS reports into external applications using report viewer controls and custom URLs
• Experience in installing, configuring and monitoring MS SQL Server 2014/2 /2000 installations
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages
• Sound knowledge of software development life cycle (SDLC) models like Agile and Waterfall along with substantial experience with object-oriented analysis and design methodologies
• Solid experience in version control tools such as Team Foundation Server (TFS) and Sub Version Control (SVN)

TECHNICAL SKILLS

RDBMS: MS SQL Server, Oracle, Teradata, MS Access

Programing Languages: T-SQL, PL/SQL, SAS, R

ETL Tools: DTS, SSIS, Informatica Power Center

Modeling Tools: Erwin, MS Visio

BI Tools: SSIS, SSAS, SSRS, Tableau

Operating Systems: Windows, UNIX

Others: Toad, MS Excel, MS Project, MS Office, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. SQL BI Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting, scorecard/dashboards on SQL Server using SSAS, SSIS, SSRS
• Performed data management projects and fulfilled ad-hoc requests according to user specifications by utilizing data management tools like MS Access, Excel and SQL
• Involved in creating star and snowflake schemas and defined the source to target data mappings, business rules, business and data definitions
• Involved in migration of large amount of data from OLTP to OLAP by using ETL packages
• Developed SSIS packages to extract data from different sources such as flat files, Excel, SQL Server, Teradata for the daily load in order to create and maintain a centralized data warehouse
• Performed different transformations in SSIS like Slowly Changing Dimensions, Lookup, Merge, Derived Column, Multicast, Conditional Split, Aggregate, Execute SQL Task as per the requirements
• Created and maintained tables, stored procedures, indexes, database check constraints, and business rules using T-SQL for the ETL packages
• Involved in analyzing, designing, building and testing of OLAP cubes using SQL Server Analysis Services (SSAS) and added calculated fields using MDX
• Designed and built the dimensions, cubes with star schema using SSAS
• Increased the performance of cubes by partitioning and aggregation of cubes using SSAS
• Developed custom reports in MS SQL Server environment using SQL Server Reporting Services (SSRS)
• Created reports with Drill Down, Drill Through and Drop Down menu options and parameterized and Linked reports using Sub-reports
• Deployed and scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports including current status
• Conversant with all phases of Software Development Life Cycle including System Analysis, Requirements gathering, Design, Development and Implementation

Environment: SQL Server 2014/2012/2008 R2/2008, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Visual Studio, T-SQL, Tableau, MS Excel, MS Access, Oracle, Teradata, DB2, Windows Server 2003/2008/2012, Agile

Confidential, Greensboro, NC

Sr. SQL BI Developer

Responsibilities:

• Interacted with stakeholders/customers and gathered requirements through interviews, workshops and existing system documentation
• Created SSIS packages to validate, extract, transform and load data into data warehouse and data marts
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case
• Used Configuration Files in SSIS to ease the process of moving the packages across servers
• Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages
• Developed SSIS packages using looping, data formatting, check points, error handling, email notifications etc.
• Created and optimized complex T-SQL queries for ETL packages
• Maintained the consistency of data by performing Data Profiling and Data Cleansing
• Worked with SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval
• Involved in creating calculated members, named sets, advanced KPIs for the SSAS cubes
• Created relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS
• Generated periodic reports based on the statistical analysis of data from various time frames using SSRS
• Created Tablix, Drill-down, Drill-through, Matrix, Tabular, Multi Parameterized, Chart and data driven reports using SSRS

Environment: SQL Server 2012/2008 R2/2008/2005, Oracle 11g, SAP, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, SSIS, SSRS, SSAS, Tableau, Excel, Power View, SQL Server Management Studio (SSMS), Power Pivot, TFS, MDX, Report Builder 3.0, DTS, C#, VB.NET, Erwin 4.0, XML, Agile

Confidential, Richfield, MN

SQL BI Developer

Responsibilities:

• Involved in technical discussions for business requirements and interacted with business analysts, clients and development team to resolve high priority issues
• Created SSIS packages to implement new complex business logic for modifying the workflow
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed
• Monitored and resolved Data warehouse ETL Production issues
• Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement
• Involved in database design to create star schema using Dimensional and Fact tables
• Established the relationships between tables and maintained and deployed OLAP cubes in SSAS
• Created cube structure for the analysis of business conditions and for creation of reports using SSAS
• Extensively involved in the SSAS storage and partitions, aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL
• Developed different chart reports for customers based on the requirements using SSRS
• Deployed the reports to the report manager and maintained the same providing necessary access to the users
• Created roles for the reports and assigned them accordingly

Environment: SQL Server 2008/2005, Windows Server 2003/XP, T-SQL, SSIS, DTS, SSRS, SSAS, Tableau, MDX, C#, VB.NET, ASP.NET, MS Access, Oracle, XML, Excel, Erwin 4.0, Business Intelligence Studio 2008/2005, Agile

Confidential

SQL BI Developer

Responsibilities:

• Involved in gathering requirements and design of technical specification documents
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SSIS
• Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format
• Created complex packages and performed the ETL to load the Dimension Tables using SSIS
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records
• Responsible for writing T-SQL queries for creating cursors, functions and handling data validations
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• Analyzed financial reporting data with the existing Data Warehouse system environment and exported data load from landing area to Tabular Mode environment in SQL Server 2008
• Developed analysis services project. Responsible for identifying and defining data source and data source views. Created cubes and defined the dimensions
• Created MDX and DAX Queries from Tabular model for SSRS Reports
• Created parameterized and cascaded reports and made the reports interactive with the users

Environment: MS SQL Server 2008/2005, T-SQL, SSIS, SSRS, SSAS, DTS, Visual Basic 6.0, Excel, MS Access, Crystal Reports 8.0, Windows NT

Confidential 

SQL Developer

Responsibilities:

• Upgraded SQL Server 7.0 to SQL Server 2000. Also, performed SQL Server 2000 Installation
• Worked on Client/Server tools like SQL Server Query Analyzer to administer SQL Server
• Created Database Maintenance Planner for improving the performance of SQL Server which covers Database Integrity Checks, Updated Database Statistics and Re-indexing
• Analyzed the requirements and fine tuned the stored procedures to improve performance
• Planned the complete backing up of Database and restored the Database from Disaster Recovery
• Designed DTS Package, DTS Import/Export for transferring data from Heterogeneous Database
• Data migration (import & export - BCP) from Text to SQL Server
• Clustered Server and Load balancing to maintain the redundancy of servers
• Configured IIS Server for the XML programming which was a new level of SQL 2000
• Configured Exchange Server for sending automatic mails to the respective people when a job failed or succeed

Environment: SQL Server 2000/2005 Enterprise Edition, Microsoft Windows 2000 Server, Microsoft Visual Basic, T-SQL, MS Excel, MS Access