SUMMARY

• 8+ years of IT experience in analysis, design, implementation & administration of business intelligence solutions with 2005/2008/2008 R2/2012/2014, SSIS/SSRS/SSAS in development, testing & production environment.
• Expertise in design and development of SSIS (ETL) packages.
• Expertise in generating Crystal reports, Ad hoc reports, tabular reports, Matrix reports, Drill - down reports, Cascaded reports, List reports, Parameterized reports, Sub reports and mentoring end user report writers using SSRS.
• Experienced in upgrading SQL Server 20 /2012 and data migration among versions and migrated SQL server 2008R2 to 2012.
• 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 different phase of Software Development Life Cycle (SDLC) of development of applications.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies, and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Highly proficient in writing functional specifications and translating business requirements to technical requirements.
• Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers and user created data types to provide flexible and reusable modules to be used in WEB technology and client-server Windows technology.
• Expertise in creating indexed tables with primary key, foreign key, and composite key constraints to maintain referential integrity and to maintain performance
• Expertise in writing and debugging Stored Procedures and Triggers
• Hands on experience in the ETL processes using SQL Server Integration Services (SSIS) Bulk Copy Program (BCP) and Data Transformation Services (DTS)
• Develop and implement ETL routines as per data warehouse design.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and Ad hoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Worked on Multidimensional Expressions (MDX) queries on Cubes.
• Experience in managing Alerts, Operators, and Jobs through SQL Server Agent
• Integrator of relational databases like SQL Server, ORACLE, Microsoft Access, and Excel spreadsheets.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting, and organizational skills.
• Experience working on object oriented concepts working on C#.Net.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), SQL Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts & SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DBCC, BCP, SQL Server Profiler

ETL: DTS, SSIS

Reporting Tool: SSRS, Crystal Reports, Business Objects, Power BI

Programming Languages: T-SQL, C, C#, .Net, JAVA, PHP, XML, Python.

Databases: MS SQL Server 2005/2008 R2/2012/2014, Oracle 9i/10g/11g, SQL MS Access

Data Modeling Tool: Erwin, Microsoft Visio, performance point server, Power Pivot.

Operating System: Microsoft Windows 95/98/2000/2002/ Vista/Windows7/Windows 8/10 Mac OS X

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

SQL BI Developer

Responsibilities:

• Creating database objects like Procedures, Functions, Triggers, Indexes, and Views.
• Extracting data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Working with various SSIS control flow tasks and data transformations like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL.
• Working extensively with SSIS to import, export and transform the data from oracle, xml, and text files.
• Created ETL packages using SSIS to extract data from different data sources, reformats the data and load the reformatted data into destination tables.
• Designed SSIS packages to load data from source to Data Warehouse.
• Using SQL Profiler to estimate the slow running queries and Database Tuning Advisor for performance tuning purpose.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS Packages.
• Expertise inDeployingSSISPackage to Production and used different types of Package configurations to export various package properties to make package environment independent.
• Creating checkpoints, Break Points, and configuration files in SSIS packages.
• Creating and managed Event Handlers, Package Configurations, Logging, System, and User-defined Variables for SSIS Packages.
• Uses joins, temp tables, table variables, CTE for the complex queries involving multiple tables and generated stored procedures which load data from multiple tables to single table in data mart.
• Involving in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems.
• Developed business layer components using OOPS concepts in C# as code behind files.
• Used CSS for styling and HTML for scripting the Web pages.
• Creating different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Creating subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Writing complex SQL Queries using multiple joins for creating reports using Report builder based on the requirements.
• Developing complex SQL Server (T-SQL) queries with subquery, derived query, join, aggregation, union, CTE, stored procedures, functions, views, triggers, UDF, Dynamic SQL etc.
• Worked to prevent Cross-Site Scripting and SQL-Injection.

Environment: MS SQL Server 2008R2/2012, SQL Query Analyzer, SQL profiler, ERWIN Data Modeler, Windows Server 2008, SSIS, SSRS, SSAS, Team Foundation Server, Visual Studio 2010/2008/2012, MS Excel 2007.

Confidential, MN

SSIS Developer

Responsibilities:

• Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer.
• Extensively studied the existing OLTP system(s) to create data mart and warehouse systems using the facts, dimensions, and star schema
• Wrote user requirement documents, created technical specs and design documents for various projects.
• Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using Stored Procedures, Triggers, User-defined Functions, Views, and Cursors
• Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems
• Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations
• Involved in query tuning by creating Cluster and Non-Cluster Indexes on the tables, also used Index Tuning Wizard (ITW) for enhancing the query performance
• Written complex Stored Procedures using temporary tables, table variables, error handling (TRY & CATCH) methodology for data loads
• Hands on experience in using DDL Triggers (After and Instead of Triggers) to keep track of data manipulations using Audit functionalities
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages
• Involved in complex SSIS package development with Microsoft BI standards and Development strategies to pull data from various data sources such as (SQL Server, Oracle, DB2, Excel, and Flat file etc.)
• Worked with several Control Flow Tasks, Data Flow Tasks, and Transformations (Derived Column, Lookup, Merge Join, Conditional Split, Slowly Changing Dimension, and Data Conversion etc.) in SSIS packages
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and Linked reports using SSRS.
• Developed Reports out of the Consolidated Data Warehouse for the Business Users using MS SQL Server Business Intelligence Development Studio (BIDS) 2008 (SSRS).
• Monitoring databases to optimize database performance and diagnosing any issues.
• Implemented Package logging in both standard (SQL Server and file based) and custom logging using customer Stored Procedures and tables.
• Performing schema management, database sizing, maintaining privileges.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• 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.
• Generated Monthly, Yearly, Quarterly and daily reports in power BI.
• Worked and Joining the query's and merging the tables in power bi

Environment: MSSQL Server 2008/2012, T-SQL, ETL, SSRS, SSIS, SSAS, power BI, ASP.NET, C# Windows 2003/2008/2008 R2

Confidential, NY

SQL BI developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse Involved in installing and maintaining MS SQL Server 2008R2 /2012.
• Involved in designing the Logical and Physical data models for the data warehouse.
• Created DDL scripts to create database schema and database objects like tables, stored procedures, views, functions, and triggers using T- SQL.
• Create the clustered/non-clustered indexes on tables; Trace out for any table required any indexes and determine the type of index on it.
• Created triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Worked extensively on SSIS Package designs for Import/Export from various Data Source Flat file, Excel, Oracle to MS SQL Server and vice versa and schedule the jobs.
• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Responsible for maintaining and updating databases.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
• Optimized indexes to improve queries and analysed database performance with SQL Profiler.
• Created different types of reports such as Cross-Tab, Drill-down, Summary reports using SSRS 2008R2/2012.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Developed many cubes for reporting based on the business requirements using SSAS 2008R2.
• Extracted the OLAP cube data into Power BI and applied DAX commands to manipulate the data.
• Created various Power BI reports and published them on to the server.
• Used TFS (Team foundation server) for deployments of database changes, SSIS packages & SSRS reports.
• Created script tasks and components VB.Net in SSIS as part of ETL load.
• Responsible for unit testing and integration testing complex queries.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
• Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• Extensive Experience in Migrating Database from SQL Server and
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Worked with C#.NET to develop all the layers of the Solution.

Environment: SQL Server 2000/2005/2008 R2/2012 Enterprise Edition, SSIS, T-SQL, SSRS, power BI, Windows Server 2003/2008R2/2012, TFS, VB.Net, C#.

Confidential, West Des Moines, IA

SQL BI Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Experience in creating database objects like Procedures, Functions, Triggers, and Indexes.
• Created functions to provide custom functionality as per the requirements.
• Worked extensively with SSIS to import, export and transform the data from oracle, xml, and text files.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Involved in designing reports using SQL Server Reporting Services (SSRS) and Excel Power Pivot table based on OLAP cubes.
• ETL Programming for capturing data from disparate sources using SQL Server Integration Services (SSIS, SSRS) with Visual Studio, and Analysis Services. Used Pivot and Un-Pivot to make changes of POWER BI data to Excel POWER Pivot.
• Worked on POWER BI Dashboard to make some changes on behalf of Business requirements.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.
• Created and managed Event Handlers, Package Configurations, Logging, System, and User-defined Variables for SSIS Packages.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split etc. as part of ETL.
• Designed and written the queries in the query builder for retrieving the data.
• Created checkpoints and configuration files in SSIS packages.
• Worked extensively with SSIS to import, export and transform the data from oracle, xml, and text files.
• Used SQL Profiler to optimize Stored Procedures.
• Extensively used Merge command as alternative to small SSIS packages in dimension and fact load.
• Deployed SSIS packages with minimal changes using XML configuration file.
• Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters.
• Created various reports like Tabular reports and Matrix reports in POWER BI.
• Scheduled the monthly Reports/weekly reports/daily reports Based on user Requirements.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems.

Environment: SQL Server 2008/2008R2 Enterprise, SSRS, SSIS, T-SQL, Visual SourceSafe, Visual Studio 2010 Query Analyzer, SQL profiler, Informatic, Enterprise Manager, Business intelligence development studio (BIDS), Windows 2003 Server, Windows NT, ETL, Oracle 9i.

Confidential

SQL Developer

Responsibilities:

• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Analyzed the project environment and sub systems of the project, and prepared a high-level documentation for application designing.
• Responsible for gathering business requirements, developing, and reviewing of design documents.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintained the database consistency with DBCC at regular intervals.
• Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture, and SQL scripting.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.