SUMMARY

• 9 Years as an experienced BI Analyst, and MS SQL Server Development experience in Finance, Manufacturing & Distribution, Gaming, Telecommunications, Healthcare/Insurance Industry and Excellent noledge about health care industry and claims management wif expertise in MS SQL Server 2005/2008/2008R2/2012,2016,2017 TERADATA and Microsoft’s suite of products like SSIS, SSAS, SSRS and Power BI. Wif an (MBA), and Finance and Management background, me has a strong analytical approach to business analysis and management.
• Handled multiple assignments simultaneously and successfully identify and coordinate key deliverables wif stakeholders in cross - functional groups. Passions include ensuring data quality, scalability, performance, integrity, and security, as well as standards development and process improvement
• Interpreting and working wif data models, data flows and data dictionaries, logical & physical Data modeling, data architecture design etc. Analyzing the Source System Data Model
• Very Good Experience in Designing the Logical and Physical Data Models
• Writing heavy stored procedures, Audit triggers, Views, Creating SQLScripts for data loads and Upgrades for data migrations and data validations.
• Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, Efficient coding standards.
• Proficient in PerfTuning/Query optimization using Indexes using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor (DTA), DMV’s, DMF and reading Execution plans
• Versatile experience in being involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance wif timely delivery against aggressive deadlines.
• ImplementedADO.Netdata access techniques me.e. SQL Connection Objects, SQL Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects using Data Grid and Data List inADO.Net.
• Demonstrated expertise in MS SQL Server 2008/2005 and Microsoft Business Intelligence (MS-BI) tools like SSIS (MS SQL Server Integration Services), SSRS (MS SQL Server Reporting Services), SSAS (MS SQL Server Analysis Services) and T-SQL scripts.
• 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.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Oracle, Flat file, CSV) by using multiple transformations provided by SSIS.
• Proficient in usage of SSIS Control Flow items (For Each Loop, For Loop & Sequence container, execute package, execute SQL tasks, Script task, send mail task) and transformations (Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast).
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent and Deployed SSIS packages to different environments.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Worked on C#, ADO.NET, ASP.NET, Web Services, Visual Basic, Script, XML, HTML, Database programming.
• Redesign C# code to improve performance of web application
• Experience in understanding of Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
• Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions
• Excellent hands-on experience wif data modeling tool like Erwin and strong noledge of Relational and Dimensional database modeling concepts wif star schema and snowflake schema’s design and implementation.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Designed Data Model inPowerBIsuch as Fact and dimensional tables and relationships.
• PublishedPowerBIreports to end user via mobile and content packs.Created Groups, content packs, Enterprise gateway inPowerBiPro, developed multiple dashboards wifPowerBIdepicting differing KPIs for business analyses.
• Generated Monthly, Yearly, Quarterly and daily reports inpowerBI
• Collected user activity data, log data using Kafka for real timeData Analytics
• Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions
• Successfully Migrated 5 QlikView reports to Power Bi Model
• Retrofitted QlikView Reports into Power BI
• Implemented pivot/un-pivot, transpose features ofPowerBIto load data into excelPowerPivot.
• Employed bar charts, bubble charts, andPowermap to answer business questions wifPowerBI.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), TableauandPOWERBI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, PowerBIand Excel to provide better data visualization.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer wif (Pivot table, Get Pivot Data, Dashboards),PowerView,PowerMap and Heat Map.
• Expert on Microsoft PowerBIandTableaureports, dashboards and publishing to the end users for executive level Business Decision.
• Expert on maintaining and managing TableauandPOWERBIdriven reports and dashboards.
• Experienced in managing users, groups, sites, permissions and roles on Tableauserver

TECHNICAL SKILLS:

RDBM/Databases: MSSQL Server 2000/2005/2008/2012/2014,2016,2017 Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007, MYSQL.

Programming Languages: T-SQL, PL/SQL, Dynamic SQL, C, JAVA, MDX, XML, HTML, DHTML, Shell Scripting, JavaScript, Visual Basic 6.0, ASP .NET.

Data Modeling: MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access.

ETL-Tools: SQL Server Integration Services (SSIS), Informatica.

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012,2015), SQL Server Reporting Services (SSRS 2005/2008/2012) SQL Server Analytical Services (SSAS 2005/2008/2012), Power BI, QlikView, Tableau Visual Studio, BIDS.

Tools/Database Utilities: SQL Server Management Studio 2017, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0, Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007/2010, VBA.

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

SR. Business Intelligence Developer

Responsibilities:

