SUMMARY:

• Around 10 years of experience in requirements gathering, analysis, development, implementation, testing, deployment and maintenance. Developing Client/Server using Confidential SQL Server 2016/2014/2012/2008 R2, MSBI - SSIS, SSAS, SSRS, PBI RS (Power BI Reporting Service), POWER BI - Power View, Power Query, Power Pivot, Power Map, SQL Mobile reports, Datazen, Tableau, Teradata, ORACLE,OBIEE, NoSQL(Raven DB), JavaScript, JQuery, HTML5, XML, XAML, CSS3, Angular, ASP.Net, C #.NET, VB.Net, MSAccess, VB6.0, VBA and various segments of Software Development Life Cycle (SDLC) under Production, Development and Staging Environments.
• Extensive SQL Development, Support & Maintenance experience in Banking, Insurance, Telecom And Government sectors with a strong understanding of data & analytics.
• Expertise in SQL Server 2016/2014/2012/2008 /2005, SQL BI, PBI RS (Power BI Reporting Service), POWER BI, SQL Server Data Tools in VS 2015/2010/2012 , Report Builder 3.0, Teradata SQL Assistant, NoSQL(Raven DB), DB2, MS Access, VBA.
• Experience of .Net Framework (ASP.NET, VB.NET, C#.NET, JavaScript, Power shell, JQuery, Angular, HTML,XML, XAML, CSS and IIS 7.0).
• Excellent T-SQL Developer skills including Adhoc SQL, Stored Procedures, Indexes, Views, Functions, Triggers, Cursors and Distributed Transactions.
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Good exposure to relational database management systems and good knowledge on Clarity tool.
• Experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Experience in solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Experience in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert, Excel, Flat Files in SSIS.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Involved in migration of SSIS (2005) to SSIS (2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience with version control systems like Confidential Visual Source Safe (VSS), Team Foundation Server (TFS), Tortoise SVN.
• Experience in Actuate 9 reporting and primavera tools. Good knowledge in Accela 9, Oracle, OBIEE(Oracle Business Intelligence Enterprise Edition, Tableau.
• Specializes in Visual Basic 6.0, programming MS ACCESS (XP/2003/2007) VBA front-end and back-end, MS Excel XP/2003/2007 VBA (Lookups, Pivots, Charts, Macros) and is also proficient in the MS OFFICE Suite of software, particularly MS-WORD and POWER BI - Power View, Power Query, Power Pivot, Power Map, DAX, SQL Mobile reports, Datazen, Datazen SQL Server migration assistant, SSRS 2016, Power BI Reporting services including the interfacing/exchange of data between these software’s.
• Good Knowledge on Creating and Configuring Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX, DAX Queries using SQL Server 2008 Analysis Services.
• Good communication, interpersonal skills and has a strong ability to work as part of a team and as well as handle independent responsibilities.
• Experience with version control systems like Confidential Visual Source Safe (VSS), Team Foundation Server (TFS).
• Extensively worked on production support, bug fixing and closing production tickets using ITSM and MSSolve

Key Skills & Knowledge:

Tools: Confidential SQL Server 2016/2014/2012/2008 R2, PBIRS 2017(POWER BI Reporting Services), Power BI Desktop, Power BI (Cloud), MS-ACCESS (Reporting, Forms), MS- EXCEL (Pivot, Charts & Macros), VBA, Teradata, T-SQL, PL/SQL, SSIS, SSRS, SSAS, NoSQL(Raven DB), SQL Service Broker, Crystal Reporting, Query Analyzer, SQL Profiler, XML, HTML, VB Script, IIS6/IIS7, VBA (Macros), VB6.0, ASP.NET, VB.NET,C#.NET, SharePoint, UltraEdit, WinSCP, MS Visual Studio, BIDS, PerfMon, Power Shell, JavaScript, Angular, Primavera, Actuate 9, HP ALM, ITSM BSM REMEDY, MSSolve, Datazen, SQL Mobile Reports, Datazen Publisher, SQL Mobile Reports Publisher, Power View, Power Query, Power Pivot, Power Map, DAX, Oracle, OBIEE, Tableau, Datazen - SQL server Migration assistant, Report Builder, SQL Server Data tools(SSDT), Net Mon,Proc Mon, Fiddler, PSS Diag, SQL Profiler, Confidential Azure/Cloud, Accela 9.

Version Tools: TFS, SVN, VSS, CVS

Operating System: WINDOWS 7, 8, 10 Windows Server 2008/2012/2016 DC.

Domain: Banking, Cards, Insurance, Telecom, Confidential Product supports.

PROJECT EXPERIENCE:

Confidential, Tallahassee, Florida

SQL, MSBI, Power BI, SSRS Developer

System Environment: SQL Server 2008/2012/2014/2016 , SQL Mobile Reports, MSBI (SSIS, SSAS, SSRS, PBIRS), POWER BI DesktopPOWER BI Reporting Services, PowerPivot, Power Query, Power View, Power Map, Power Data, Power ShellSQL Profiler, MS Access(Reporting), MS Excel (Pivot, Chart and Macros), VBA, R Server, No SQL (Raven DB)Report builder 3.0, Hyper V, SSDT (SQL Server data tools), Visual Studio 2015/2017, MDX, DAXMicrosoft Azure/Cloud, Oracle, OBIEE, O365, Share Point - SSRS integration, JIRA, ASP.NET, C#/VB.Net, Accela 9.

Responsibilities:

• Followed and implemented the Agile Methodology in the SDLC.
• Developing, testing and deploying SSRS and Power BI reports to production environments and Power Bi Cloud.
• Communicating with report consumers and other stakeholders to elicit and document reporting requirements and propose appropriate solutions
• Developing reporting requirements and obtaining sign off from business stakeholders
• Designing and developing report mock-ups and prototypes
• Helping QC Engineers to develop and execute report testing protocols
• Installation, administration and configuration of SSRS servers
• Development of User Interface using Java script, JQuery, CSS, ASP.NET, C#.Net and HTML, XML, XAML.
• Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions. Deployed generated reports onto the Report Server to access it through browser.
• Provide Level 2 support and fulfilment of service requests for reports, acting as the primary escalation point for the Service Desk
• Develop and maintain operating procedures and support documentation for reports and the SSRS infrastructure and Accela 9.
• Proactively engage on continuous improvement efforts for SSRS/Power BI reports and their operation
• Involvement in relational database design using SQL server 2017/ 2016/2014/2012/2008
• Develop SSRS reports/enhancements, performance tuning and created ad-hoc reports using Visual Studio/SSDT/Report builder
• Involve in project deployment and maintenance on various environments (Development. Training, Staging, UAT, Production)
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas using Tabular model.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries, Stored procedures, Views, Functions and tried to Optimize SQL queries for improved performance and availability.
• Work on migrations from SSRS 2012 to latest versions
• Work on analysis for future solution to Power BI, Power Bi desktop, DAX.
• Experience with a different of programming and scripting languages such as C#, VBScript, Visual Studio, VB.Net, ASP.Net, HTML, XML, Java, SQL, and Crystal Reports.
• Good experience in working with higher environments like SIT, UAT and Production environments. Also experienced in creating DDL scripts like CREATE TABLE, ALTER TABLE, and DROP TABLE for Databases, SQL Jobs, and Linked Server when moved from lower environments to higher environments.
• Good knowledge in Tabular, Multi-dimensional and Kimball dimensional modeling’s.

Confidential, Las Colinas, TX

Support Engineer

System Environment: Datazen, SQL Mobile Reports, SQL Server 2008/2012/2014/2016 , MSBI (SSIS, SSAS, SSRS, PBIRS), POWER BI Desktop, POWER BI Reporting Services, PowerPivot, Power Query, Power View, Power Map, Power Data, Power Shell, SQL Profiler, MS Access(Reporting), MS Excel (Pivot, Chart and Macros), VBA, MSSolve, R Server, MS SQL Server migration assistant for Datazen, No SQL (Raven DB), Report builder 3.0, Hyper V, SSDT ( SQL Server data tools),DOTNET, VS 2017/2015/2013 , MDX, DAX, Confidential Azure/Cloud, Oracle, OBIEE.

Responsibilities:

• Technical leadership: drive VOC and actionable feedback to engineering and operations (25%)
• Escalations: handling customer escalations and able to marshal resources to quickly and effectively address issues (25%)
• Content: establishing the systems and partnerships to create and publish technical content (25%)
• Working on Confidential “Power BI Tools” - including Power BI Reporting services, PowerPivot, Power Query, Power View, and Power Map
• Enterprise deployment experience in complex environments
• Writing SQL, TSQL/PL-SQL Complex queries for extraction of data from/to various up/down streams.
• Writing of Complex stored procedures with high performance SQL tuning skills.
• Expertise in using MSSolve, BSM Remedy tools.
• Working on product support - Datazen, No SQL (Raven DB), SQL Mobile Reports, SQL Server 2014/2016, MSBI (SSIS, SSAS, SSRS), Power BI RS, Power BI - PowerPivot, Power Query, Power View, Power Map, Power Data, Power Shell SQL Profiler, MS Access(Reporting), MS Excel (Pivot, Chart and Macros), VBA, DAX, MDX, KPIs, MSSolve, R Server, MS SQL Server migration assistant for Datazen, Report builder, Hyper V, SSDT( SQL Server data tools), VS 2015/2013, ASP.NET, C#/VB.NET, Confidential Azure/Cloud support, Oracle, OBIEE, Tableau.
• Development of User Interface using Java script, JQuery, CSS, ASP.NET and HTML, XML, XAML.
• ETL troubleshooting, Testing, API
• Troubleshoot complex issues in power BI report server, SQL BI, Security, Authentication, NTLM and Kerberos.
• Involvement in Data Modelling using SSAS Tabular and multi-dimensional model. Also good at connectivity issue with different external data sources like Hana, Oracle, DB2, etc.
• Customer Satisfaction with quality of delivered services measured through CPE targets.
• Delivery Excellence through budget responsibility and meeting Service Level Agreements (delivery against forecasted services and revenue), to include utilization and sourcing mix.

Confidential, Plano, TX

TSQL, SSIS Lead, DOT NET Developer

System Environment: Actuate 9, Primavera Evolve 9, IIS 7.0, MSBI (SSIS, SSAS, SSRS), Crystal Reports, SQL Server, ORACLE, TOAD, Tomcat, Web Logic, J2EE, JSP, MS Access(Reporting), MS Excel(Pivot, Chart and Macros), VBA, JavaScript, JQuery, Power shell, HTML, XML, XAML, CSS, SAP BO,ITSM, ASP.NET, C#.NET, ALM, TFS, SQL Profiler, TSQL, Adhoc SQL and Query analyzer, Agile Methodology, Clarity, RedGate, Unix, API Development.

Responsibilities:

• Worked on requirement gathering, business analysis, development, testing and project coordination.
• Followed and implemented the Agile Methodology in the SDLC.
• Worked on Actuate 9 reporting, Primavera tools for Confidential and Confidential application.
• Involved in relational database design using SQL server 2012/2008 R2and MS access database.
• Involved in enhancements, performance tuning and created ad-hoc reports using Report builder.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report)
• Created and managed database objects and efficiently such as tables, views, clusters, indexes, stored procedures, functions and triggers and referential Integrity.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Worked extensively on Actuate 9, Adhoc SQL, complex queries, debugging and its performances tuning. Used RedGate SQL tool belt for SQL Server development, deployment, backup, and monitoring.
• Created the indexes to improve the performances and also rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Experience with optimization tools for monitoring and tuning using Index tuning wizard, SQL profiler and windows performance monitor.
• Development of User Interface using Java script, JQuery, CSS, ASP.NET and HTML, XML, XAML.
• Involved in implementing the database security levels, finding network latency gaps and installations.
• Development of .net components for reusable for reports in SSRS.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Involved in deploying the SSIS packages and reports to different server using power shell scripting.
• Involved in project migrations and moving SSIS packages from old server to new server using Powershell scripting.
• Worked on multiple complex Cubes, Fact tables and Dimensions.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Involved in ETL/SSIS development process to extracting/transforming/loading data from different data sources using SSIS packages.
• Development of SSIS for creating some flat files with data from the combined database and put files in a FTP folder
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Creating different types of reports by extracting data from tables, stored procedures into reports and customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Developed reports based on a Power BI - Power Pivot workbook and Power View reports using SSRS 2012 and integrated with SharePoint 2013.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Confidential Office Share point Server (MOSS) or share point.
• Worked on unit, system, integration and system testing.
• Works on the deployment, app support documentation to promote the code into production using version control tool.
• Worked with the UNIX and Shell scripting environment to run the scripts faster and data loads from Teradata DB.

Confidential, Plano, TX

SQL Developer, SSIS SSAS SSRS Developer, DOTNET Programmer

System Environment: MSBI (SSIS, SSAS, SSRS), SQL Server, MS Access, JavaScript, JQuery, Angular, HTML5, XML, XAML, CSS3.0, ASP.NET, C#.NET, ITSM, ALM, TFS, SQL Profiler, TSQL, Query analyzer, Web services, Crystal Reports, Agile, Adhoc SQL, Entity Framework, Unity Framework, Unix.

Responsibilities:

• Gathered requirements from business analyst.
• In-depth knowledge of T-SQL (DDL, DML, DSL, and SQL CMD), Adhoc SQL.
• Created relational data base design, database schema and database objects like tables, stored procedures, indexes, constraints, triggers, views, cursors and functions.
• Involved in dot net development and unit testing.
• Development of User Interface using Java script, JQuery, CSS and HTML.
• Rebuilding the indexes at regular intervals for better performance.
• Created Parameterized reports, Cross-Tab reports, Drill down reports, drill through reports, Sub Reports & Summary reports by Using SSRS.
• Developed complex Cubes, Fact tables and Dimensions.
• 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.
• Worked extensively on complex queries, performances tuning and Query Optimization.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the Development and Production environments.
• Involved in migrating SSRS reports from SQL Server 2005 to SQL Server 2008/2008R2/2012.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Worked on unit/system testing, deployment and documentation to promote the code into production.
• Created Dynamic Charts/Graphs in MS Excel (Pivot, Macros) and MS Access using VBA.
• Developed the database security levels, Network latency and installations.
• Followed the Agile Methodology in the SDLC.
• Worked on ASP.Net entity framework, Unity framework and developed business layer in the project.
• Implemented Service broker to send data from Confidential to different interfaces.
• API development after the flat files process placed in SQL DB.

Confidential, Glastonbury, CT

SQL Server/BI Developer/FE developer

System Environment: MSBI (SSIS, SSAS, SSRS), SQL Server, MS Access, JavaScript, JQuery, HTML, XML, XAML, CSS, ITSM, ALM, VSS, SQL Profiler, TSQL,VB6, VBA, EZLynx(Rating Engine), LexisNexis(for legal and public-records related information), Book Smart, Mainframe, ASP.NET, Entity Framework, Adhoc SQL.

Responsibilities:

• Gathering requirements, design, Data Modeling and Implementation.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Adhoc SQL, Data modeling, Relational database design, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, CSV, XML, XAML, Excel, UNIX and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Worked on Cubes, Fact tables, Dimensions and MDX Queries.
• Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved in mainframe data analysis and querying with mainframe.
• Involved in front end C#.Net, ASP.NET entity framework development process.

Confidential, Carol Stream, IL

SQL Server Developer, SSIS SSRS SSAS Developer

System Environment: MSBI (SSIS, SSAS), SQL Server2008R2,Oracle, TOAD, MS Access, JavaScript, JQuery, HTML,XML, XAML, CSS, TFS, SQL Profiler, Adhoc SQL, TSQL,ASP.NET, VB6, VBA,SAS, Teradata, Excel exports, Flat files, Silverlight.

Responsibilities:

• Involved in designing the database, data modeling and front end form design.
• Expert in creating tables, writing and debugging complex quires, stored procedures, functions, referential Integrity constraints, views, indexes and DML/DDL, Adhoc SQL.
• Performed Index analysis for tables and came up with Confidential efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Rebuilding the indexes at regular intervals for better performance.
• Developed DTS packages for transferring the data from source to destination between MS Excel, Flat Files, XML, HTML, XAML and SQL Server.
• Extensively used DTS Import/Export Wizard, for performing the ETL operations.
• Worked on existing SAS code and converting the logic SAS to .NET and VBA.
• Involved in migration DTS packages to SSIS packages.
• Develop various SSRS reports using report wizard and report designer.
• Designed various types of SSRS reports like table, matrix, rectangle, sub reports, drill down, charts with custom report items and used sorting, multivalued parameters.
• Experience in creating, developing and Publishing Reports.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in relational database design process and data modeling process.
• Involved in Silverlight forms preparation and implemented in the project for rich look of the web pages.
• Used ASP.NET, C#.NET for creating control libraries and validations and custom controls.

Confidential, Plano, TX

MSBI, SQL, DOTNET Developer

System Environment: MSBI (SSIS, SSAS, SSRS), ASP.NET, C#.Net, Web Services, Crystal Reports, SQL Server, MS Access, VBA, VB6.0, JavaScript, HTML, CSS, ITSM, HP ALM, TFS, SQL Profiler, TOAD, TSQL and Query analyzer, Silverlight, Adhoc SQL.

Responsibilities:

• Participated on daily onsite calls.
• Gathering requirements and implementation.
• Involved in developing the code and designing the forms.
• Implementing Excel Pivot tables and charts using dot net.
• Worked on requirement gathering, business analysis, development, testing and project coordination.
• Worked on Silverlight to rich look of the application front end.
• Involved in creating TSQL- tables, writing and debugging complex quires, stored procedures, functions, referential Integrity constraints, views, indexes and DML/DDL