SUMMARY

• Over 5 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI and Power BI.
• Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Experience in designing Star, Snowflake’s schemas and database modeling using Erwin tool.
• Experience inOLTP/OLAPenvironment andData Warehouse.
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Work experience on MS SQL Server 2012/2008R2, Oracle, crystal reports 6.
• Experience indesigning, developing, and deployingBusiness Intelligence solutions usingSSIS,SSRS, SSAS, Power BI.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi - dimensional expression (MDX), Perspectives and Roles.
• Expert in creating multiple type of reports using tools like Power BI and SSRS.
• Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
• Designed and developedmatrix and tabular reportswifdrill down, drill throughusingSSRS.
• Experience inwritingComplexSQLQueriesinvolving multiple tablesinnerandouter joins.
• Worked as MS SQL Server Developer on enterprise and performance critical applications.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.
• Involved in migration of legacy data by creating various SSIS packages.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Experience in Handling Heterogeneous data sources and databases Oracle, Teradata, and csv and XML files using SSIS.
• Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.
• Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.
• Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages.
• Excellent verbal and written communication skills wif a strong focus on customer facing interaction, customer service, and presentation.
• Experience in tuning the reports dat includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.
• Proficient wif automated testing tools - Win Runner, Load Runner and QTP for testing Client / Server and Web based applications.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Capable of handling multiple critical business applications as a primary point of contact which involves Development, Enhancements, and production support activities.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Teradata SQL Assistant

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SSRS (2012/2008), MS Access, MS Excel, Crystal Reports, Tableau Desktop, Dundas

Database: MS SQL Server 2012/2008, MS Access, Oracle 11g/10g/9i

Programming: T-SQL, PL/SQL, C, ASP.NET 4.5/4.0/3.5, C#.NET

Web Technologies: HTML, DHTML, XML, XSL, Java Script, CSS

Operating Systems: Windows 2003/2008 Server, Windows XP, Windows 7, Windows 8, Windows 10

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Toad

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

Power BI/BI Developer

Responsibilities:

• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Administering the MS SQL Server by creating user logins wif appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Utilized Power Query in Power BI to pivot and un-pivot the data model for data cleansing and data massaging.
• 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.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa
• Work wif project teams for upgrading SQL Server 2012.
• Created interactive reports customized for the business using Power BI Desktop.
• Installed and configured and maintained Power BI Report Server.
• Explored data in a variety of ways and across multiple visualizations using Power BI. Expertise in design of experiments, data collection, analysis, and visualization.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports. Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
• Created database objects liketables, users, roles, stored procedures, triggers.
• Developed custom reports and deployed them on server using Power BI.
• Designed and generated ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planning.
• Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS). Scheduled the jobs for SSIS packages under SQL Server Agent.
• Excellent command on subscriptions, report snapshot and report cache.
• Created trace in SQL Profiler for Performance tuning onstored proceduresand Scripts.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Worked on OLAP cubes using SSAS and Created and Managed OLAP Cubes using SSAS.

Environment: MS SQL Server 2016/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, Power BI Desktop, Power BI Service, Power BI pro, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.

Confidential, Chicago, IL

SQL server/BI Developer

Responsibilities:

• 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.
• Created SSIS packages to populate data from various data sources like oracle using PL/SQL queries.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
• Construct different hierarchical dimensions suitable for offer analyst to use.
• Enhance and build selected redirect reports wif the flexibility of an OLAP service.
• CreatedSSIS packagesto load data into staging table and data mart and Performed logging inSSIS packagesto capture error data and for error handling.
• Worked wiftable and matrix visuals, worked wif different level of filters likereport level, visual level filters, page level filters. Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
• Worked on tuning up and changing some of the existing SSRS reports as requested by the user.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked wif Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2012/2016.
• Created the partitions, aggregations, and Various custom member calculations in the cube and, developed drill through actions which would navigate to SSRS reports deployed to report manager.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• PerformingT-SQLtuning and optimizing queries for reports dat take longer execution time.
• Extract data from flat files which comprised of header and input files to SQL server 2012 and Created Testing scripts for staging validation, generated the Map Force file for mapping between flat file and database.
• Created MOLAP Cubes and automated the processing options on different servers. Optimizes the processing time by tuning the DSV queries and created SSIS packages eliminating complex syntax in Data Source View.
• Designed, Build the Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS).
• Developed, deployed, and monitored SSIS Packages including upgrading DTS to SSIS.
• Administered the SQL server by creating user logins, dropping, and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Created a few new reports for internal usage using SSRS 2012.
• Deployed SSIS packages using Integrations Service Catalog and through XML configurations.

Environment: SQL Server 2012, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, DAX, SQL* Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010, ALM, Anaplan, Tableau

Confidential

SQL/BI Developer

Responsibilities:

• Designed and developed Tabular Model Cubes and Dimensions using SQL Server Analysis Services (SSAS 2008).
• Installed and configured SQL Server 2008. Relocation of databases from one server to another using attach and detach databases.
• Developed SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse.
• Hands on experience in dealing wif Relational Database Management Systems, includingStored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly, and quarterly reports run periodically.
• CreatedSQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation. Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly, and quarterly reports run periodically.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Migration experience wif DTS. Created some SSIS packages to import and export data from various data sources using SSDT.
• Created DAX calculated columns in power pivot worksheets to extract, import and join data dat coming from different sources.
• Implemented Performance Tuning and Query Optimization.
• Expert in creatingComplex Crystal ReportsAd Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Proficient in design and development of various dashboards, reports utilizingTableau VisualizationslikeDual Axis,Bar Graphs,Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualizationand other making use ofactions,otherlocal and global filtersaccording to the end user requirement.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#, ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server