SUMMARY

• Over 8+ years of experience in Design and Development of Database and Business Intelligence with SQL Server 2005/2008/2008 R2/2012/2014,2016, MSBI and Power BI.
• Over 5 years of Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Experience in designing dashboards with various data visualizations tools like Microsoft Power BI.
• Extensively worked on Data Extraction, transforming the data by using SSIS.
• Hands on experience in scheduling and deploying reports on report manger.
• Experience in designing, developing, and deploying Business Intelligence solutions using Power BI.
• Expert in creating ad - hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports.
• Expert in creating multiple type of reports using tools like Power BI and SSRS.
• Experience in reports scheduling and subscription processing using SQL server Reporting services manager.
• Experience in query optimization & performance tuning, used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
• Experience creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, managing indexes and locks, troubleshooting deadlocks.
• Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Proficient in Creating SQL Server Integration Services Package configuration files, implementing logging in packages and error handling.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating SSIS Packages.
• Designed & developed the various SSIS packages for the daily, Hourly, Weekly & Monthly Loads.
• Strong knowledge of Setting up Backup/Restore and disaster recovery procedures to ensure minimal downtime and data loss.
• Expertise in design and development of Reports, generating on-demand and scheduled reports for business analysis.
• Proficient in creating Matrix, Tabular, Drilldown, Drill through and Graphic reports using SQL Server Report Services (SSRS).
• Expert in creating Parameterized Reports (SSRS). Created ETL Scripts to move and load data.
• Developing reports on SSRS on SQL Server. Sound Experience and understanding of SSAS, OLAP cube.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Experience in Power BI Designer with Power Pivot for Excel, Power View for data visualization and used DAX for use in calculated columns for reports and analysis purpose.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.

TECHNICAL SKILLS

Databases: MS SQL Server 2016/ 2014/2012/2008 R2/2008, Oracle 8i/9i/10g, MS-Access 2013/2014

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008, Data Stage, DTS, SQL Server Reporting Services (SSRS), Crystal Reports 8/10, SQL Server Analysis Services (SSAS)

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front

Programming languages: C, C#, VB.NET, Visual Basic for Applications (VBA) and ASP.NET, SQL, PL/SQL, T-SQL.

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, Power BI, SQL Loader, DB visualize, Erwin, Excel, Microsoft Visio 2000/2003.

Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Tableau, Excel.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Power BI Developer

Responsibilities:

• Collected and analyzed data on established and prospective customers, competitors and marketing channels and sources.
• Prepared report that interprets consumer behavior, market opportunities and conditions, marketing results, trends, and investment levels.
• Investigated data discrepancies, resolved, and articulated them to support the team’s ability to do effective data analysis.
• Found anomalies in our data to inform the team about product loopholes by disseminating large amount of information with great attention to detail.
• Used SQL and Power BI toolsets for data intelligence and analysis to support marketing and sales team in finding leads.
• Very good understanding of Data Modeling Techniques for Analytical Data (i.e., Facts, Dimensions, Measures).
• Excellent skills in writing DAX queries.
• Hands-on professional with thorough knowledge of scripting, data source integration and advanced visual development in Power BI.
• Experience in creating Power BI reports that represent different findings and insights from the data using interactive charts and maps. And how they are leveraged within an organization.
• Strong experience of databases like SQL Server, SQL Azure, etc.
• A deep understanding and ability to use and explain all aspects of, relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards.
• Connect to multiple datasets to bring all the relevant data together in one place and create reports that provide a consolidated view of the different sources. And creation of advanced visualization like heat maps and many other.
• Using Microsoft Power BI publisher for Excel, to take snapshots from insights in Excel, like PivotTables, Charts, and ranges and pin them to dashboards in Power BI.
• Good understanding of the processes of data quality, data cleansing and data transformation. Upload of Power BI reports to Power BI online service, implement security and audit.
• Scheduling of Power BI Datasets in online version and knowledge of viewing dashboards in Power BI mobile version.
• Candidate should possess very good communication with strong business analyst skills and able to interact with the customer directly.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.
• Setting up Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized power query in Power BI to Pivot & Un-Pivot the data model for data cleansing and data massaging.
• Creating and managing schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements.
• Created, maintained & scheduled various reports in Power BI like Tabular Reports.
• Explore data in a variety of ways and across multiple visualizations using Power BI.

Environment: A Power BI environment is established through the Office 365 admin center and lives within Office 365 containers. The environment consists of Office 365, Azure Active Directory, and Power BI.

Confidential, Bay Area, CA

MSBI/Power BI Developer

Responsibilities:

• Designed and developed Tabular Model Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Worked on writingDAXqueries and manipulating the multidimensional data inTabular Model cubes.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Developed calculated columns and measures using DAX in Power BI.
• Used the tabular model cubes as the source in Power BI to visualize the data.
• Created Power BI dashboard and generated reports.
• Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
• Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
• Published Power BI Desktop to the cloud.
• Created interactive reports customized for the business using Power BI Desktop.
• Installed and configured and maintained Power BI Report Server.
• Experience in combining data from different sources by using of Power Query
• Created some SSIS packages to import and export data from various data sources using SSDT.
• Created database objects liketables, users, roles, stored procedures, triggers.
• Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
• Created a few new reports for internal usage using SSRS.
• Responsible for deploying the reports, cubes, and packages on all environments.
• Scheduled the jobs for SSIS packages under SQL Server Agent.
• Deployed SSIS packages using Integrations Service Catalog and through XML configurations.

Environment: MS SQL Server 2016, MS SQL Server Analysis Services (SSAS), EDW, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, M Query.

Confidential, Irving, TX

MSBI Developer

Responsibilities:

• Worked on the analysis of the Design Specification documents for the Packages and coordinated with team members at the time of changes in Business requirements and changes in Data Mart Schema.
• Migrated the data from one server to another server (SQL Server 2008 to SQL Server 2012) using SSIS Packages
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages daily.
• Implemented the changes in the existing ETL process to move data back and forth from ODS to all the integrated systems.
• Developed SSIS Packages to extract data from Excel spreadsheets, Microsoft Access database and flat files, load them onto SQL server for Data Analysis and Reporting by using multiple data flow transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Created Clustered and Non-Clustered Indexes for Query Optimization and involved in Database Tuning.
• Created triggers that capture the customer updates and made the required transformations to move the customer preferences from ODS databases to DW.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Performed daily tasks including backup and restore from disaster recovery in SQL Server R2 using SQL Server Management Studio.
• Designed, developed the customer comparison reports in MS SQL Server environment using SSRS.
• Performed the Unit testing for packages developed to ensure that it meets the requirements.
• Used the SQL Profiler, query execution plans to trace the performance of TSQL Statements, procedures, and functions.

Environment: MS SQL Server 2014/2012/2008 , SQL Server Reporting Service (SSRS) 2014/2012/2008 , SQL Server Integration Service (SSIS) 2014/2012/2008 , T-SQL, ETL, PL/SQL, Excel.

Confidential

MS SQL Server/Data Warehouse/ ETL Developer

Responsibilities:

• Wrote MDX queries to access data from OLAP cubes in SSAS. Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Developed logical and physical data models, designed data access strategies, and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created different type of reports including Crosstab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• Gathered user requirements, drafted specifications, designed, documented, and wrote test script for testing of all the report.
• Designed, developed, and implemented changes to JCL andCOBOLprogram flow for more accurate reporting of float statistics during weekend and holiday processing.
• Designed, developed, and implemented changes to JCL andCOBOLprogram flow for more accurate reporting of float statistics during weekend and holiday processing.
• As mainframe developer making system improvements withCOBOL, SQL, DB2, and JCL using flat files and VSAM file structures. Developed logic to handle dates routines, logic with tables to compare certain fields, and logic to make complex calculations inCOBOL.
• Extensive use ofDAX expressionsin tabular models as per business requirements.
• Experienced in using Data Analysis Expressions DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Involved in Writing SQL Queries, Views, and Stored Procedures on SQL Server.
• System design and development,COBOLprogramming (DGCOBOL and ICOBOL, on ICHOST/MS-DOS, Data General RDOS and MDOS, and SCO-UNIX operating systems).
• Designed databases for applications with requirements for large numbers of transactions, heavy access, and high availability.
• Optimized T- SQL code.
• Worked with Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin

Environment: T-SQL, MS SQL Server 2012/2008, MS SQL Server Analysis Services 2012/2008, MS SQL Server Integration Services 2012/2008, MS SQL Server Reporting Services 2012/2008, DAX, PowerPivot.

Confidential

SQL Server Developer

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Development of T-SQL Stored Procedures for moving and maintaining synchronization of data between legacy system and newly developed application.
• Expertise in using variables, property expressions, and script tasks in SSIS Integrated Database Maintenance jobs to perform full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Documented and maintained history of changes for future reference.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL.
• Assigned Index tuning scripts to run at regular intervals.
• Performance monitoring and tuning MS SQL Server.
• Assisted the Application team in data modeling and T-SQL coding.

Environment: SQL Server 2008/2005, SSRS, SSIS, T-SQL, Script, JavaScript, Microsoft Office, Windows 2003/XP.