• Analyze business requirements, designs and write technical specifications to design/redesign solutions.
• Created Logical Data Flow Model from the Source System study according to Business requirements on MS Visio.
• Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.
• Working on the Teradata stored procedures and functions to confirm the data and has load it on the table.
• Working on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
• Working closely wif analysts to come up wif detailed solution approach design documents.
• Prepared low-level technical design document and participated in build/review of the BTEQ Scripts, Fast Exports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
• Executed SQL conversion pre-validation and post-validation scripts to avoid data loss and to make sure that the Count, redemption amount for each source matches the data loaded in EDW.
• Good noledge & experience on Cloud Computing like Azure/AWS
• Done the impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in a production environment.
• Provided quick production fixes and proactively involved in fixing production support issues.
• Has strong noledge in data mover for importing and exporting of data.
• Creating and maintaining Source-target mapping documents for ETL development team.
• Providing requirement specifications and guide the ETL team for development of the ETL jobs through Informatica ETL tool.
• Working on SSRS Report Migration from SQL to Teradata
• Worked on Multi-dimensional Objects (Cubes, Dimensions, Majors) using SQL Server Analysis Services (SSAS).
• Worked on SQL Server Reporting Services wif Report authoring, Report management, Report delivery and security.
• Expert on Microsoft PowerBIandTableaureports, dashboards and publishing to the end users for executive level Business Decision.
• Delivered task using Agile Scrum methodology and worked on backlog grooming, release and sprint planning, daily standups, impediment removal.
• Designed and developed database objects like Batch Scripts, Stored Procedures, Triggers, Views, Cursors, Indexes and User Defined Functions consumed at various stages of Migration/Cleansing process, Reports or Data Validation.
• Designed and developed number of SSRS reports such as Drill down, Drill through, Parameterized, cascaded parameterized, Linked, Chart, and Sub-reports based on requirements to create reports.
• Worked in development of numerous fact and dimension tables on top of huge data and assisted creating OLAP model cubes, KPI’s Score Cards and Dashboards.

Confidential, Las Vegas, NV

Business Intelligence Developer

Responsibilities:

• Among a team of developers that successfully completed a complex data conversion project that was designed to migrate records to Enterprise Data Warehouse.
• Working on Pinnacle EDW Integration project for manipulating and transforming the data for Marketing and Promotions Sector.
• Working on complex projects which involved Migrating the data from one source to another for BOYD and Pinnacle domains.
• Building Stored Procedures and ETL automation Process for loading the data from staging tables into the target databases which handles data rejection, substitution, correction and notification wifout modifying data.
• Created SSIS packages to extract data from different source systems like MGT, ATI, ACSC, HALO etc. Using different transformations to clean and load data into data warehouse.
• Creating scripts to generate stored procedures to implement complex business logic and to verify agreed Historic data (incremental) is brought into the EDW.
• Assist in writing T-SQL script to build database objects like table, index, and view that compliments the intelligence reporting needs of stakeholders.
• Replicate the transformation logic specified in the mapping document using SQL and compare the result wif ETL result.
• Expert in leading technical migration, data integration and consolidation activities from traditional to cloud data structures like AWS and Azure
• Executed SQL conversion pre-validation and post-validation scripts to avoid data loss and to make sure that the Count, redemption amount for each source matches the data loaded in EDW.
• Good noledge & experience on Cloud Computing like Azure/AWS
• Responsible for fixing critical defects addressed during data conversion.
• Ensure data completeness, data quality by validating that all records, all fields and the full contents of each field are loaded.
• Utilize data engineering techniques to TEMPeffectively present data flow to users and help reconcile gaps in various systems.
• Coordinating wif business users in analyzing business requirements and translating them to technical specifications.
• Replicate the transformation logic specified in the mapping document using SQL and compare the result wif ETL result.
• Participated and aware of all sorts of agile ceremonies (user story grooming, sprint planning, sprint retrospective).

Confidential, Omaha, NE

SQL MSBI Developer

Responsibilities:

• Communicate and partner wif Team Leads, Business analysts and business leaders to deliver successful projects.
• Responsible for complete maintenance and delivery of scheduled releases during Month End Run.
• Identify, report and aid in the diagnosis and resolution to problems wif production job execution during Month End Run
• Owning and Assigning the tickets and Validations to my-self on $BISupport mailbox and see to resolution, including when outside support is needed from other teams.
• Coordinate wif Business users, IT personnel, and Business Analysts in planning and executing changes to the production schedule
• Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
• Prioritizing the tasks based on the nature of the requirement and Completing them wif thorough testing in Each environment before moving it to Production
• Co-ordinating wif business users in analyzing business requirements and translating them to technical specifications.
• Worked on converting the Confidential pages to the hybrid pages wif the changes in C# code for pulling in the CMS content.
• Skilled at maintaining reporting and data solutions.
• Created an SSIS package which will check for partitions which are disabled and Enables them before refreshing BI Data warehouse in all environments by using Package configuration wizard to allow packages run on different environments.
• Worked on different SSIS packages wif various types of transformation’s like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.
• Maintained data warehouse including replication, staging, ETL, stored procedures, change data capture, triggers.
• Created and maintained Active Batch Jobs using Active Batch job scheduler
• Exposure to PowerShell scripts and worked on some of the tasks where me need to change the way they are functioning.
• Designed T-SQL to interface wif the Database and other applications in most efficient manner by Developing complexSQLqueries using Temporary tables, CTE's and Sub queries
• Maintained and developed Multi-Dimensional Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Involved in Fine Tuning, Performance and Query optimization of the Database as required by the application.
• Experience in Maintaining and Developing SSAS Tabular models, creating Dimension Tables and Fact Tables
• Experience in Reporting Services, Power BI, Crystal Reports, SSRS using MS SQL Server and in Supporting services MDX technologies of the analysis Services
• Modified Power BI Reports for various analytical dashboards that depicts critical KPI’s wif slicers and dicers enabling end users to make filters
• Experience in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, using MS Analysis Services.

Confidential, St. Louis, MO

SQL-MSBI Developer

Responsibilities:

• Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
• Creating tables, indexes and designing constraints.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and TEMPeffectively identified and created Facts and Dimensions tables.
• Designed and developedBIgraphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• UtilizedPowerBI(PowerView) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in ExcelPowerPivot and sheared them usingPowerBIto the decision makers for strategic planning.ss
• Transferred data from Teradata to SQL Server using SSIS Packages and created an SSIS package which runs majority of Store Procedures at once parallelly.
• Gatheird functional and non-functional client requirements to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, PowerBIand Excel to provide better data visualization.
• 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.
• Worked on C#, ADO.NET, ASP.NET, Web Services, Visual Basic, Script, XML, HTML, Database programming
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Oracle, Flat file, CSV) by using multiple transformations provided by SSIS.
• Demonstrated CompleteMicroStrategySuite (Reports, Dashboards and Report Builder) for end users.
• StrongTeradataSQL skills and experience in creating and executing stored procedures.
• Experience in working wif different Databases such asTeradata, Oracle, SQL Server, MS Access and writing efficient and complex SQLs on huge volumes of data.

Confidential, Irvine, California

SQL Power BI Developer

Responsibilities:

• Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
• Creating tables, indexes and designing constraints.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Skilled at developing reporting and data solutions.
• Expertise in working wif Data Warehousing and business intelligence tools for developing various reports using Qlik View BI.
• Experience in full life cycle project development, including design, coding, testing and implementation wif ongoing product support.
• Strong analytical database design and Data Modeling (Star Schema, Snowflake Schema) skills in Qlik View.
• Successfully Migrated 5 QlikView reports to Power Bi Model, Retrofitted QlikView Reports into Power Bi
• Part of Relational Data Warehouse Designs and TEMPeffectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination wif SSASto develop
• OLAP cubes having Star/Snowflake schemas.
• Worked on Power Bi and created reports and dashboards and published them on service.
• Experienced and Created logs for ETL load at package level and task level to log number of records processed by
• Experience in creating and managing SSAS Tabular models, creating Dimension Tables and Fact Tables
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, PowerBIand Excel to provide better data visualization.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer wif (Pivot table, Get Pivot Data, Dashboards),PowerView,PowerMap and Heat Map.
• Designed and developedPowerBIgraphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• UtilizedPowerBI(PowerView) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in ExcelPowerPivot and sheared them usingPowerBIto the decision makers for strategic planning.
• UtilizedPowerQuery inPowerBIto Pivot and Un-pivot the data model for data cleansing and data massaging

Confidential, Santa Ana, California

SQL Power BI Developer

Responsibilities:

• Created Store Procedures, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
• Creating tables, indexes and designing constraints.
• Created Backend validations using Insert/ Update and Delete triggers.
• Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
• Part of Relational Data Warehouse Designs and TEMPeffectively identified and created Facts and Dimensions tables.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Designed and developedPowerBIgraphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• UtilizedPowerBI(PowerView) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in ExcelPowerPivot and sheared them usingPowerBIto the decision makers for strategic planning.
• UtilizedPowerQuery inPowerBIto Pivot and Un-pivot the data model for data cleansing and data massaging
• Developed and deployed SSIS packages in Production Server.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked wif Multi-threading Concepts wif Synchronous and Asynchronous transactions.
• Created logging, custom logging and error handling packages.
• Created SQL SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Knowledge in the Data Analysis, Design, Development, Implementation and Testing of reports generated in Web Focus.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), TableauandPOWERBI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, PowerBIand Excel to provide better data visualization.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), TableauandPOWERBI.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer wif (Pivot table, Get Pivot Data, Dashboards),PowerView,PowerMap and Heat Map.
• Expert on Microsoft PowerBIandTableaureports, dashboards and publishing to the end users for executive level Business Decision.
• Expert on maintaining and managing TableauandPOWERBIdriven reports and dashboards.
• Experienced in managing users, groups, sites, permissions and roles on Tableauserver

Environment: SQL Server 2014/2012/2008/2005, SSRS 2012/2008, SSIS 2012, SSAS, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2012, XML, XSLT, MS Office and Visual source safe, Business Objects XI 3.1/3.0, XI R1/R2.

Confidential, Rhode Island

SQL Power BI Developer

Responsibilities:

• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Server
• Created SSIS package to load multilevel XML data into SQL SERVER database.
• 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.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Experience in design of ETL packages for integrating data from heterogeneous sources like (Excel, Oracle, Flat file, CSV) by using multiple transformations provided by SSIS.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), TableauandPOWERBI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, PowerBIand Excel to provide better data visualization.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), TableauandPOWERBI.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer wif (Pivot table, Get Pivot Data, Dashboards),PowerView,PowerMap and Heat Map.
• Expert on Microsoft PowerBIandTableaureports, dashboards and publishing to the end users for executive level Business Decision.
• Expert on maintaining and managingPOWERBIdriven reports and dashboards.
• Experienced in managing users, groups, sites, permissions and roles on Tableauserver
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Designed and developedPowerBIgraphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• UtilizedPowerBI(PowerView) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along wif slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in ExcelPowerPivot and sheared them usingPowerBIto the decision makers for strategic planning.
• UtilizedPowerQuery inPowerBIto Pivot and Un-pivot the data model for data cleansing and data massaging
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.

Environment: MS SQL Server 2016/2014, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, XML, ETL, Microsoft Visio 2003, MS Visual Studio 2012, Composite Studio 6.1,Oracle 11g.

Confidential, Texas, Irving

SQL Power BI Developer

Responsibilities:

• Involved in writing scripts for client requirements for reporting purposes.
• Responsible for writing T-SQL code for creating cursor and handling the data validations.
• Developed complex T-SQL code for the application.
• UsedDAXfunctions to generate spreadsheets and pivot tables.
• Developed queries and troubleshooting techniques to help wif AX production support ticket resolution. Developed dashboard metrics for ongoing ERP work. Responsible for the content of many of theDAXreleases
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Monitored Scheduled jobs and alerts. Create new SSIS Packages to export flat files.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Gatheird functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Created various types of charts like Heat Maps, Geo coding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, PowerBIand Excel to provide better data visualization.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer wif (Pivot table, Get Pivot Data, Dashboards),PowerView,PowerMap and Heat Map.
• Expert on Tableaureports, dashboards and publishing to the end users for executive level Business Decision.
• Expert on maintaining and managing Tableau driven reports and dashboards.
• Experienced in managing users, groups, sites, permissions and roles on Tableauserver

Environment: MS SQL Server 2008R2, MS Analysis Services 2008, Oracle 11g, MS Access, Import & Export Data, Windows 7/8.

Confidential, OH, Cincinnati

SQL Server BI Developer

Responsibilities:

• Maintained databases, performed software installations and monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Studied detail changes that need to be made to each business process that is performed by all the systems impacted.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Created and scheduled jobs for various tasks and was responsible for maintaining jobs through SQL Server Agent.
• Designed SSIS packages for loading data from ODS to Data mart.
• Performing the ETL operations to support the incremental, historical data loads and transformations
• Experience in the design, development and maintenance of different cubes using SSAS.
• Involved in the post deployment maintenance of canned reports and cubes.
• Experience in designing the reports in ProClarity for SSAS cubes.
• Managed Logins, Users, Roles and User permissions.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS)
• 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, (SSRS) 2008
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2008, MS SQL Server Reporting service 2008, MS SSIS, T-SQL, Windows