SUMMARY

• Results driven software professional with 18+ years of progressively responsible experience in managing data warehouse and ETL related platforms and applications which includes hands on experience in Data Warehousing, Big Data, ETL & Data migration.
• Performed Data Analysis, Reports Design, Business Intelligence, Data Modeling and Data Analytics for multiple projects. Expert in Power BI, Power BI Pro, Power BI Mobile.
• Proven Experience in handling structured and unstructured data using Datameer / Hive.
• Experienced in defining job flows, importing and exporting Data into HDFS using Datameer, Hive and Apache Sqoop.
• Analyzed and developed Transformation logic for handling large sets of structured, semi structured and unstructured data using Hive and Datameer.
• Proven experience in building applications in Datameer using Hadoop/HDFS as data Store.
• Experienced with 3rd party products like Tableau, Cognos, SAS, R, Anaconda, DataStage, Datameer, etc.)
• Demonstrated ability to understand the security architecture for all AWS services.
• Azure experience in integrating on premises servers to Azure. Configured VNETs and subnets as per the project requirement.
• Developed Power BI reports, dashboards into rich look, implemented complex hierarchical row level security, published reports to power bi service and established gate way refresh schedules.
• Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.
• Experience in Ad - hoc reports, data driven subscription reports by using Report Builder.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Proven Hadoop big data experience including Sqoop import/export, HBase, Hive, PIG, Spark, MapReduce and Datameer for data analytics.
• Data Architecture (Conceptual, Logical, Physical) experience involves building 3rd Normal form & Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, and KPI} using Erwin, ER/STUDIO, Power Designer.
• Hands-on experience in implementing Big Data analytics using Hadoop, Hadoop eco system, Pig, Hive, Hue, MongoDB, NoSQL, FLUME, Spark, R Programming, python, Pentaho, Splunk, MongoDB, Cassandra, Amazon Cloud Solutions, Cloudera, Hortonworks Environments, Datameer, OBIEE11g, OBIA 7.9.6, Tableau, EPM, and other Data Integration & Visualization tools.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Exceptional communication and presentation skills and established track record of client interactions.
• Extensively worked with data warehousing tools such as Oracle Warehouse Builder, MS SQL Server DTS Packages, AbInitio, ETL Informatica in Oracle 10g / SQL Server 2005 environment.
• Hands on experience in writing RDBMS, ANSI SQL, PL/SQL, and T-SQL programs in Oracle, SQL Performance tuning and stored procedures, SQL Server, MS Access and IBM Netezza, Sybase, DB2, Teradata. Extensively used DTS Packages, query management tools like Query Analyzer.
• Strong knowledge of relational and multi-dimensional database architectures, database lifecycle design and application development.
• Financial services & other industry domain expertise in the following areas:
• Credit Card, Debit Card, Trading, Anti-Money Laundering, Equity and Debt Events, Sales, Equities and Derivatives, Telecom, Auto, Insurance and Retail customer data.

TECHNICAL SKILLS

OPERATING SYSTEMS: UNIX, Linux, Windows 10/7/2010/2000/ XP, MVS

SCRIPTING LANGUAGES: Unix Shell Scripting, PERL, ANSI SQL, T-SQL, PL/SQL, Focus, VB Script, JScript, HTML, XML, XSL.

REPORTING TOOLS: Power BI Desktop, Mobile, Online PRO, Business Objects 6.5.1/XI R2 SP2, Crystal Reports 7.0/ 8.5/9.0/10/ XI R2 SP2, Cognos, Tableau

AZURE EXPERTISE: IaaS, PaaS, VM Migrations, VNet, Traffic Manager, Azure Cloud Services, SQL Azure, Active Directory, Data Factory, Data Lake, Service bus, blob storages.

ETL TOOLS: Data Stage, CDH (Cloudera Distribution including Apache Hadoop) 5.1.2, Hadoop 2.3.0, Hive-0.12.0, Hue3.6.0, Datameer 4.5.8, Sqoop, Informatica Power Center 8.x, 7.1.2/6.2/5.1/1.7 , SAP BO Data Integrator, Power Center, SSIS, Oracle Warehouse Builder, DTS, AbInitio

