SUMMARY

• Over 8 years of experience in Microsoft BI Tools (SSIS/SSRS/SSAS) and T - SQL using SQL Server 2005/2008 R 2/2012/2014.
• Handles multiple assignments simultaneously and successfully identify and coordinate key deliverables wif stakeholders in cross-functional groups. Passions include ensuring data quality, scalability, performance, integrity, and security, as well as standards development and process improvement
• Technically and logically very sound in T-SQL Programming, SSIS, SSRS, SSAS, Data warehousing, Business Intelligence etc.
• Highly self-motivated, able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines. me have always been recognized as a best programmer wifin teh organization.
• Deft in database designing skills and experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2016/2014/2012/ 2008 R2/2005. Experience in writing T-SQL (DDL and DML) scripts in all MS SQL server environments.
• Hands-on experience and exposure to different phases of Software Development Life Cycle (SDLC), Agile and Scrum Methodologies.
• Highly proficient in Tuning SQL queries and improving teh query performance. Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Demonstrated expertise in MS SQL Server 2012/2010 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts.
• Excellent hands-on experience wif data modeling tool like Erwin and strong noledge of Relational and Dimensional database modeling concepts wif star schema and snowflake schema’s design and implementation.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Experience using different Version Control Tools like Microsoft Source Safe and CVS.
• Experience inOLTP/OLAPenvironment andData Warehouse.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2010/2012 Analysis Services.
• Expertise in using Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports wif drop down menu option, sorting teh data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2010/2014.
• 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).
• Developed reports using global variables, expressions and functions.

TECHNICAL SKILLS

Databases: MS SQL Server 2016/ 2014/2012/2008/2005, ORACLE, MS Access, DB2, RDBMS.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), SQL* Plus.

ETL-Tools: DTS, SQL Server Integration Services (SSIS).

Reporting Tools: SSRS 2016/ 2014/2012/20, Excel, Tableau, Power BI.

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Programming: T-SQL, Dynamic SQL, MDX, C# .NET, XML, Java.

Operating Systems: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Server: Microsoft IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE

Confidential, Texas

SQL Server /Power BI Developer

Responsibilities:

• Worked as a developer in creating and testing complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, Sorting columns and writing expressions according to teh business requirements.
• Worked onperformance tuning of Views, CTE’s, stored procedures.
• Created and modified various Stored Procedures used in teh application using T-SQL.
• Used star schema in designing datamarts for creating SSIS ETL packages.
• Used DAX operations dat were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Identified and worked wif Parameters for parameterized reports in SSRS 2012.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2012.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Deployed teh generated reports directly on teh client’s workstation.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh SSAS cubes.
• UsedSSIS 2012to createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs
• UsedPowerBIDesktop to develop data analysis multiple data sources to visualize teh reports.
• UsedPowerBICustom visuals likePowerKPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make teh visuals look and understand better.
• EmbeddedPowerBIreports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Responsible for creating and changing teh data visualizations inPowerBIreports and Dashboards on client requests.
• Deployed Dashboards, Reports and Data sources in thePowerBIService.

Environment: MS SQL Server 2016/2012 Enterprise Edition, SQL Server Integration Services 2015/2012, MS SQL Server Reporting Services 2015/2012, SQL Server Analysis Services 2015/2012, Power BI, Windows 10.

Confidential 

SQL BI DEVELOPER (SSIS, SSAS & SSRS)

Roles & Responsibilities:

• Responsible for gathering/refining requirements from teh customer for developing reports.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created Grouping, Sorting columns and writing expressions according to teh business requirements.
• Transferred teh data using SSIS packages.
• Worked onViews, cursors, CTE’s, schemas,permissions and performance issues wif client/server database design.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS 2012.
• UsedSSISto createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps) and integrated them to share point.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Used star and snow flake schema in designing cubes for creating SSAS packages.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for teh SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Performed database transfers and queries tune-up, integrity verification,data cleansing, analysis and interpretation. Developed, monitored and deployedSSISpackages.
• Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components.
• Migrated old data from MS Access and Excel into SQL Server 2016 using SSIS Packages in Business Intelligence Development Studio..
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• UsedSSIS 2016to createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• CreatedSSIS packages to Export data from text file to SQL Server Database.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Identified and worked wif Parameters for parameterized reports in SSRS 2016.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Managed Power BI - Data refreshes / User management and set up gateway data refresh.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using Power BI.
• Implemented and enhanced existing reportslike Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.
• Deployed teh generated reports directly on teh client’s workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning teh database.
• Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Environment: MS SQL Server 2016/2014, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSRS, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), Power BI, XML, ETL, Microsoft Visio 2003, MS Visual Studio 2012/2015.

