SUMMARY

• Over all 8 years of experience as Microsoft Business Intelligence (MSBI) applications Developer in software analysis, requirement, design, application development, testing and support.
• Expertise in ETL Developer using SQL Server Integration Services 2008 and 2012.
• Hands on experience on SSIS, SSAS, SSRS, MDX, T - SQL, PL SQL, Power Pivot and Power View reports.
• Extensively used various SSIS objects like Control Flow components, Data flow components, Connection Managers, Shared Data sources.
• Experience in developing and designing reports on SQL Server Reporting Services(SSRS).
• Expert in deploying, scheduling and debugging reports in SSRS.
• Good hands on experience with SQL Server 2016/2014/2012/2008/2005 , SSIS, SSRS, SSAS and T-Sql.
• Extensive knowledge in Tuning SQL queries, improving the query performance & trouble shooting.
• Extensively involved in writingSQLqueries (Sub queries and Join conditions), co-related sub queries, in-line views andPL/SQLprogramming.
• Performance Tuning like identifying long running queries, Open Transactions, Blockings, Deadlocks, Trace Flagsetc.
• Managed slowly Changing dimensions (SCD) and optimized fact table inserts.
• Expert in creating Databases, tables, clustered and non-clustered indexes.
• Expert in creating indexed Views, complex Stored Procedures,effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Extensive experience in Information Technology with special emphasis on design &developmentof Database/Data Warehousing/Client-Server applications.
• Experience in developing the applications usingT-SQLProgramming (DDL, DML, and DCL).
• Proficient in creating T SQL (DML, DDL, DCL and TCL), Indexes, Views, Temporally Tables, Table Variables, Complex Stored Procedures, System and User Defined Functions.
• Expert in creating Calculated Measures and Dimension Members using Multi-Dimensional Expression (MDX), Mathematical Formulas, and User-defined functions.
• CreatedPowerBIVisualizations and Dashboards as per the requirements.
• Worked onPowerView andPowerMap to visualize reports.
• Experience inreportwriting usingSQLServer Reporting Services (SSRS) and creating various types ofreportslike Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Good knowledge of Data Marts,Data warehousing, OLAP, OLTP, Dimensional Data Modeling, Star Schema Modeling,Snow-Flake Modeling, FACT and Dimensions Tables.
• Expertise in Developing and Extending SSAS Cubes, Partitioning,Data Mining Models, Deploying and Processing SSAS objects, writing MDX queries.
• Familiar with Agile development and waterfall methodologies.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.
• Excellent logical and analytical skills to solve complex problems.

TECHNICAL SKILLS

Databases: SQL Server 2016/ 2014/2012/2008 R2/2008/2005, MS Access

Languages: SQL, T- SQL, PL/SQL, XML, C#, JavaScript, .NET, HTML, CSS

Operating Systems: Windows NT/2000/XP/7/8/8.1

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

Tools: Red gate, lit speed, Scom, fog lite, for SQL Source Control and database comparison and Performance monitoring.

Other Software: MS Office- 2013/2010/2007/2003

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, SQL Diagnostic Manager.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio- TX

Senior SQL BI Developer

Responsibilities:

• Created new ETL packages to validate, extract, transform and load data into datawarehouse databases, data mart databases using SSIS packages.
• Used various Transformations in SSIS Dataflow, ControlFlow using for loopContainers and FuzzyLookups etc.
• Designed and developed SSISPackages to import and export data from MSExcel, Teradata SQL Assistance,SQLServer and Flat files.
• ScheduledSQLJobs and SSIS packages to run Confidential regular intervals to automate processes and maintain data consistency and to achieveincrementalupdates of target data keeping in mind SLA's, dataintegrity and security.
• Analyzed existing OLTPdatabases and created ETL packages in SSIS to export historical usage data-to-data warehouses, after validating for market specific business rules.
• Reviewed & Tested packages, fixingbugs (if any) usingSQLBusiness Intelligence Development Studio.
• Creating and ModifyingTables, StoredProcedures, Views, Indexes, User-defined Functions, and Triggers as required and promoted the changes in requested environment.
• Developed stored procedures for the application using SSMS2014. Created packages for moving data from the Teradata Enterprise Data Warehouse to SQL Server production database.
• Experience with data analysis using OLAP and OLTP systems including facttables, dimensions and measures, schemas like starschema, snowflakeschema and extended star schema.
• Designed and developed multidimensional OLAPcube using SSAS. Created custom calculated members using MDX queries.
• Designed cubes with starschema usingSQLServer Analysis Services (SSAS) and created Databases to be used for reporting using SSRS.
• Actively involved in Agile (Scrum) meetings discussing the requirements, integration of modules and best development practices for solution.
• Maintained build and code versions using Team foundation Server (TFS).

Confidential, Pittsburgh - PA

Sr.MSBI Developer

Responsibilities:

• Involve in software development Life cycle (SDLC) and participated in scrum meetings with team.
• Involve in requirement gathering and calls with clients.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports, Matrix Reports
• Coordinated theODMand ETL integration to in cooperate the business rules and source definitions.
• Developed complex SSIS packages for data retrieval and cube processing automation.
• Create DAX and VB scripts for Excel reporting and calculated members.
• Use SSIS for data processing on daily basis and automation.
• Created procedures and functions usingPL/SQL.
• Experience in OLAP/OLTP, Data Integration/Mapping/Cleansing and Master/Operations Data Management (MDM/ODM).
• Developed C# tool to update and populatedestination tables schema based on source tables/ excel files
• Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server totableau/ SSRS.
• Implemented the concepts of Incremental Data Load,SlowlyChangingDimensionsfor updating and maintaining the history of the records
• Created Listreports, cross tabreports, charts, sectionalreports, & Drill throughreportsby usingReportstudio.
• Deep Expertise inCognosBusiness Intelligence with emphasis in designing and developing Relational and Dimensionally Modeled Relational (DMR) Framework Manager Models against EDW, ODS, and OLAP data sources
• Worked with database team to create the data models to be used inCognosreporting, and Infrastructure and Architecture teams to setupCognosenvironments for development and QA testing
• Defining relationships betweenDimensionsand Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Generating Reports as per the requirement using SSRS 2005/2008.
• Responsible for creating Drilldown, Drill through OLAP reports using SSRS 2012.
• DevelopedEntity-Relationship modeling for OLTP system using MS Visio 2007.
• Worked in production support team to support, debug SQL code and SSIS packages to fix any failures.
• Created materializedviews, dimensions and stored outlines for optimalperformance.
• Responsible for creating use cases for datamart and cubetesting and also performed initial validations to check data consistency.
• Worked on datacompressions and backupcompressions, completedeployment to production and verification.
• Understand legacy OBIEE reports, and coming up with data points, create understanding and guidelines documents for business users.

Confidential, San Diego, CA

MSBI Developer, SQL Developer.

Responsibilities:

• Created SSIS Packages to import and export files from Database and load data in to the target servers/locations.
• Deploying SSIS Packages to QA, and UAT and Production servers, Scheduling deployed Packages.
• UsedSSISto create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases.
• Scheduled Jobs for executing the storedSSISpackages which were developed to update the database on daily basis using SQL Server Agent.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Term, SlowlyChangingDimensionand more. Performed ETL mappings using MS SQL Server Integration Services.
• Used SSIS extensively for data loading with different source and destination connections.
• Used various transformations like UNION, MERGE, LOOKUP, CONVERSION, DERIVED COLUMN, AGGREGATIONS.
• Responsible for writing T-SQL (DDL/DML)Queries, Stored Procedures, Views, Functions and Triggers.
• Involved in writingT-SQLstatements for retrieval of data.
• WritingT-SQLscripts for re-running failed jobs, restoring databases, and application security settings
• Worked extensively with debugging, defect tracking and troubleshooting issues.
• Responsible for migration of databases from old SQL server versions to SQL Server 2005/2008.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues withinTableau Server and Reports
• Create scorecards and dashboards to empower reports from OLTP, OLAP and reporting tables using SharePoint Insight andPowerBIsheet.
• Design, Develop and Deploy MicrosoftPowerBIreports.
• Implemented the changes/modification like iterative/incremental development and used .NET Framework and Object Oriented Methodologies for application development by using agile scrum methodology.
• Worked on business metrics and customer experience project queries to better understand customer experience focus areas for upcoming projects; utilized data in Weekly Business Review reports. Performed UAT on cube built in OBIEE, deriving reports to ensure they met SLAs and showed top rejection reasons for traded items (KPIS).
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis.
• Created DAX and VB scripts for Excel reporting and calculated members.
• Written Stored Procedures usingPL/SQLand functions and procedure for common utilities.
• Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
• Generating Reports as per the requirement using SSRS 2005/2008.
• Developed Entity-Relationship modeling for OLTP system using MS Visio 2007.
• Responsible for creating use cases for data mart and cube testing and also performed initial validations to check data consistency.

Confidential, Redmond, Washington

MSBI Developer, SQL Developer

Responsibilities:

• Worked on all aspects of MSBI (SSIS, SSAS), Power pivot.
• Implemented Cube Security, ETL mails, quick changes to whole solution in case of requirements.
• Communicating with the client for collecting the requirement, document them, implementation the same.
• Identifying and documenting the technical issues and the approach to resolve the same.
• Scheduled daily refresh jobs from SQL Server agent, and provided support in case off ETL failure.
• Use variousSSIStransformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Involved in schedulingSSISpackages in multiple servers using SQL Server Agent.
• Implemented DAX (Data Analysis Expressions) functions forSSAStabular models and Excel pivot tables.
• Implemented DAX to create various calculations (such as MTD actual totals, MOM and WOW comparisons - based on current month/week, previous month/week, average product review ratings).
• Optimized theSSAStabular model process speed by properly designing data models and optimizing DAX calculations.
• Synced up with source teams regularly and fixed ETL issues.
• Involved in end to end systemdevelopment and design of the project.
• Provided solutions to automate ETL.
• Communicating with the offshore team for getting the status of work, and making it done if any work pending.Supporting the in project set up and meeting if needed, identifying the issues and trying to resolve them.
• Provided support to down streams regularly who are using reports.
• Implementing slowly changing dimensions to maintaining Historical data in required dimension table.
• Written the Stored Procedures and functions, Involved in the performance Tuning.

Confidential

SQL Developer

Responsibilities:

• Used the SSIS to migrate Databases such as Oracle and Access database, flat files to centralized IT destination.
• Responsible for Developing, Monitoring and DeployingSSIS packages.
• Successfully created dynamicconfiguration packages in SSIS.
• Used Event Handlers for Exception Handling in SSIS packages.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8 minutes.
• Created many complex Stored Procedure/Functions and used them in Crystal Reports directly to generate reports.
• Involved in Creation of Crystal Reports, created ODBC Connections and database connections.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Reports.
• Created Stored Procedures, Views and user defined functions to store the data of clients, advisors.
• Created User Defined Functions, Triggers 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.
• Documenting the business requirements and converting them in to technicalrequirements to start the development phase of the system.
• Designed and Developed Universes and resolved loops by creatingAliases and Contexts.
• Derived key performance indicators or financialreporting modeling with support of complex calculations. Other BI applications merge BI analytics with data collection for budgeting, planning, and forecasting.