SUMMARY

• Highly motivated, self - reliant, dedicated IT professional with experience in data modeling, data architecture, data warehousing, business intelligence, data analytics, solution and enterprise architecture.
• Strong experience in all SDLC phases including requirement gathering and analysis, design, development, integration and testing, deployment and maintenance using Agile, Waterfall and Iterative methodologies.
• Extensive experience in relational and dimensional data modelling, star and snowflake schemas, with good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) methodologies.
• Strong experience in conceptual, logical and physical data modelling for OLTP and OLAP systems.
• Strong experience in developing data warehouse, data marts, database tables, triggers, indexes, integrity constraints, views, procedures, functions, packages in PL/SQL and T-SQL on Oracle and SQL Server.
• Experience with Informatica PowerCenter & Cloud, SSIS, SSAS for data capture, data integration and transformation, data quality to support data marts, data warehouse, reporting and analytics.
• Experience with Tableau, SSRS, Power BI for creating reports, charts, graphs, visualizations, dashboards, data stories.
• Experience with Database Administration on Oracle, SQL Server, MySQL.
• Strong collaboration, communication, analytical, technical writing and team management skills.
• Significant business noledge and experience in financial, HR, environmental quality, logistics, retail, manufacturing, telecommunications, LMS, LCMS, realty, GIS and decision support solutions.

TECHNICAL SKILLS

Databases: Oracle Exadata, MS SQL Server, Sybase, MySQL, MS Access, DB2, MongoDB

DW & BI Tools: Tableau, MSBI (SSIS, SSAS, SSRS), Power BI, Informatica PowerCenter & Cloud

Data Modeling: TOAD Data Modeler, ER/Studio, Erwin Data Modeler

Database Tools: TOAD, Oracle SQL Developer, SQL Server Management Studio, SSDT, BIDS

Programming: SQL, PL/SQL, T-SQL, NoSQL, Python, R, ColdFusion, PHP, Java, HTML, JavaScript, Ajax, CSS, XML, jQuery, Angular JS

IDE: Eclipse, Dreamweaver, PyCharm, R-Studio

Other Software: MS Office, Visio, Axure RP, JIRA, Bugzilla

Version Control: Sub Version, CVS, Visual Source Safe, Git

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Senior Data Architect

Confidential, Austin, TX

Responsibilities:

• Worked on multiple applications as data/application/enterprise architect in leading teh design and implementation efforts of many complex projects: Budget Accounting and Monitoring System (BAMS), HR Retooling, Budget Creation, Grants, Public Information Request Collaboration System (PIRCS), Inventory Management Database (IMD), Texas Air Monitoring Information System (TAMIS), Toxicology, Air Permits Allowable Database (APAD), Texas Air Emissions Repository (TexAER), Texas Watermaster Accounting Software (TxWAS).
• Responsible for scoping, design, development and maintenance of transactional databases, data warehouse, data marts, ETL processes, business intelligence, data analytics within teh organization in Oracle and SQL Server.
• Created and maintained conceptual, physical and logical data models using TOAD Data Modeler, solution designs, data architecture planning and documentation.
• Lead design, development and deployment of OLTP, OLAP (Data warehousing & BI) solutions to address various business needs including business analysis, design of technical and functional architecture, creating SDD and SRS, creating requirements traceability matrix(RTM) and tracking, decompose user requirements into relevant Use Cases, EPICS and User Stories, define key deliverables and sprints in an Agile environment.
• Interacted directly with non-technical resources like business users, customers, key stakeholders to collect teh requirements, explaining solutions, workflows and prototypes, user acceptance and documentation sign off.
• Interacted directly with technical resources like business analysts, QA team, tech lead, project manager in sharing or discussing project details, updating or collecting status, assigning tasks, guiding others in teh team in their tasks.
• Involved in developing, implementing and documenting agency-wide technical standards, tools, methodologies, data dictionary, information security policies, programming standards, database design principles, strategies, methodologies, improvement plans, naming conventions, best practices, peer reviews.
• Mentored, trained and set up teh coding standards for many developers in producing efficient, clean code that uses a lot of new concepts in database programming.
• Designed and developed databases, data warehouse, data marts including tables, constraints, indexes, triggers.
• Created CRUD operational queries, views, stored procedures, functions, PL/SQL packages for ETL processing, reports generation, data purging, sending data-driven email notifications.
• Design, direct and implement ETL\ELT processes, including data capture, data integration, data quality, data profiling, testing and validation methods to support data marts, data warehouse, reporting and analytics.
• Used Informatica cloud to integrate data across cloud-based applications and on-premise systems and databases.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse using Informatica PowerCenter.
• Created reusable transformations and used various in-built transformations like router, filter, expression, sequence generator, source qualifier, aggregator, update strategy, joiner, stored procedure and union to develop robust mappings, mapplets, tasks, sessions, worklets and data integration workflows in Informatica PowerCenter.
• Implemented new jobs using workflows within teh scheduling environment to support daily, monthly, quarterly, and yearly Business Intelligence needs using Informatica PowerCenter.
• Designed and developed teh multiple ETL packages in PL/SQL, SSIS with multiple data transformations for automation of data acquisition from variety of data sources like flat files, excel, MS Access, SQL server, Oracle.
• Developed data warehouse cubes and reporting solutions as defined by teh business need using SSAS, SSRS.
• Designed, developed, implemented, analyzed and modified ad-hoc reports, visualizations, dashboards and data stories for data analysis, reporting, and business intelligence using Tableau Desktop, Power BI Desktop for budget analysis, budget reporting and reconciliation, performance metrics, environmental (air & water) quality data analysis, reporting, forecasting and quality control from a variety of data sources.
• Created different visualizations using slicers, lines, pies, histograms, maps, scatter, etc. and generated drill through and drill down reports with drop down menu option, sorting teh data, and defining subtotals along with calculations, conversions in Microsoft Power BI and Tableau Desktop.
• Lead teh deployment of new systems into production, coordinate production releases, create DDL and DML and any other code base for teh release, troubleshoot technical problems, conduct peer reviews.

