SUMMARY:

• Over 8 years of extensive experience in Business Intelligence, Data Warehouse and Data Analytics across multiple industries, and PMP certified.
• Experience in designing new database systems from scratch.
• Led numerous teams on improvement projects and system implementations.
• Strengths in stored procedures, OLTP, performance tuning and high volume batch - processing techniques. Development and maintenance experience of complex T-SQL code 800 stored procedures for implementing thousands of business rules and workflow processing. Proven record in large size millions of records per batch and Terabyte DB sizes online batch processing OLTP development and using best performance tuning techniques in a multi-server, multi-product, high latency, real time and batch environments.
• Database design and modeling experience in product development environment Logical, Conceptual and Physical using tools like MS Visio. Unique experience in re-architecting existing databases for performance and scalability.
• Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI from prototyping to deployment.
• Experience in planning and implementing organization’s BI strategy in a cost effective manner. Knowledge and experience in both agile and traditional System Development Life Cycle including Project Planning, Scoping, Requirement Gathering, Analysis, Design, Development, Testing, Deployment, Post Production Support, Documentation, and User Training.
• Led development of data models and reports for stakeholders and provide analytical support and recommendation as necessary.
• Strong technical, analytical skills combined with outstanding leadership ability, creative problem solving skills in both strategic, tactical areas.

TECHNICAL SKILLS:

ERP: SAP ECC 6.0, JDEdwards, Oracle

BI/Reporting Tools: SAP BI/BW 7.3/7.0, SSRS, SSAS, Power BI, PowerPivot, Cognos BI 10.2, Tableau

ETL Tools: SAP BODS 4.0, SSIS

Operating Systems: MS Windows 2000/XP/7

Databases: MS SQL Server 2008-2016, Microsoft Azure SQL Server, MS Access, HANA 9.0 SP3

Languages: VB, SQL, ABAP, C++, Javascript, HTML

Workflow tools: MS Excel, Project, Visio, Word, PowerPoint

Application tools: Sharepoint Designer, Sharepoint Online

Documentation: Technical, Design, Test Case documentation and Training Materials

PROFESSIONAL EXPERIENCE:

Confidential, TX

Data Engineer

Responsibilities:

• Designed and administered Control Reports and Routines (tests and balances) to identify missing data, outliers, and corrected in the ETL process.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions in SQL Server.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues. Worked on tickets through BMC Remedy Action Request System.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Led Migration of On-Prem SQL Data Warehouse to Azure SQL Data warehouse.
• Developed OLAP Cubes using MS SQL Server Analysis Services (SSAS), in Start Schema and Snow Flake Schema.
• Designed and developed ETL SSIS packages to facilitate incremental load process.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Integrated custom visuals based on business requirements using Power BI desktop.
• Migrated existing self-service reports and adhoc reports to Power BI.
• Embedded Power BI Reports on Sharepoint sites.

Position: SCM BI Analyst/Lead

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Performed advanced DBA activities which included recovering databases from backup in disasters and implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Led Migration of SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports in Cognos.
• Used Team Foundation Server (TFS) for source control and sprint planning.

Data Analyst

Responsibilities:

• Involved in Designing data models based on business requirements and provided documentation.
• Managed software tools for optimization in support of supply chain design decisions; included data manipulation and analysis using spreadsheet and database tools.
• Updated and maintained logical and physical model using Erwin Modeler.
• Created SSIS packages using best practices from scratch to perform ETL process and load the data into destination table.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Created and managed schema objects such as tables, views, indexes and stored procedures.
• Generated daily, weekly, monthly and quarterly reports and created Ad-hoc reports by using SSRS.

Confidential, Dallas, TX

Consultant

Responsibilities:

• Developed multiple dashboards, analytical reports, KPIs and interactive reports based on business requirements.
• Conducted interviews with key business users to collect information on business processes and user requirements. Documented business processes and analyzed procedures to see that they would meet changing business need.
• Assessed impact of current business processes on users and stakeholders.
• Led process analysis and improvement initiatives using tools such as data and statistical analysis, cost analysis, problem solving/root cause analysis, and other analytical and quantitative methods.