SUMMARY

• Successful SQL Developer/Business Intelligence Developer with 7+ years’ experience in building complex scripts and queries for data analysis and extraction.
• Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.
• Strong experience in Business Intelligence and implementing Web based and Stand - alone software application with major focus on Data Warehousing and Database applications.
• Experience in Healthcare domain and Extensive experience as SQL Developer and MSBI Developer to building projects and creating reports, cubes and Dashboards.
• Seeking the position of a MSBI Developer to contribute my technical knowledge in Data Marts, OBIEE, PL/SQL, ASP.NET, X-Celsius, OLAP Cube, MSSQL, T-SQL, SSIS, SSAS and SSRS and help in organizational growth and development.

TECHNICAL SKILLS

BI Tools: SSAS, Power View, SSRS, PerformancePoint, PowerPivot, SSIS, Power BI, SQL Profiler, Query Analyzer, DTS, BCP, Enterprise Manager.

Databases: MS SQL Server 2012 /2008 R2/2005, Oracle 9i/8i, Azure.

DB Design and Data Modeling Tools: Erwin and Toad, Microsoft Visio, Start Schema, Fact and Dimensions Table

Query Language: SQL, T-SQL, Teradata SQL, PL/SQL, Oracle SQL*Plus, MDX, DMX Functions.

Web Technology: HTML, DHTML, XML, SFTP

Scripting: PowerShell 3/2/1

Operating System: Windows 2012 R2, Windows 2008 R2, Windows 2003 SP2, Windows 7 and 8.1

Tools: and Utilities: Business Intelligence Development Studio

Version Control: TFS, Visual Source Safe

ITSM Tools: HP Service Center, Service Now, Remedy

Programming Languages: C, C++ and C#, VB Script, Asp.net, .Net framework 4.0, MVC

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Problem solving, Decision making, Cross-functional team building and leadership, Critical thinking, Performance management

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. MSBI/SQL Developer

Responsibilities:

• Architect the Microsoft Business Intelligence Solutions utilizing MS SQL Server 2012 SSIS, SSAS, SSRS, PowerPivot, Power View, integration with Excel and SharePoint, Management Dashboards, and Operational Business Intelligence.
• Design, construct, deploy, test and support data storage in relational and multi-dimensional database technologies
• Design, construct, deploy, test and support standard reports, dashboards, self-service queries and data visualizations for end-user consumption
• Proficient working with MS Excel including advanced formulas, pivot tables, macros, lists, statistical functions, etc.
• Experience in Analysis, Design, Development, Testing and Implementation of Crystal Reports 8.5/9/10/XI R2/2008, Crystal Enterprise 8.5/9/10
• Experience in Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports)
• Experience working with SQL Databases in the Azure platform. Connected to Azure SQL database to create SSRS reports
• Expert in designing high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Assisted in development, maintenance and optimization of OLAP cubes and data sets.
• Created Tabular Cubes using SSAS
• Experience in implementation of data cubes
• Designed MDX queries to retrieve data from SSAS cubes.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Involved in performing Audits and recovery operations of SSAS objects.
• Conducted detailed analysis and understanding of existing business requirements to produce technical designs.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP/OLTP databases.
• Up on Special Request from the user’s new tables are added to the existing schema for the Transformation
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Created analytics for various functions according to data quality and latest trends
• Design, development, testing and deployment of data integration packages using Microsoft SQL Server Integration Services (SSIS), including the ability to develop ETL processes to load data warehouse applications
• Experience in design and data warehouse development including replication, staging, ETL, stored procedures, triggers, scheduling tools and data marts
• Strong MS SQL Server 2005/2008/2008 R2/2012 Developer skills including writing stored procedures, user-defined functions, triggers, views, and indexes, etc.
• Database and report development experience with Visual Studio, Excel Services, PerformancePoint, Power View and ER/Studio
• Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications
• Coordinating actions among developers, production control, DBA, infrastructure team and project vendor to implement out the ETL scripts and objects.
• Perform and maintain performance of data warehouse by identifying and resolving data conflicts, optimizing databases, networks and hardware.
• Experience in writing Stored procedures, triggers, functions and other programmable objects
• Assisting with sourcing and reporting on various data projects including data sourcing, developing import packages in SSIS
• 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.
• Collaborated with data warehouse team members in designing of data marts along with reporting.
• Deploying SSRS reports
• Experience Installing, configuring, maintaining, upgrading and managing SSRS Server
• Provide administrative guidance & technological recommendations in SSRS
• Developing complex SSRS reports including parameters, drill-down, and row-level security based on the person executing the reports
• Hands on experience on tableau and Cognos
• Occasionally involved in Development of web applications using ASP.NET, C#, MVC, HTML,
• Database development - SQL Server including SQL Queries, database design
• Responsible of SSA disability systems or claims administration processes for large health or human services organizations
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace in Teradata
• Engage with Architects & Senior leader team on drill down sessions on Windows Azure and other key components of the Microsoft Cloud Strategy
• Articulate the best practices in cloud computing solutions using the Windows Azure platform
• Integrate applications and perform data migrations using SQL Server or MS Access
• Responsible for managing and overseeing data architecture being performed by a Data Architect
• Updating and designing reporting databases and handling the data transformations
• Participated in learning and updating of business processes, functional relationships and information usage.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process. purpose and created Application objects on top of them for the SSRS Reports.
• In order to support the special reports a new reporting table created in schema.
• Designed and Developed Schema Tables, Attributes, Facts, Hierarchies, Metrics, Filters, Prompts, Custom Groups, Consolidations, and Reports
• Created the transformation tables and developed schema and public objects on top of them to include in the reports, which can compare current month vs. prior month, current quarter vs. prior quarter & prior year quarter, current Year vs. prior year.
• Used Advanced Prompts, Non- Aggregate Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Involved in creating the Technical Documentation for Developers and Checklists for the users for the BI Projects.
• Familiar with Micro Strategy and Excel Pivoting
• Communicating and Planning of tech and business technique with framework teams.
• Assisted in development and maintenance of logical and physical data models.
• Coordinated with business partners for identification of improvement opportunities.
• Looking closely of project status and communicating with the management.

