SUMMARY

• Over 15+ years of experience in developing BI applications utilizing SQL server, BI stack, Power BI.
• Expert in Business intelligence using Confidential technology (SSIS, SSAS, SSRS) and MS Excel, PowerPivot
• Proficiency in Data Modeling and Dimensional Analysis.
• Skilled in Power BI for creating Dashboards and sharing them to business users.
• Hands on experience with Power BI (Power Pivot, Power View, Power Query, Power Map).
• Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.
• Creating powerful calculations, key metrics and key performance indicators (KPIs).
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008/2012/2014.
• Very good experience in Service Operations, Service Engineer, Incident, Change and Service Request Management - ITIL Framework
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perfmon and performance tools like Foglight.
• Worked with PowerShell scripting, .Net, C#, DB2, Power BI Reports, Operations Management Suite, PowerApps, Teradata.
• Working experience in a Scrum team, Agile planning under TFS environment.
• Hands on experience on Azure and Azure Data Factory(ADF)
• Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end-users to better understand, analyze, communicate, and validate requirements.
• Solid communication skills interpersonal, written and oral, ability to multitask and to deliver quality project within deadline.
• Excellent communication, interpersonal, problem solving, and analytical skills.
• Ability to work in groups as well as individually with minimum supervision.
• Ability to adapt to fast changing skills and work.
• Willing to learn new technologies as and when needed

TECHNICAL SKILLS

Technology: Confidential SQL Server 2014/2012/ 2008 R2/ 2008/ 2005, SSRS, SSAS, SSIS, T-SQL, Power BI, Power Map, Power Pivot, Power View, MS Office, .Net, IIS, PowerShell, Operations Management Suite, Foglight, DB2, SharePoint, Teradata, SAS

Tools: Remedy, ITSM, ServiceNow, JIRA, TFS

Methodologies: Waterfall, Agile - SCRUM

PROFESSIONAL EXPERIENCE

Confidential, Charlotte-NC

Sr. SQL ETL/ Power BI Developer

Responsibilities:

• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and shared 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.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Wrote complex T-SQL queries, stored procedures, user-defined functions and views to perform calculations of checks sent/returned.
• Transferred data from various OLTP data sources such as MS Access, MS Excel, Flat Files, CSV files into SQL Server.
• Writing multiple parameterized stored procedures, which were used by the reports to get the data.
• Extensively used SSIS transformations by creating control flow tasks, data flow tasks, Lookup, Fuzzy Lookup, Derived Column transformations, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used PowerShell scripting for automation
• Created automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Teradata SQL Assistant to transfer credit card/ debit card transaction data between databases.
• Using SSRS, created reports, sub-reports, drill-down, drill-through and parameterized reports to provide visible data such as refund status of checks, call escalation history and mailing history reports.
• Designed and developed an SSIS package to load the data in the SSAS cube. Created an automated job and scheduled it on the SQL server job agent.
• Performed SQL data migration, backups and restoration, gathered disk usage statistics, clean-up of obsolete backup tables and indexes.
• Performed research tasks to reconcile historical and current data by communicating with senior business analysts, developers and production teams. Created Pivot tables, graphs and organized data to help the management analyze the number of checks received and sent.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications. Suggested effective solutions to maintain historical and current data.
• Worked on SAS code to connect Teradata and work on data.

Confidential, Louisville-KY

Sr. SQL ETL/ Power BI Developer

Responsibilities:

• Validating for 65 years of Data, 40 billion Records and 115GB Size.
• Validation includes all the Source systems such as CELTIS, StarLims, Star labs, History (Before 1990) and OBOA.
• Data validation covers 12 Subject areas in Cube (Data Mart) and all the staging tables in the P&T application.
• Data Validation exercise covers correction of approximate 25% of erroneous data from old application.
• Implemented cleanup script for data deleted in source, which doesn’t have any track in source systems.
• To avoid manual intervention, automating the validation query and email notifications.
• 7 Reports generated in Excel, getting the data from Cube through MDX query.
• 1 Report using relational database to retrieve data and generated in Excel.
• 15 Repots developed using SSRS and data retrieval from the relational database; it can be generated in multiple file formats.
• DevelopedData Mapping, Data Governance, TransformationandCleansingrules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Involved in designing, developing, testing and deploying of new SSIS packages.
• Designed SSAS cube objects such as KPIs, aggregations, perspectives, and translations.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Optimized report performance with caches and snapshots.
• Involved in updating existing SSIS packages as per the business requirements.
• Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.
• Developed high level daily summary reports and monthly business summary reports and setup different email subscriptions for different business units as needed
• Worked to migrate applications from On-Premises to Azure
• Used PowerShell scripting for Windows based migration
• Interfaced with business analyst to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
• Created Confidential Power BI reports as per business requirements.
• Created Tabular Models judging by the data volume and corresponded with Confidential BI tools.
• Processed and maintained the cubes on a schedule directly in SQL Agent through SSIS Analysis Services Process Task.
• Created hierarchies and attributes as part of dimensional modeling.
• Participated in the Agile methodology’s daily scrum and other sprint meetings; developed and prioritized product backlogs and the sprint burnt down charts etc. to meet the daily deliverables and timelines.

Confidential, Redmond-WA

Sr. SQL ETL/ Power BI Developer

Responsibilities:

• Used ODS to create graphical representation in the form of Entity Relationships
• Gathered project information through project manager and business analysis, and make sure the solution implemented satisfied the requirements.
• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data in Power BI.
• Worked on Azure Data factory(ADF)
• Participated in the Agile planning for Team Foundation Server to make sure that our team sprints satisfied backlogs.
• Scheduled SQL Server Agent Jobs to monitor data transformation and database updates.
• Performed Extract, Transformation and Load process to transfer data from HP Serves Manager to data ware house using SSIS2008R2.
• Used PowerShell scripting for automation projects
• Created complex reports such as Matrix, Charts, Cascading Parameters, Sub reports and Dashboards using Power BI
• Generated and monitored Retail Power BI reports which are used to track Retail business overall retail store in US like Store Maps, Market reports, L1/L2/L3/L4 ticket tracking reports.
• Worked as Service Engineering role

Confidential

MS SQL/MSBI Developer

Responsibilities:

• Performed ETL process to load data from various source into upgraded database using SSIS 2008.
• Used Conditional Split, Data Conversion, Derived Column, Merge Join, Sort and Union All in different SSIS packages based on requirements.
• Performed SQL tuning and improve the speed of query running.
• Created clustered, non-clustered indexes to optimize query performance using Confidential SQL Server 2008.
• Created Tables, Matrix and Charts reports as required and deployed those reports onto Report Server.
• Managed report security and authorization on Report Manager.

Confidential

MS SQL/MSBI Developer

Responsibilities:

• Translated requirements into physical database structures that integrate with existing or proposed database structures.
• Tuned SQL queries improved the performance of the Database using Database Engine Tuning Advisor.
• Involved in Scrum meetings and accomplished to complete task in a sprint in timely manner.
• Constantly checked with team's engineering practices see if an appropriate balance between automated end to end system tests and automated unit testes been established.
• Discussed requirements with cross functional departments and generated reports for different department managers as required.
• Responsible for making sure reports are scheduled and delivered in a timely manner.