PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Data Warehouse Architect/Manager

• Inovvo provides analytical solutions to mobile operators helping Marketing and Care organizations gain insights into Subscriber’s experience and usage on the network.
• Hired to lead data architecture, modeling, analysis, and data warehousing development efforts and work with teams of individual technical contributors across multiple geographic locations and technical disciplines having responsibility for significant project outcomes of analytics platform. Additionally, managed technical/data modeling/BI requirements/architectural customer interactions and participated in onsite meetings.
• Continued to evolve the data warehouse and data marts used by the platform to meet customer specific interfaces and business intelligence/ data analysis requirements.
• Led the effort for data modeling of the data warehouse, database architecture including metadata and audit databases using MS - SQL Server, Oracle, and Vertica.
• Led optimization efforts for daily load and transformation of billions of records to meet data load and analytical query Service Level Agreements (SLAs).
• Provided leadership in engineering the solution, overall data architecture including extraction, transformation, and loading (ETL) for the solution offered.
• Perform validation and accuracy review of data loaded in customer staging and production data warehouse/data marts.
• Collaborated with the project manager to define the project's scope and estimation tasks and track the resolution of issues, enhancements, and other deliverables.
• Worked with technical writers, business owners/analysts and data analysts for quality internal and external client-oriented documentation.
• Provided expertise to identify and translate system requirements into software design documentation.
• Helped business development life cycle by serving as a product SME to help identify and qualify business development opportunities.
• Participated in project planning, agile development and SCRUM.
• Coordinated with Sales and Product Management for product demos, presale activities, RFPs, change orders and Proof of Concepts (POCs) to facilitate sales processes.

Technologies Used:

• Analytics Application using C#, .net, SQL Server (metadata), XML
• Data Transformations and loading (ETL) using SSIS, Apache Storm
• RDBMS/MPP/Data: MS SQL Server 2008/2012, Oracle 10g/11g, HP Vertica
• Query - SQL, T-SQL, MDX, PL/SQL

Confidential, Reston, VA

Data Warehouse Architect/Manager

• ComScore’s Subscriber Analytix software platform for mobile wireless service providers, provided the ability to turn digital subscriber data into insight for Marketing, Care, and Network teams - all to drive improved ARPU, cost reduction, share growth and a differentiated subscriber experience.
• Hired to build and manage data engineering, development, and testing efforts of multiple implementations of comScore’s subscriber analytics platform (a large enterprise level data warehousing and analytics solution). This was achieved by transforming billions of records across all digital devices into differentiated insight and performs advanced analytics on digital mobile data.
• Provided ownership of database analysis & design, data modeling and development of analytics solution offered to various clients using different databases as per client and data volume needs.
• Led the efforts for creating the ETL Layer of the solution, responsible for processing all dimensional interfaces and fact data interfaces, applied concepts of dimensional modeling & SCD using SSIS.
• Represented comScore at many customer facing meetings to provide to technical consulting & elaborate data use case details and work with other vendors working on other data sets used in the solution.
• Created the overall product database model and customizations to model as per client requirements including OLAP and dimension modeling.
• Created many prototypes including data extraction, cleansing, transformation and loading, validation using tools such as SSIS, Custom Scripts.
• Wrote and optimized SQL, T-SQL, and MDX queries.
• Evaluated various analysis/visualization tools such as Tableau, QlikView to understand features/ capabilities and build those features into in-house analytics application.
• Participated in project planning including scope estimation and tracking resolutions to enhancements, Agile development, and Scrum.
• Worked with technical writers, business owners and data analysts for quality internal and external client-oriented documentation.
• Defined standards and guidelines for data architecture, UX (User Experience), performance & scalability.

Technologies Used:

• Analytics Application using C#, .net, SQL Server (metadata), XML, SSRS (SQL Server Reporting Services)
• Data Transformations and loading (ETL) using SSIS, Apache Storm
• RDBMS/MPP/Data: MS SQL Server 2005/2008/2012, IBM Netezza
• OLAP - SQL Server Analysis Services (SSAS), Excel
• Query - SQL, T-SQL, PL/SQL, MDX

Confidential, Reston, VA

BI Architect

Responsibilities:

• Worked as lead architect on Network Analytics and Demand, Capacity and Forecast tool for wireless operators in USA and EMEA regions to enable customers to improve network performance and growth.
• Gathered and documented requirements and helped translate requirements into technical specifications.
• Created design documents to build reusable and generic BI components within the solution using MS BI Stack (SQL, SSIS, SSAS, SSRS)
• Developed, used, and tuned T-SQL, and MDX queries.
• Led the team of developers to build the database design, cubes, ETL layer and analytical reporting functionality.
• Worked with technical writers, business owners and data analysts for quality internal and external client-oriented documentation.
• Optimized the application response times for front end and back end processes, using load testing methods and tools to achieve critical SLAs.
• Coordinated with project management, SMEs, and delivery director to facilitate timely delivery of the solution.
• Represented Nexius for customer interactions (business and technical side) during pre and post-deployment phases.

