SUMMARY:

• Over 8 years of IT Professional experience in Development, Client Analysis, Database Design and Implementation using SQL Server 2016/2012/2008/2005.
• Experience in Design, Development, Implementation and Maintenance of Data warehouse applications as an ETL Developer in MS SQL Server as well as tools like SQL Server BI Tools (SSIS, SSRS& SSAS) in domains Banking, Energy and Utilities and in financial services.
• Extracted data into Data warehouse Facts and Dimensions tables using SQL SERVER 2000/2005 Integrated Services (DTS/SSIS).
• Used 2012, 2014, 2016 versions of SSAS to develop tabular models and expertize in performance tuning of Tabular cubes
• Expertise in creating OLAP cubes and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Expertise in designing efficient processing strategies of SSAS Cubes for both incremental and full processing options.
• Expertise in implementing complex DAX, MDX calculations to solve complex business scenarios
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Experience setting up reporting platforms ground up in Microsoft technology stack (Sharepoint, SSRS, PowerBI, PowerPivot, SSAS, DAX,MDX,T - sql, Dimensional Modeling, SSIS)
• 4+ years of experience with PowerPivot
• Used Power Query to acquire data and PowerBI desktop for designing rich visuals
• Good experience with of BI semantic model and how Microsoft's Business Intelligence stack (SSAS cubes, SSRS, performance point, PowerPivot) fits into Sharepoint
• Proficient experience in Multidimensional expressions.(MDX).Created Complex MDX Queries.
• Very good experience and knowledge on SCD Types (Type1, Type2) and Change Data Capture.
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Experience in Microsoft SQL 2012 Server migration from SQL Server 2008/2005, Integration Service (SSIS), Crystal Reports and Reporting Service (SSRS).
• Expertise in High Level Design of ETL SSIS Packages for integrating data from sources (Excel, CSV, flat file, Text Format Data)
• Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Proficient in using T-SQL for creating Stored Procedures, Tables, Views, Indexes, SQL joins and performance based query writing.
• Extensive experience in T-SQL to write: stored procedures, triggers, functions, tables (including Partitioned Tables), views, indexes and relational database models.
• Expertise in extracting, transforming and loading (ETL) of data using SSIS Packages.
• Expertise in writing performant MDX, DAX queries against cubes for SSRS datasets
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS …
• Expert in developing Drill through and Drilldown reports using MS SQL Server Reporting Services (SSRS)
• Extensively used performance monitor/SQL profiler/DMVs to solve dead locks, to monitor long running queries and trouble shoot cubes
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled SSIS Packages based on Business or application needs
• Experience developing dashboards using performance point services 2010, SSRS and deploying to the SharePoint.
• Experience in migration of Data from Excel, Flat file and Teradata to MS SQL Server by using SSIS packages
• Experience working on OOPS programming style with respect to C# language.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Experience to assist client in on boarding various application server on AWS Cloud and VMware Private Cloud.
• Design complex solutions which integrate AWS cloud, on premise physical and Virtual server, EC2, S3 storage, networking and security.
• Extensively used tools like SQL Profiler, SQL Analyzer and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Expert in database backup, restore, Database mirroring and log shipping and implemented replication as high availability techniques.
• Extensively used repositories Team Foundation Server (TFS) and Cheetah.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Experienced in using various client tools such as SSRS, PerformancePoint, PowerPivot, Power View, Power BI desktop and good understanding of dashboard design patterns and visuals

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/XP, basic UNIX

Databases: SQL Server, MySQL, PL/SQL, Oracle, DBA,DB2

Management Tools: DOMO,SSIS SSRS,ORACLE WFM, ORACLE WMS,EXCEL,MICROSOFT ACCESS,QUICK BOOK, PerformancePoint, PowerPivot, Power View, Power BI

Methodologies: Agile, Scrum, UML, Waterfall

Testing: Jira, TestRail, Test Director, UAT

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

MSBI/Power BI Sr. Developer

Responsibilities:

• Involved in gathering business requirement from business users and prepared BI technical specifications.
• Created various data models like Flattened, Star schema in SSAS - Tabular model / PowerPivot.
• Designed a Power BI based solution by integrating the data from On Premises, Cloud, Source Files, Static data.
• Delivered final Power BI report as internet link, embedding in SharePoint/Custom Application/Office Tools.
• Implemented various business scenarios like Ranking, Band Ranging, Many - to Many Relationship, ABC Analysis, What If Analysis, New Customer / Non Performing Customer, Basket Analysis, Multiple relationship with table etc
• Used DAX expressions like CALUCLATE, RankX, KEEPFILTERS, EARLIER, USERELATONSHIP, LOOKUPVALUE.
• Created interactive and real time Power Bi reports using various sources like SSAS, Excel OnLine, OneDrive.
• Created a custom Content Pack in Power BI and published it across to specific user groups / entire organization.
• Deployed Excel based Power Pivot built on SSAS cubes gives users capability of slicing the measurable data based on various dimension.
• Implemented SQL server 2014 latest features like Project level Deployment, Project Parameterization, GUID etc.
• Embedded Power BI Reports in Office tools using Power BI Tiles based on REST API method.
• Currently working on POC for real time data analysis in Power BI using Azure / Json / RESP API / IoT.
• Migrated the data from on premises SQL server to Cloud based Azure databases.
• Optimized SQL Queries and Stored procedure for improving the performance of report generation.
• Implemented error logging for better trouble shooting the long running batch and reporting jobs.