Environment: Oracle 8i/9i/10g/11g/Exadata, SQL Server 2008/2012/2016 , Azure SQL, MySQL, TOAD, TOAD Data Modeler, Informatica PowerCenter 8.6/9.1/9.6, Informatica Cloud, Microsoft SSIS, SSAS, SSRS, Power BI Desktop, Tableau Desktop 7/8/9/10/2018, Axure RP 8, XML, SVN, JIRA, Bugzilla

IT Consultant (Application/Data Architect)

Confidential, Cleveland, OH

Responsibilities:

• Played teh lead role in application and data architecture, planning, design, development and deployment of Confidential V3, Confidential V4, Tire Hotel applications.
• Interacted with key stakeholders to collect teh business requirements, designed and documented teh technical and functional architecture of Tire Hotel application, created and maintained data models using Erwin.
• Provided guidelines, standards, and mentored teh development team, reviewed and validated code, to ensure that they meet teh organization IT procedures and policies.
• Designed and developed database tables, triggers, stored procedures, views, and functions using T-SQL.
• Wrote CRUD processing stored procedures, created views, indexed views in T-SQL, normalized operational data stores and denormalized data warehouse for performance tuning.
• Created various matrix, tabular, drill down, drill through, and parameterized reports, charts, graphs, and sparkle lines, dashboards using SSRS to track important retail Key Performance Indicators (KPIs) and metrics, quickly collect and visualize multi-faceted business data, access top-level and cross-channel sales analytics.
• Involved in analyzing, designing, building and testing of multi-dimensional OLAP cubes with SSAS.
• Designed SSIS packages to handle ETL process using various transformations to efficiently automate data integration from various external data sources using SSIS.
• Created dashboards using Business Intelligence Development Studio (BIDS).

Environment: SQL Server 2005/2008, T-SQL, SSIS, SSAS, SSRS, BIDS, HTML, CSS and JavaScript, VSS, Erwin.

IT Consultant (Development Lead)

Confidential, Memphis, TN

Responsibilities:

• Lead software development efforts including maintenance, bug fixing, enhancements, requirements gathering, analysis, design, development, testing and deployment of new development, assigning tasks, mentor other developers, conducting status meetings and status reporting.
• Created database tables, indexes, constraints, views, indexed views, stored procedures, triggers.
• Developed ETL tasks using Data Transformation Services (DTS), SSIS and imported/exported data from various data sources like flat files, Excel, MS Access, to SQL Server using DTS and job scheduler.
• Responsible for performance tuning by optimizing teh queries and views.
• Developed various tabular, matrix, operational drill-through and drill-down reports, sub reports, charts, linked reports, dashboards, Sparklines, Data Bars, Map Charts, Gauge Charts using SSRS to analyze loads, routes, carriers, tendering, bookings, customs filings, freight audit and payment, transportation related costs and optimize logistics management strategy.
• Developed different kind of reports such a sub reports, charts, matrix reports, linked reports.

Environment: SQL Server 2000/2005, SSRS, DTS, SSIS, SVN.

IT Consultant (Development Lead)

Confidential, Memphis, TN

Responsibilities:

• Lead teh design and development of Online Appraisal Management application.
• Wrote teh CRUD processing T-SQL stored procedures, functions, views and indexed views to address teh performance issues and to make enhancements to teh OLTP and OLAP operations.
• Provided technical solutions, line management and development of a team of software programmers.
• Assigned tasks to developers for parts of code and monitored progress to ensure deadlines are met.

Environment: ColdFusion 6.1, Fusebox, SQL Server 2000, XML, HTML, CSS and JavaScript.

IT Consultant (Tech Lead)

Confidential, Des Moines, IA

Responsibilities:

• Performed as technical lead to customize GeoMaestro LMS/LCMS suite to multiple clients based on their requirements to implement a learning management solution for planning, delivering, and managing all learning events, including online, virtual classroom, and instructor-led courses and LCMS solution, which gives authors, instructional designers, and subject matter experts teh means to create e-learning content more efficiently
• Mentored and delegated tasked to teh UI design, development and QA teams in delivering teh customized product and enhancements to teh new and existing clients.
• Developed database tables, views, indexed views, stored procedures, functions, packages in T-SQL.
• Created ColdFusion components & web services towards teh server-side processing of teh application.

Environment: ColdFusion 6.1, SQL Server 2000, T-SQL, HTML, JavaScript, Fusebox, Windows 2003, Homesite, VSS.

IT Consultant (Sr. Developer)

Confidential, Memphis, TN

Responsibilities:

• Involved in teh design, development and implementation of COS2/GNSL support application, which is a query-based reporting system designed to provide timely reporting of service level performance based on customer commitment, Market Council Performance Reporting, which measures Volume, Revenue for Express and Ground, and teh portal development for Retail Marketing Operations and Sales using ColdFusion MX, SQL 2000, JavaScript, and HTML.
• Involved in teh redesign of Market Council, enhancements, bug fixing, remodeling and performance tuning.
• Designed, developed and implemented teh systems using PHP, SQL Server 2000, and MySQL.
• Designed and developed database tables, SQL queries, T-SQL Functions, Procedures and Triggers to handle various data operational tasks.
• Optimized teh long running queries using standard optimization techniques to address teh performance issues.
• Involved in teh development of web-based reporting applications using WebFocus, PHP, ColdFusion, HTML.
• Performed secondary tasks including web support, maintenance and troubleshooting.

Environment: ColdFusion 6.1, PHP, SQL Server 2000, MySQL, Navicat, WebFocus, HTML, Java Script, CSS.

IT Consultant

Confidential, St. Louis, MO

Responsibilities:

• Involved in design and development of an intranet application called “Sales Order / Tracking System”, which stores, tracks and process teh workflow of sales like Call Center Sales, Premises Sales, and Distributor Sales of their different services, along with a document management system to archive and retrieve teh customer related documents electronically, and a web-based reporting system for sales analysis and reporting.
• Developed dynamic web pages and reports using ColdFusion, CFML, HTML, CSS and JavaScript along with Custom Tags, user-defined functions (UDFs), inline queries.
• Designed and developed teh database tables, views, triggers, procedures, functions and packages in Oracle PL/SQL.
• Optimized teh long running SQL Queries to address teh performance issues.
• Responsible for ColdFusion server administration, application maintenance, performance tuning, configuration, translating business requirements to technical design, writing technical documents.

Environment: ColdFusion 5.0/MX 6.0, Dreamweaver MX, JavaScript, Oracle 8.1.7, Windows 2000.