Environment: SQL Server 2008 R2/2005, DTS, SSIS, SSAS, SQL 2005 Business Intelligence Development Studio (BIDS), Azure, Import/Export tools, PowerPivot for Excel on SharePoint, SQL Server Agent, MS Access, T-SQL, ERWIN, MVC, C#

Confidential, Milpitas, CA

SQL/MSBI Developer

Responsibilities:

• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Performs all troubleshooting, operations & maintenance activities in support of a SQL Server 2012 cluster
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Created Workspace and content packs for business users to view the developed reports.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database Refresh tasks from production to Development and Staging Servers
• Created stored procedures and SQL queries to pull data into power pivot mode
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks

Environment: SQL Server 2008/2005, Business Intelligence Development Studio (BIDS), Windows 2008/2003 R2, MS TFS, MS-Access

Confidential, Orange County, CA

BI Developer

Responsibilities:

• Generated dashboard for Billing and Deposit Systems
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis.
• Initiated budget forecast, analysis, variance reports and generated ad-hoc reports for management for review.
• Executed monthly financial modeling, budget improvement, processed expense reports and implemented time series modeling in OBIEE.
• Provided security and user roles for all the users of the various modules
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Understanding of Business Model development using different functionalities like Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Function using Expression Builder
• Used OBIEE Admin Tool to develop three layers of repository and analyzed current business intelligence or trend data to support recommendations for action.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope
• Prepared monthly Sox Reporting Package for management by importing data into the repository and producing interactive reports

Environment: SQL Server 2008/2005, T-SQL, Tableau, JavaScript, TFS

Confidential

Junior BI Data Analyst

Responsibilities:

• Involved in installing and maintaining MS SQL Server 2000/2005.
• Created Data Model or the Marketing Information System Team using Erwin.
• Collaborates with multiple teams (onsite and virtual) and acts as a liaison between different business units and IT team in gathering requirements to be used in developing reports using business analytics tools used by the company
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Builds business dashboards which shows market trend analysis of online retail metrics
• Provides business recommendations to decision-makers on how to increase sales revenue, retain and attract more customers and strengthen online presence.
• Leads the measurement of Paid Search performance, customer analytics, category analytics and program tracking and optimization.
• Coordinates with different departments such as Accounting, Supply Services, Marketing, Sales, and Operations.
• Collaborated with power users and IT management teams to streamline business reports and identify all end users.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.

Environment: Windows 2003/XP, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS, ERWIN.