SUMMARY

• Entrepreneurial - Spirited and Result-Oriented technical professional with great knowledge and experience in software development and data intelligence domain, looking for Data Architect opportunity.
• I can help the client to build and deliver world-class smart-data technology.
• Focus on exceeding customer expectations through robust, innovative and strategic-thinking.
• By maintaining knowledge and hands-on experience of leading edge technologies in software development and data intelligence domain
• I am able to actively contribute to solutions portfolio by providing strategy direction ranging from technical knowledge, methodologies and implementation of it, based on experience gained from customers projects.
• In just 2 month design cloud migration solutions for mission critical finance applications that transform the applications from corporate network to Windows Azure private cloud
• Conversion and data migration of MySQL database application to Azure SQL database and reverse engineering of php application ETL processes and transfer it to Azure Data Factory (ADF) within 10 weeks
• Built in 12 month from ground up EDW and Ad-Hoc Reporting System with C-Level Dashboard for Operation, Marketing and Finance departments
• Architect and implement in house data warehouse with ad-hoc reporting system that save the company more than $200K annually
• Plan and manage data center to cloud migration(AWS); retire over 20 servers and save over $100K in operating expenses
• 23 years in IT with excellent problem solving, critical and analytical thinking skills that helps me with consultant advisory role and creation of smart-data strategy for a client

TECHNICAL SKILLS

Database: MS SQL Server, Azure SQL, MySQL, MongoDB

DB Tech: OLTP, OLAP and Hybrid, NoSQL, Structured and Unstructured datasets, Data Modeling, Normalization, DeNormalization, NoSQL, Snowflake

Languages: SQL, T-SQL, MDX, XML, JSON, C#, UML, Powershell

Technolog ies: SQL Azure/ 2017/2016/2014 …, SQL Data Warehouse(EDW), Azure Data Factory (ADW)Azure Synapses, Azure Blob, SQL Stack, VS Data tools, SSMS, SSIS, SSAS, SSRS, Red Gate.NET, MS Visual Studio, SQL Sentry, Idera SQL Diagnostic Manager, MS Visio, Visual Source Safe, TFS, Jira

O S: Windows Servers, Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential - Rosemont, IL

Sr. Solution Architect Consultant

Responsibilities:

• Evaluation and lead changes for the current software, databases and infrastructure environment for the Finance Department
• Collaborate with developers, DBAs, and network engineers to enhance support-ability and identify Finance Application performance bottlenecks
• Provide subject matter technical expertise to the internal and external/vendors technical teams.
• Analyze reporting system architecture performance and research and develop alternative architecture solutions
• Lead development prototype Intelligent Analytics project in Azure Data Factory, Azure Data Lake and Power BI Reporting Solution
• Build data pipelines and perform code review to ensure design is reusable and meet high quality standards
• Architect and playing key tech liaison role between network, security, data management, architecture teams with migration of General Ledger and Recon System to Azure private cloud
• As Architect oversaw major enhancements to Financial software systems
• Orchestrated efficient large-scale software deployments, including risk management, planning deployment and communications across multi-departments and stakeholders UAT
• Demonstrated in-depth knowledge of corporation organization, procedures, policies and know how things is done in the company
• Help team to documentation and design of all Finance Software ETL processes including technical play books to be used by application support and production support specialists
• Performed third level production support

Tech: SQL Azure/2016/2014, SSIS, SSAS, SSRS, Power BI, SQL Datawarehouse, Azure Data Factory, Azure Data Lake, SQL Server Always On, SQL scripts, st.procedures, views, triggers, SQL backups/restore, ETL, ELT, flat files, reports, MDX, JSON, Azure Active Directory, Active Directory

Confidential - Lincolnshire, IL

Sr. Solution Architect Consultant

Responsibilities:

• Conversion and data migration of MySQL database application to Azure SQL database and reverse engineering of php application ETL processes and transfer it to ADF
• Design and built complex multi-processes ETL for transferring data from FTP to SQL db with necessary data transformation for insurance data validations and quality.
• Evaluation software/servers/database/security network infrastructure and implement/supervise changes for various clients
• Demonstrated ability to mentor, motivate, and train client’s tech personnel
• Served as agile process facilitator (SCRUM master) to assist local and remote team members in maximizing work efficiency
• Create logical and physical database model for custom inventory printing system
• Produce ad-hoc management reports ranging from pricing and inventory management to categories and item’s clients usage
• Design strategic plan for SQL Server upgrades from SQL 2008R2 to SQL 20016 and facilitate execution of the plan.

Tech: SQL Azure/2016/2014, SSIS, SSAS, SSRS, SQL Server Always On, SQL scripts, st.procedures, views, triggers, SQL backups/recovery, ETL, flat files, reports, MDX, XML, JSON, EDI, C#, VBscript, AD

Confidential - Woodbridge, IL

Sr. Data Architect - Consultant

Responsibilities:

• Evaluation of enterprise SQL Infrastructure and partners with network team on implementation of changes based on SQL Tech standards.
• Provide subject matter technical expertise to network, development, reporting and operational teams
• Design and built from ground up Enterprise Data Warehouse and Ad-Hoc Reporting System with C-Level Dashboard for Operation, Marketing and Finance departments.
• Develop logical and physical snowflake database model
• Design and built complex multi-processes for transferring data from multi source systems to SQL db with necessary data transformation for insurance data validations and quality
• Assist in the creation and tracking of business key performance indicators for Analysis Cubes
• Managing the data flow from external providers
• Working directly with marketing, operations and finance teams across multiple international markets, you will provide sales reporting and sales performance data to senior management
• Creation SQL Server AlwaysOn high-availability solutions that has multiple datacenters
• Create SQL migration plan for Data Center migration and supervise execution of it

Tech: SQL 2014/2008R2, SSIS, SSAS, SSRS, SQL Server Always On, SQL scripts, st.procedures, views, triggers, SQL backups/recovery, ETL, flat files, reports, MDX, Windows, Active Directory

Confidential - Chicago, IL

IT Manager/Architect

Responsibilities:

• Accountable for security/software/network infrastructure and IT team
• Identification of technical strategic planning and execution based on business vision of the C-Level executives
• Plan Information infrastructure risk assessments and response and manage strategies for increasing stability and quality work of IT department projects
• Facilitate the coordination and alignment across the technology area to support overall strategic planning towards the achievement of Tech-wide goals and objectives
• Contribute to organizations profitability by generating and cultivating new business opportunities and by providing technical support for deal proposal development
• Supervise and review work performed by staff
• Evaluate employee skills and knowledge regularly, providing hands-on training and mentoring to individuals with lagging skills
• Provide subject matter expertise to help business team with strategic planning, change management, and business process improvement
• Oversee and manage of full lifecycle software development using scrum in agile process framework
• Demonstrated ability and knowledge to understand and problem solving technical issues/solutions with time, cost, and human factors
• Accountable for consistent implementation plans, including cost-benefit, risk assessment and ROI analyses
• Analyze software that was not performing to expectations and develop techniques for improvements.
• Recruit/manage talented employees, delegate and prioritize tasks and initiate time-frame for when all tasks had to be completed

Tech: SQL 2012/2008R2, SSIS, SSAS, SSRS, SQL scripts, st.procedures, views, triggers, SQL backups/recovery, ETL, flat files, reports, MDX, Windows, Active Directory (AD)