SUMMARY:

• Seasoned IT data professional and Microsoft Certified Solution Expert (MCSE) in on Data Management and Analytics platforms with more than fifteen years of solid exposure to the IT environments coupled with extensive expertise in architecting and devising end to end scalable solutions from ground up.
• A solid track record of architecting enterprise data stores for transactional, reporting, analytics and non - relational solutions.
• Administer and support MS SQL servers 2016 in clustered environment for high performance, data driven web sites and intranet applications.
• Formulate and implement Enterprise Data Integration strategies and solutions across heterogeneous systems using MS BI Suite and Azure Services to meet complex data consolidation needs.
• Deploy and manage Team Foundation Server 2015 and execute various System Development Life Cycle (SDLC) methodologies including Agile to meet the intricate challenges of projects.
• Highly Self-motivated and result oriented with excellent analytical & communication skills.
• Demonstrate exemplary track record of meeting or exceeding client expectations and delivering projects on time.

TECHNICAL SKILLS:

Data Management Systems: SQL Server 2016, 2012/2014, 2008, Azure SQL Database, Azure SQL Data Warehouse

Development Tools: SQL Reporting(SSRS)/Integration(SSIS)/Analysis Services(SSAS), Power BI, NoSQL, Hive, DAX, Big Data Analytics, Stream Analytics, Hadoop, HDInsight, Azure Data Factory, Machine Learning, Data Lake Store/Analytics, PowerShell Script

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Database Manager/Architecture

Responsibilities:

• Responsible for architecture, development, deployment and maintenance of backend database systems for the county’s internal and external web sites collecting millions of dollars in property tax revenue each year.
• Install, configure and administer MS SQL Servers in clustered environment including Integration, Analysis and Reporting Services.
• Ensure data integrity, reliability, accessibility and high availability using scalable data architecture.
• Devise data integration, migration, SQL server sizing and Disaster Recovery strategies.
• Design and set up database architecture, logical and physical data models for transactional, reporting and analytic systems.
• Write complex and optimized stored procedures, scripts and troubleshoot performance issues.
• Design and build highly efficient and dynamic SSIS/ETL packages to move data across wire and feed into data warehouse/management and mainframe systems.
• Create reports using MS Reporting Services and develop data models for self-service analysis using MS BI tools.
• Work with stakeholders to facilitate their needs for automation, technical specifications and business rules.
• Design, implement and test backup and recovery strategies to meet Recovery Time and Point Objectives.
• Explore research and bring them online new data new technologies to optimize IT Operations.
• Manage a group of SQL administrators and developers and provide technical guidance, direction and mentorship on coding, methodologies, standards, etc. for effective software development.
• Also configure, deploy and administer Team Foundation Server 2015.

Confidential

Responsibilities:

• Architected and implemented High Availability and Disaster recovery solutions for the county’s core database systems using SQL server Always On technologies.
• The solution offload the main database systems off reporting and back-up needs and also makes the data available at DR sites using secondary replicas on-premises and in Azure.

Confidential

Responsibilities:

• Designed, developed and deployed back-end database system for the county’s electronic warrant books.
• The project reflects the integration and consolidation of data across various county offices and main-frame system.
• The project completely digitized the physical warrant books representing county’s official 500 million transactional data over the last 20 years.

Confidential

Responsibilities:

• Architected, designed, developed and deployed Confidential solutions for the end users using MS SQL server Integration, Reporting and Analysis services.
• The solution employs Data Warehouse system optimized for Analysis Services using Dimension Modeling and Star Schema.
• The data mart houses 500 million data row spanning last 20 years of transactions which are being updated on daily basis using fast performing dynamic SSIS packages.
• The Analysis Services allow end users to run reports without knowing underlying schema.

Confidential

Responsibilities:

• consolidated county data across many Cook County offices and presented on the county’s portal in a one-stop shop fashion for tax payers.
• The portal utilizes highly efficient ETL packages to download files from various county offices and integrate them into more presentable format.
• The portal is one of its kinds in the nation and presents the snapshot of last five years data on a property within the county.

SQL server

Confidential

Responsibilities:

• Successfully migrated current SQL server 2012 Development, UAT and Production environments representing more than 100 databases across 25 SQL server instances to SQL Server.
• The project was hallmarked by utilizing the latest features and functionalities out of SQL Server 2016 including High Availability and Azure Integration. Also successfully migrated SQL server.

Confidential, Hoffman Estates, IL

Application Development Specialist

Responsibilities:

• Developed UI and Business objects using Visual Basic\COM\MTS
• Designed and created reports for business analysis using Crystal Report
• Integrated external software components into current the application

Data analysis, Design & Maintenance

Responsibilities:

• Created logical and physical data models by grouping data into entities, applying normalization rules
• Set up tables and defined relationships, indexes, constraints, etc
• Created stored procedures, views and triggers to support various applications
• Created DTS packages for transferring data across various data sources

Application Support & Maintenance

Responsibilities:

• Maintained the systems in productions and resolved production issues
• Carried out version upgrades and releases to add more functionalities according to business requirements
• Provided technical support and created technical documents for reference