Technologies Used:

• Analytics Application using C#, .net, SQL Server (metadata), XML, SSRS (SQL Server Reporting Services)
• Data Transformations and ETL using SSIS
• RDBMS: MS SQL Server 2005/2008, Oracle 10g
• OLAP: SQL Server Analysis Services (SSAS), Multi-dimensional Cubes
• Query: T-SQL, PL/SQL, MDX

Confidential, IL

Technical Lead

Responsibilities:

• Develop from scratch the entire ecommerce site including the basic pages like Catalog page, Product page, Shopping Cart page, Shipping page, Billing page, Payment page and Order Confirmation page.
• Provide the support for payment through various credit card vendors like Visa Card, Master Card, Discover and customized Newport News credit card etc.
• Provide data load application to load the data from their mainframe systems. Also, application to support features such as billboard admin, categories/products/styles set up etc.
• Worked with DBA to come out with normalized database tables with relevant constraints like primary key constraint, foreign key constraint, unique constraint, check constraint etc. Used database sequence and indexing wherever applicable.
• Involved in developing the site browse pages, product pages and shopping cart/checkout pages.
• Developed stored procedures using T-SQL, used triggers, cursors in SQL Server 2000.
• Responsible for scheduling data backups, creating jobs (for sending newsletters, updating stock info etc.) in SQL Server 2000.
• Cached data and optimized application for performance (estimated load of 20000+ simultaneous users)
• Used ADO .NET for Interaction with SQL Database, passed parameters to Procedures and Queries from the application.
• Used validating controls for validating client side data entry screens
• Implemented business validations and business logic in C#.
• Developed ASCX Controls, Custom Controls and used them in ASP.Net Pages.

Technologies Used: ASP.NET, Visual C#.NET, HTML, Java Script, VB Script, SQL Server 2000, Visual Studio 2003, IIS 6.0, VSS.

Confidential

Sr. Software Engineer

Responsibilities:

• Participated in requirement gathering/analysis for new developments in the project.
• Wrote stored procedures using T-SQL.
• Created fact tables, dimension tables and involved in continuous dimension update process.
• Responsible for creating & processing Cubes & writing MDX in OLAP cubes (SSAS).
• Worked on creating web reports using ASP.NET and office web components
• Responsible for coding the PMMS Load Module, which handles data validation and loading from flat files to SQL Server database and then processing the cubes.
• Worked on Report Development Language & MS Reporting services to create analytical reports.
• Designed and Developed Web forms using C#.Net
• Used Object-Oriented approach for design and development.
• Developed GUI, business objects, data access layer, stored procedures and queries.
• Debugged the code, created Unit Test Cases and tested the application using Unit Testing.
• Worked in team environment and used Visual Source safe for version control and change management.

Technologies Used: ASP .NET, C# .NET, ADO .NET, Web Services, SQL Server 2000/2005, HTML, JavaScript, Analysis server, OLAP Cubes, SSAS, DTS, MDX, Visual Source Safe.

Software Engineer

Confidential

• Worked on web based applications using ASP.NET, Visual C#.NET, HTML, Java Script, VB Script, SQL Server 2000, Visual Studio 2003, IIS 6.0, VSS.

Confidential

Programmer/System Analyst

Responsibilities:

• Confidential , Hotel reservation booking engine, a comprehensive web based tool that connected member hotels worldwide with travelers through global network of partner web sites. Worked as Project lead and used technologies such as ASP.NET, Visual C#.NET, HTML, Java Script, VB Script, SQL Server 2000, Visual Studio 2003, IIS 6.0, VSS.
• Built specialized web based application for Wireless Applications and Consulting Services (WACS), to leverage AMR data in electric, gas and water utility industry. The solution was capable of storing and retrieving AMR data for up to 2 million gas, electric, water, and steam meters for approximately five years, using technologies such as VB 6.0, ASP, C#, JavaScript, VBScript, HTML, ASP 3.0, ADO, Oracle, IIS, VSS.
• As Programmer Analyst, worked on several web based applications such as Suzuki Insurance, Suzuki Finance, Fleet Management System for Confidential using IIS 5.0, ASP 3.0, C#, VB 6.0, VBScript, JavaScript, ADO, OLEDB, MTS, SQL Server 7/2000, Seagate Crystal Reports, MS-VSS 6.0.

Software Engineer

Confidential

• Worked on financial accounting product using client server model, and eventually migrated the application to web based interface. Used technologies such as IIS 5.0, ASP 3.0, C#, VB 6.0, VBScript, JavaScript, ADO, OLEDB, MTS, SQL Server 7/2000, Seagate Crystal Reports, MS-VSS 6.0.