SUMMARY

• Experience in Health Care, Banking, Retail Industry and Consulting Domain as a SQL server Developer that includes Database Design, Development, Implementation, Maintenance and Documentation of Microsoft SQL Server 2014/2012/2008 R2/2008/2005 and its Client Server Applications.
• Extensive experience in Data Warehousing Concepts, Designing Relational Database Model and Implementation as per Business needs.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Proficient in SQL Server and T - SQL (DDL and DML) in Constructing Tables, Normalization Techniques on Database Tables and established relationships between tables using Primary Keys & Foreign Keys.
• Expert in writing T-SQL queries, complex Stored Procedures, User Defined Functions (UDF), designing and implementing Database triggers, Views and Indexes.
• Expert in using tools SQL profiler and database tuning Advisor (DTA).
• Expert in Creating Joins and Sub-Queries to simplify complex queries involving multiple tables and Exceptional Handler.
• Very strong in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers in SQL Server 2008.
• Expertise in Change Data Capture (CDC), Change Tracking (CT) in SQL server 2008.
• Efficient in building recursive queries using CTEs (Common Table Expressions). Experience in Data Modeling (Logical and Physical Design of Databases), Normalization/de-Normalization and building Referential Integrity Constraints.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience in designing Database Models using MS Visio and Erwin
• Experience with Database Backup, disaster recovery and Disaster recovery drill.
• Knowledge of DB high availability concepts like MS SQL Clustering, replication and log shipping, DB Mirroring.
• Experience in query optimization, running DB Consistency Checks using DBCC commands.
• Expertise in Exception handling with @@error and with Try and catch.
• Created temporary tables and table variables while creating complex queries in SQL Server.
• Partitioned large tables using Partition Functions and Partition Schemas.
• Efficient in Implementing Transactions in Stored Procedures.
• Proficient in RDBMS concepts including writing Stored procedures and functions using TSQL in MS SQL Server 2005/2008/2008 R2/2012 and good experience on PL/SQL in Oracle 8i/9i/11g and MS Access.
• Installation of OBIEEand related components for development, QA and production environments.
• Develop custom reports, SQL jobs, and procedures, and other Software: Microsoft Visualsolutions to client's needs (Client Facing). Studio, Adobe Dreamweaver, NetBeans, Eclipse, ADT.
• Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expertise in Merging data from various Data sources (Oracle, SQL Server, Access, Excel, Flat Files and XML) using Connectors, tasks, transformations, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Created SSIS packages to process fact and dimension tables with Slowly Changing Dimensions type 1 and type 2 changes.
• Worked on Integration Service (SSIS) packages Development & Deployment onto Production.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
• Experience in developing, configuring and deploying SSIS packages and providing security
• Worked in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expert in using of SSIS Control Flow items(For Each Loop, execute package/SQL tasks, Script task, and Send mail task)and SSIS Data Flow items(Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Proficiency in creating different types of complex reports like Cascading parameters, Parameterized Reports, Crosstabs, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub Reports Developed Dash Board Reports.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Worked on building a Data Warehouse and implementing an ETL solution for loading Data warehouse.
• Around 8+ Years and of IT experience in Development, Implementation, Testing and support of large scale and medium scale Data warehousing projects.
• As part of the agile development methodology used in Symphony, development is done based on use cases. ETL
• Extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0 and 8.1 as a Reports Developer and Analyst
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau
• Expert in Query Tuning, including Updating Statistics, Re-building and Re-organizing Indexes.
• Worked extensively with Dynamic Management views and Functions (DMV) to resolve performance based issues on the server.
• Thorough knowledge of addressing Performance Issues and Involved in Index tuning, Data profiling and other database related activities.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV’s and DTA.

TECHNICAL SKILLS

Data warehousing BI Tools: SQL Server 2014/2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SSMS, DTS Packages, MDX Queries, ETL, OLAP, OLTP, Visual Studio, Power Pivot, Power BI, Tableau.

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, power Query, SQL Server Profiler, Data Base Engine Tuning Advisor, Data Transformation Services, Visual Studio, Red gate, Source Control, Team Foundation Server.

Programming Language: T-SQL, PL/SQL, C, C#, HTML, Java Script, XML, NetBeans, .NET 2.0, Visual Basic 6.0, Python, Ruby, Visual FoxPro 5.0.

Relational Databases: SQL Server 2014/2, MS Access, Oracle10g/11i/12c

Operating Systems: Windows Vista/XP/ 2008/2007/2003 Windows Server 2000/2003/2008/2012 Linux

PROFESSIONAL EXPERIENCE

Confidential, MONTPELIER, VT

MSBI DEVELOPER

Responsibilities:

• Designing Tabular Models for Data Analysis of Summarized and Operational Data
• Creating Functional and Technical Reporting Solution Design Documents
• Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, developing reports using MDX and T-SQL.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Involved inTabularData warehouse and DAX operations for SSAS 2012
• Work onTabularModeling Development and Multidimensional Modelling Development using SSDT. Create additional Timestamp for report
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning
• Utilized Power Query in Power BI to Pivot and Un-pivot the datamodelfor data cleansing and data massaging
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors usingSQLServer Management Studio. Created User Defined Functions, Views to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• TuneSQLqueries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary.
• Create tasks, sessions etc. in the workflow manager and monitored them in the workflow monitor.
• Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management
• Setting direct & referenced relationships between Dimension & Fact Tables, resembling Star Schema.
• Implement Time Calculations Like QTD, YTD using DAX Formulas as a Shell dimension approach rather than Individual measures. So that they can work with multiple measure groups/measures.
• Create Partitions for ease of Data Processing in Tabular Models. Implement Drill Through actions in Model for looking Detail Level data.
• Creating Calculated Members & Measures in Model using DAX Script.
• Creating SSIS Package for building SSAS Model Data Refresh Strategy
• Dynamic Creation & Processing of SSAS Partitions with the help of SSIS Package.
• Implementing Data Driven/Dimensional Security in Model for User Groups.
• Creation of Roles in Model using DAX Formulas to define the User Security in Cube.
• Deployment and End-to-End testing of Tabular Models. Perform Unit testing for calculated members & measures.
• Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked with mappings to dynamically generate parameter files used by other mappings. Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Documented the mappings used in ETL processes including the Unit testing and Technical document of the mappings for future reference.
• Designed developed the SSIS packages to extract, transform, load the data into Target and generate outbound files for various vendor by using SSIS.
• Scheduled the Informatica Workflows to start running at specified date and time repetitively forever. Participated in unit testing to validate the data in the flat files that are generated by the ETL Process.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the Tabular, OLAP and Operational data.

Environment: MSSQLServer 2017,2015 Visual Studio 2017,2015,SQLServer Integration Services (SSIS), Data Warehouse, Redgate Tools, Informatica Power Center 9.5.1,Toad for oracle, Oracle 11g,12c, PL/SQL, DB2, Unix, MS Visio, C#, Data Modeling, Share Point, Team Foundation Server (TFS) 2012, ERP, CRM software, Widows server 2012, Linux server.

Confidential, COLUMBIA, MARYLAND

SQL BI Developer/SSIS

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis.
• Used SSIS to create ETL packages to validate, extract, transform and load data to warehouse databases, data mart databases.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS
• Created SSIS packages to retrieve data from heterogeneous sources and also to retrieve data from the Flat files on monthly and weekly basis
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Involved in integrating different Database Applications using SSIS packages.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Jobs using TWS tools will run at regular intervals of time if the given condition is satisfied and then refreshes the database with new data
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results, Sets and Variables wherever they are needed in SSIS.

Environment: SSIS, OBIEE, MS SQL Server 2008,2012,2014, Windows 2003, MS Access

Confidential, SCOTTSDALE, AZ

SQL BI Developer/SSIS/SSRS

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.
• Hand-on working experience in creating SQL Server Reports using SSRS
• Installed and configured SQL Server 2008 successfully.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages
• Good understanding of Microsoft Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Extensively worked on performance tuning of the ETL process and SQL optimization on a large database.
• Developed data Mappings between source systems and warehouse components.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Analyzed the existing data and performed the migration steps to SQL Server 2008.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Lookups, Aggregations, and Multicasting.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Design and develop SSRS reports based on the business requirement thus obtained.
• Extract data from access, excel, flat file, and different data base and load in SQL data base Using SSIS packages.
• Provided Logging, Error handling by Event Handler and Custom Logging for SSIS.
• Verified different packages using Views using SQL Integration services 2008.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Cascading Reports for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2005/2008
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• As part of Business Intelligence and Reporting team, played a key role in Development and Maintenance of SSRS Reporting Environment
• Performance testing on Store procedures, Indexes.
• Business function knowledge of ERP including Financials, Project Management, Human Resources, Payroll, etc.
• Involved in generating summary reports like Tabular, Matrix using SSRS.
• Developed Query for generating Drill Down and Drill Through Reports in SSRS 2012 and 2008.

Confidential, IRVING, TX

SSIS/ETL Developer

Responsibilities:

• Expertise in complete SDLC (Software Development Life Cycle) on various application domain involving different technologies varying from open systems to Data warehousing on AIX and Win NT platforms.
• Strong knowledge in Business Intelligence, Data warehousing and ETL Configuration support.
• Maintaineddata integrityby performing validation checks.
• This project involves application development and maintenance of new and existing application. Activities involved are starting from analysis, requirement gathering till code deployment to production.
• Optimized queriestuned and monitored server performance.
• Involved in Fine-tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Importeddata from various sources into aStaging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Involved in the design, development and implementation of the on-boarding Convertible Bonds feeds for trade surveillance.
• Mentoring and training team members about the technical architecture and development process being used in the project.
• Developed, monitored and deployed SSIS packages and Conversant with software development life cycle (SDLC).
• UtilizedSSIS(SQL Server Integration Services)to produce a Data Martfor reporting.
• ImplementedSSIS data transformationscripts, created maintenance procedures and provided data integrity strategies.
• Responsible forcreating the reportsbasing on the requirementsusing SSRS 2008.
• Create Minor development documents and Release Notes for all development activities
• Gathered business requirements, definition and design of thedata sourcing and data flows, data quality analysis,and working in conjunction with the data warehouse architect on the development of logical data models.
• Deployed the generated reportson to the server.
• Assisted in migratingDE normalized reportDB into aStar Schema design.
• Actively supported business users for change requests.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Data blending implemented on EMPI databases and generated interactive dashboards
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

Environment: MSSQL Server 2012/2008, Visual Studio 2010. Integration Services (SSIS 2005/2008/2012 ) Business Intelligence Development Studio (BIDS), Crystal Reports, VB, C#, Office 2007, MS Access, ETL, MS Excel, Tableau, TFS (Team Foundation Server 2010).