Environment: Power BI Desktop, SSIS 2014, SSRS 2014, SQL 2016, Azure, DAX, Python, PowerShell, Active Batches.

Confidential, San Ramon, CA

Sr. SQL Server Developer/BI Developer

Responsibilities:

• Gathered client requirements and specifications and performed analysis, design, development, deployment and user training.
• Create and maintain clearly written technical, user, and system documentation.
• Worked on Data Extraction, Transforming and Loading (ETL) using various tools such as SSIS and Bulk Insert.
• Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Created T-SQL (DDL and DML) scripts for RDBMS applications.Created and developed stored procedures, triggers, functions to handle complex business rules, history data and audit analysis.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Wrote SSIS Packages to migrate user's logins, stored procedures and functions.Involved in designing the SSIS packages to export data from SQL Server to flat file source.
• Effectively worked in production support and managed the quality assurance for SSIS packages.
• Effectively loaded data into relational database using ETL tool.Migration of SSRS reports from SQL 2012 to SQL 2014.
• Analyzing stored procedures, SSIS packages and underlying data models using SQL Server Management Studio (SSMS).
• Designed Graphical and Tablix reports using SSRS.Tested different types of reports before moving it to the production
• Integrated SSRS and Crystal Reports with .net application automatically passing the report parameters from the application and defaulting to the desired output to a certain format if required.
• Performed SQL Server tools like SQL Performance optimization using SQL Server Profiler and Database Engine Tuning Advisor
• Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.

Environment: SQL Server Business Intelligence Development Studio, T-SQL, Microsoft Visual Studio, SQL Server Management Studio, SQL Server SSRS/SSIS/SSAS, SSMS, SAP BO Crystal Reports, ETL, MS Excel.

Confidential, SFO, CA

Sr. MS SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Created SQL Server Reports based on the requirements using SSRS 2012,2014
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in creating XML files by designing the SSIS packages and SQL server.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Worked very closely with Business Customers, End Users and resolved any business process related issues.
• Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse. Periodically developed a Report to be used by the Senior Management utilizing SSRS.

Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2014/2012/2010/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, DMV Sacramento,CA

Sr. SQL Developer

Responsibilities:

• Assist the business in identifying, understanding, and documenting their business needs, including the applications capable of supporting those requirements and identify procedures that are cost effective and meet business requirements.
• Developed Complex parameterized MDX, bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI's on SSRS Reports.
• Collect and document business processes as well as business rules.Translate the business needs into system requirements; communicate with the business on a non-technical level, and with the System Analyst on a more technical level. Perform gap analysis.
• Document and deliver Functional Specification Document to the project team. Conduct User Acceptance Testing (UAT).
• Develop test scenarios and implement test plan providing key input in working with users in defining project and system requirements. Conduct project related presentations.
• Performed Role of offshore coordinator and developer, involved in many business level meeting to understand the requirements.
• Small enhancement work: Analysis, find root cause & implementation.
• Handling Incident Tickets with different priority in Global Service Desk.
• Implementing various changes in Production Environment in PL/SQL which is embedded inside UNIX environment, this acted as a source from where our sql server database is the destination.

Environment: Agile/Scrum, Microsoft Office Products (Word, Excel, PowerPoint), MS Visio, DB2,UAT, Sybase, SQL .Ms Project 2010,Release Coordination,Ticketing,MS Share point.

Confidential

SQL Developer

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Improved SDLC through in corporation of new level of detail in requirements/design documents
• Worked with Product Owner/Intent Owner to translate requirements into user stories.
• Identified business process and developed activity diagrams for loan preapproval, loan application and loan process with the help of MS Visio.
• Excellent understanding of SQL RDBMS, ability to read and understand data flow diagrams and ERD.
• Experience in working with all kinds data formats to create reports using SQL, Excel and SAS.
• Applied Agile Methodologies for the project and used practices such as Program Backlogs, Iteration Backlogs and Daily Standup Meetings.
• Involved in Designing and implemented basic SQL queries for QA testing and report/ data validations.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.

Environment: Microsoft Office Products (Word, Excel VLOOKUP, Pivot Table, PowerPoint), SAP CRM, EQRS.