SUMMARY

• Senior Business Intelligence Architect and Development Lead implementing and managing large scale projects with 10+ years of experience.
• Experience with designed, development and administration of database applications.
• Implemented projects throughout the life cycle of SDLC that requires BI skills in requirements/process analysis, conceptual and detailed design, relational conceptual, logical and physical modeling and dimensional modeling star/snowflake schema, implementation of cube data warehouse, testing, training, and support. ETL Design, Scheduling, Deployment and Operational stability.
• Experience with large scale data processing, data structure optimization and scalability of algorithms with expert knowledge in SQL and optimization of complex queries
• Experience with the business processes, logical data models and relational database implementations
• Experience Microsoft BI Stack in development and implementation of complex ETL and Reporting applications including development SSAS Tabular and Multidimensional models.
• Administered and delivered responsibilities in various capacities like ETL Architect, database administrator, application development and support with duties including design and development of data warehouse applications, data modelling, reports development and data analysis with statistical inference, programming, scripting and automation
• Experienced in MS Power BI Desktop development and administration.
• Proficient with bid data concepts like PIG, HIVE and Hadoop
• Proficient and working knowledge in Machine Learning with Python and R.
• My personal interests are Artificial Intelligence, IOT and Medical Informatics

TECHNICAL SKILLS

ETL: Big Data/Hadoop, SSIS, Ab Initio, Informatica, Talend Open Studio

SOA: TIBCO Business Works, EMS, Hawk

Analytics: SSRS, Crystal Reports, SAS, SSAS, TIBCO Spot fire, Tableau

Databases: SQL Server, Teradata, Oracle, SAP, MS Access

Statistical: R - programming, Python Programming, SAS

Data Modeling: Visio, ERwin

Scripting: C, C#, VB, SQL, T-SQL, K-shell scripting, PowerShell, Python 3.0

Scheduling: Control M, SQL Server Agent, Windows Task Scheduler

Op Systems: Windows, Linux

PROFESSIONAL EXPERIENCE

BI Architect/SQL Server DBA

Confidential, Atlanta, GA

Responsibilities:

• Created SQL database data tools for DBA monitoring and reporting using PowerShell
• Created ETL framework to monitor and maintain all Servers by their Usage, Security, storage, and retention, Backups, SQL Logins and other Inventory per compliance.
• Used Power BI visualizations to analyze operational data for system admins and DBAs
• Administrated and provisioned Power BI
• Developed Power BI reports on Operational data for System and Database Administrators.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plot pie, bar and density charts.
• 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.
• Configure Power BI On-premises gateway and set up data sources and role based security model.
• Implemented CMS server and IDERA SQL monitoring for database maintenance and monitored solutions
• Developed operational framework to measure the capacity and data growth, SLA on inbound and outbound, automation of jobs and integration using scripting like PowerShell and Python
• Developed automation scripts to backup databases and tables for migration/mitigation strategies
• Developed Metadata scripts to standardize Stored Procedures and other database objects to be used in ETL and reporting models
• Responsible for setting up new servers for dev/test/pre-stage environments with automation of backup and recovery strategies
• Migrated the Legacy customers from Oracle to the SQL Server platform
• Assisted in implementation of always on availability groups
• Implemented ETL solution to integrate Oracle and SQL Server through Replication.
• Implemented ETL solutions from big data using Pig and Hive
• Developed R scripts for logistic regression on database performance for optimization of multiple applications
• Enhanced, supported and maintained big data/Hadoop applications for network and subscriber usage
• Developed and administrated Data Zen reports for operational BI reports
• Implemented and suggested various performance optimization techniques using query plans, performance monitor, event logs, spot light and extensive use of DMVs
• Interacted and worked closely with other administrators to contribute to high availability solutions, client/server connectivity, user/groups, usage and traffic, SQL clustering and log shipping, disaster recovery solutions, replication, mirroring and hosting
• Troubleshot production issues and conducted the root cause analysis, delegated and resolved the issues in a timely manner

Environment: SQL Server 2012, SSAS, SSIS, SSRS, Tableau BI and Analytics, C#, Visual Basic 2010, .NET, Python and PowerShell scripting, Data Zen-Mobile BI, Power BI and Data Analytics

BI Architect/Lead Developer

Confidential, Alpharetta, GA

Responsibilities:

• Documented best practices for conversion and re-factoring the existing ETL solutions to the framework BI model
• Implemented master package ETL solutions and enabled metadata driven job execution
• Worked closely with the team lead (BI architect) on implementing type II Dimensions on Tree hierarchy for reporting on market hierarchy and its relevant analytical reports for OLAP
• Developed solutions for continuous integrations like automate deployments, bundled packages into builds, backup, restore and rollback
• Developed templates to automate the development of packages Confidential the project level, set environmental variables, set SQL Server agent job and scheduled time using C#, and SSIS DB catalog
• Developed schema to support framework BI models
• Implemented big data solutions to feed the SQL Server with network and subscriber usage metrics using Hadoop, Map Reduce, Pig and Hive
• Developed ad hoc reports on SSAS cubes including MDX reports for marketing, business and analytics team
• Converted analytical reports to datazen mobile BI reports
• Developed PowerShell scripts to schedule and refresh BI reports

Environment: SQL Server 2012, SSAS, SSIS, SSRS, Tableau BI and Analytics, C#, Visual Basic 2010, PowerShell scripting, Datazen-Mobile BI and Data Analytics, Hadoop, Map Reduce, Pig and Hive

DW/BI Developer

Confidential, Atlanta, GA

Responsibilities:

• Participated in design sessions for data integration of multiple data models into unified enterprise architecture in providing a single point of reliable sources
• Developed longitudinal data model for student history and student assessments
• Implemented Metadata driven ETL designs to accommodate changes in business metrics
• Optimization of reports, Stored Procedures and SSIS packages
• Extensively analyzed the Metadata and loaded the data using Dynamic SQL, Stored Procedures and cursors
• Implemented orchestration layers to feed snapshot transaction data into data warehouse using XM, Visual C# and Dynamic SQL
• Developed file based ETL solutions to dynamically handle state files and district files irrespective of its file layout including XML data
• Implemented data parallelism and pipeline parallelism in SQL Server
• Built the reports from the data warehouse and transactional data sources using SSRS
• Conducted the analysis of the data using SSAS cubes and developed SQL analytical reports
• Migrated from the SQL Server 2008 to SQL Server 2012
• Assisted in database tuning, Table Partitioning, performance monitoring and parameter sniffing

Environment: SQL Server 2008/R2, SSAS, SSIS, SSRS, Talend Open Studio, C#, Visual Basic 2008, Oracle 9i