BUSINESS INTELLIGENCE TOOLS: Desktop Intelligence, Reporter, Designer, Supervisor, Web Intelligence, Broadcast Agent and Publisher, Big Data (under training)

DATA BASES: Oracle 8i/9i/10g, Sybase 12.0, Netezza, Teradata, File Maker Pro 5/7, MS Access, SQL Server 7.0/2000/2005 , SQL Server, DB2, EMC Greenplum DB 4.2.7.2 build, PostgreSQL 8.2.15

WEB, CLIENT-SERVER AND DESKTOP: ASP, JSP, MS Visual Interdev, VB6, .NET, XML, CSS, MS Office, MTS, COM, DCOM, and Web Logic Server Quality Standards SEI-CMM /CMMI, ISO 9000, PCMM

MODERN TECHNOLOGIES: SalesForce, Big Data, No SQL, Hadoop, Hive, Hbase, MapReduce

DATA MODELING AND OTHER TOOLS: ERWin (Data Model Mart), ER STUDIO 8.0/8.5/9/9.0.1/16.0.3 , Rational Rose, IBM Power Designer, Smart Draw, ERD, Test Director, Data Cube, ETL Informatica, TOAD (Tool for Oracle Application Developer), PVCS Version Manager, Visual Source Safe, IPMS, Clear Case.

TESTING LIFE CYCLE: Test cases, setting up test environment, test execution, verification of test results

PROJECTS MANAGEMENT: Technical Lead, Project Leader, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Rosemont, IL

Senior Power BI Lead / Architect/ Designer

Responsibilities:

• Participated in JAD sessions with Business Users and Business Analysts, ETL resources to gather the Requirements and build Power BI Reports and KPI Dashboards.
• Attended daily standup scrum meetings and provided daily updates to the management and Project Manager.
• Implemented and configured the security framework at the BI and Synapse Analytics Layer using AAD groups for Premium Capacity Power BI Client tenant.
• Used On-Prem and Azure Cloud as data sources.
• Lead and managed 3 BI Developers daily and weekly activities and reviewed work to ensure quality of the deliverables are met.
• Designed Sales and Marketing KPI Dashboards for online and mobile App use and trained Business Users.
• Applied RLS - Row Level Security to Power BI Reports to ensure the data is secured and relevant Customer data is shown for the Customer.
• Used Azure DevOps VSTS board to create new User Stories and track the status. Provided estimates.
• Interacted with Business Users for User Acceptance Testing and get approvals to migrate the changes to Prod environment.
• Prepared Design Documents for new reports and conducted reviews with BI development team.
• Assisted with design and implementation of suitable Power BI Repository objects and metadata.
• Worked on PROD issues and break-fix tickets, assisted in UAT. And performed Development and testing tasks.
• Defined User Security Model and defined Row Level Security for Secured Data sharing of BI Reports for Internal and External Organization Business Users and Customers.
• Created BI Training PowerPoint presentations and trained Power Users and Business Users in Power BI Reporting and
• Published BI Reports and managed Users access to Online Power BI Apps and Workspaces.
• Designed Power BI Dashboards from multiple Reports and for Mobile Apps.
• Created User Stories to track the progress of each report requirement and provided status updates in daily scrum calls.
• Worked with Business Users to prioritize the Report requirements.
• Created KPI Dashboards for Sales and Marketing and various business areas.
• Trained Sales and Marketing business users on Sales and Marketing Reports and Dashboards.
• Created SQL queries and used Live & Import Data Connections. Also, created Integrated Data Sources (Multiple Data Source) for a BI Report.
• Trained Business Users on Power BI Reports designing and basic DAX queries.
• Created user documents and Power BI Training documents for Business Users. Provided documentation to link SQL Server tables with MS Access to build custom queries and reports.
• Trained junior Power BI development staff to follow reporting standards and use Power BI Visual filters, page level filters etc, DAX queries.
• Provided support to 400+ BI Users community and managed support tickets and assigned to appropriate team members.
• Created documentation and participated in Change Review Board meetings for week;y enhancements to the Dashboards and Reports.
• Used Import & Connect Live Data Connectivity modes.
• Created various measures with rich Power BI visuals, live data Dashboards, Historical data Dashboards for Accounting, Sales & Marketing, Material Management, Customer Service, Audit reports etc. Business Users and Configured security, Organizational Content Packs, Workspaces, data Gateways, refresh schedules for Power BI service.
• Worked on all types of data transformations that are available in Power BI query editor.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular models for efficient in-memory data processing.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Designed and created data extracts, supporting POWER BI tools reporting applications.
• Managed users access to Power BI workspaces and Apps.
• Created tickets to provide Users access to Power BI Apps & Reports & Data.
• Worked on creating Power BI Dashboards and Reports Links in Share Point for more than 200+ Reports & Dashboards.
• Used Visual Studio as Version control tool to save Power BI Reports in pbix/pbit formats.
• Collaborated with Scrum Masters to understand the project deliverables and timelines.