Confidential, Bloomington IL

MS SQL Server Developer/SSRS/ SSIS/SSAS Developer

Responsibilities:

• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints
• Adding logins, roles, groups to teh Window NT and MS SQL Server and maintaining proper security procedures.
• Created SSIS packages to get data from different sources, consolidate and cleanse teh data and merge it into one single source.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Responsible for ETL operations using SQL Server Integration Services (SSIS) and Worked wif users in and support and also has experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Applied different transformations, control, lookups, SCD, Derived column to easily migrate SSIS package from one server to another.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Built SSIS Packages for Processing cubes and Dimensions.
• Developed Custom Sales, Inventory and financial reports for seasonal, quarterly, monthly and weekly using SSRS.
• Developed various kinds of Tabular, Matrix, Drill-down, Drill-through, Charts, and web receiving reports using SSRS.
• Responsible for scheduling teh reports based on teh subscriptions defined.
• Generated and formatted Reports using Global Variables, Expressions and Functions, designed and implemented stylish report layouts.
• Responsible for creating dimensional and fact tables and building cubes using SSAS.
• Responsible for maintaining and tuning existing cubes using SSAS.
• Worked wif teh Planning team to forecast teh business requirements.
• Experience in Designing, building teh Dimensions, Cubes on star and snowflake schema using SQL Server Analysis Services (SSAS) for business analysis.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in developing applications using ASP .NET /C# /SQL Server.
• Maintained teh physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure teh completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.

Environment: C#, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2012/2014, SSIS, SSRS, SSAS, VisualStudio.NET IDE.

Confidential, Memphis

SQL BI DEVELOPER (SSIS, SSAS, SSRS)

Responsibilities:

• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Installed, Configured, Managed and Monitored SQL Server 2012/2008/2005.
• Creating tables, indexes and designing constraints.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Developed and deployed SSIS packages in Production Server.
• Managed teh entire ETL process involving teh access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked wif Multi-threading Concepts wif Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Created SQL SSIS and SSRS infrastructure dat pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store teh Configuration, Security and Caching Information for teh Operation of teh Report Server.
• Used Aggregate awareness function of Business Objects to route teh query objects through teh appropriate path while selecting from multiple contexts.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.

Environment: SQL Server 2014/2012/2008/2005, SSRS 2012/2008, SSIS 2012, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2012, XML, XSLT, MS Office and Visual source safe, Business Objects XI 3.1/3.0, XI R1/R2, Power BI, Power Map, Power Pivot, Power View.

Confidential, NY

SQL Developer/DBA

Responsibilities:

• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.
• Gatheird user requirements from users and managers to better understand teh business logic of teh company and create database dat fits their needs
• Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Created Views to replace old tables and created new tables wif triggers to support new business needs.
• Modified teh current stored procedures using Visual Source Safe 6.0 to meet current design.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS-2008.
• Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS.
• Created custom stored procedures and function to support various new operations.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Jobs, Alerts and scheduled DTS to generate Reports.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, MS Access, Import & Export Data, Windows XP, VSS, T-SQL, Visual Studio.

Confidential

MS SQL Server Developer/ DBA

Responsibilities:

• Experience in support and management of databases, systems, applications and Application Development.
• Experience in Implementation of Production environment Hardware requirements and application support.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 databases/ servers.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule teh Administrative Tasks (like database integrity checks and maintenance plans).
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (me.e. Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Experience in planning and implementing teh Replication of MS SQL Server 2005 Databases and databases Backup recovery strategy.
• Created Custom ETL packages using SSIS 2005 and develops and unit test SSIS load processes for performance check.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Very good experience in teh maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Experience on working wif BRP (Business recovery plans) and EPP exercises (Emergency prepared plans)
• Creation and maintenance of Users security permissions and Migrating teh entire database objects from one server to another server and database to another database.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2000/2005, MS Access, Query Analyzer, DTS, SQL Profiler, Import & Export Data, Windows 2000 Server.