Key Technologies: Power BI 2.83, SSAS Tabular, DAX, SQL Server 2017, SSMS, SSIS, SSRS, SSAS, Azure Cloud Services, SQL Server 2017, ADF Pipelines, Team Foundation Server, T-SQL, VSTS, Visual Studio, Windows 10, MS Word, MS Excel, Power Point, Visio, Share Point, SQL Profiler

Confidential, Chicago, IL

Senior Technical BI Lead

Responsibilities:

• Developed Power BI model used for financial reporting of P & L and Headcount.
• Designed and documented the entire Architecture of Power bi Poc
• Developed Power BI reports, dashboards, implemented complex hierarchical row level security, published reports to power bi service and established gate way refresh schedules.
• Implemented Calculations, Perspectives, hierarchy structures, score cards and Key Performance Indicators KPI with outstanding visualizations using DAX, T-SQL.
• Worked on Microsoft BI analytics stack (SSIS, SSAS) and worked on investigating new tools, tool capabilities.
• Developed SSAS tabular models utilizing complex DAX functions and SQL queries, stored procedures using T-SQL, CTE, XMLA, PowerShell scripts.
• Worked on complex data modelling and design patterns for BI/Analytics reporting requirements using star schema, tabular and multidimensional OLAP modelling.
• Wrote complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Worked on Data Factory Editor, to create linked services, tables, data sets, and pipelines by specifying JSON definitions for these artifacts
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Aid Database DBAs in reporting SQL scripts creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning for Reports.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating data blending in case of merging two different datasets using Tableau
• Created, managed, monitored VM using Windows Azure portal admin.
• Designed and developed standalone data migration applications to retrieve and populate data from Azure Table / BLOB storage to on premise SQL Server instances.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
• Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
• Used Azure BLOB to access required files and Azure Storage Queues to communicate between related processes.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
• Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.

Key Technologies: Power BI, Azure AD Connect, VMware, DevOps, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Pentaho, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, Visio, Share Point Jira, SQL Profiler, NoSQL, Toad, JIRA, SQL Server 2005/2008, SQL, Oracle10g, DB2, MS Excel, Mainframes MS Visio

Confidential, Hoffman Estates, IL

Senior BI Data Architect

Responsibilities:

• Worked on multiple projects with different business units.
• Gather the various reporting requirement from the business analysts.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Developed Greenplum stage DDLs to read gzip data files exported from HIVE/Datameer.
• Developed transformation workbooks using Datameer from various data sources.
• Developed Greenplum DW DDLs and DMLs to load data from stage to base and current tables.
• Integrated Datameer with tools and cloud-based platforms within the SYW ecosystem.
• Exported the transformed code from Datameer to Greenplum.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Reports using Charts, Gauges, Tables, matrix.
• Used Datameer for Data Visualization.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.
• Drove the strategy, development, and delivery of key initiatives for multiple business units in a+$1.4B online ecommerce business.
• Created and maintained the Data Model repository as per company standards.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models;
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic
• Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS.

Key Technologies: Datameer 4.5.8, Sqoop, EMC Greenplum, ER Studio 16, Oracle 10g, SQL Server 2005, PL/SQL, PeopleSoft V8, Toad, Informatica, Power Centre 6.0, Case Management System, Business Objects