SUMMARY:

• 16+ years of experience in software application development and implementation experience with web based and client server including all phase of SDLC
• 16+ years of experience in SQL Server database platform, 3+ years in Oracle
• 3+ years of experience in SharePoint integration with ASP.NET
• 4+ years of experience in Web service and WCF development

TECHNICAL SKILLS:

Programming Languages: C#, VB.NET, Java

DBMS: MS SQL Server 2010, 2012, Oracle 10g

Reporting Tools: Logi Info, Dundas Dashboard, Cognos, Tableau, SSRS, Crystal Reports

Version Software Tools: Team Foundation Server (TFS), Subversion (SVN), Git, Visual SourceSafe (VSS)

Scripting Languages: VB Script, Java Script

Middleware/Libraries: Web Services, WCF, COM

PROFESSIONAL EXPERIENCE:

BI Developer

Confidential, Durham, NC

• Develop consumer based features and applications using Ruby on Rails, JavaScript
• Develop BI reports using Logi Info to provide dashboard and aggregated data
• New full text search feature implementation with multi­tenancy. (Elasticsearch, Logstash)
• Used Pentaho Data Integration to develop jobs for extracting, transforming and loading data into data warehouse

Tools: Ruby on Rails, Logi Info, Elasticsearch, Logstash, Kibana, MySQL, Pentaho Data Integration

BI Developer

Confidential, Washington, DC

• The Confidential is the builder and steward of Confidential, serving Congress and the Supreme Court, creating a home for American democracy. The AOC traces its beginnings to 1791. Today, the AOC is comprised of approximately 2,300 employees who serve Congress and the Supreme Court in a variety of occupations.
• Create SSAS Tabular Model and support the existing database components
• Develop/architect report database using SQL Server with SSIS for Accounting Tabular Model based on transaction log
• Used SSIS to develop jobs for extracting, transforming and loading data into data warehouse

Tools: SQL Server using SSIS and SSAS, Visual Studio 2012 using Tabular model

BI Developer

Confidential, Alexandria, VA

• Develop/architect CRM solution for USPTO executives for Business Intelligence purposes in ASP.NET.
• Implement entity­relationship/multi­dimensional modeling in Snowflake schema
• Develop Dundas Dashboard reports and integrate the components into ASP.NET pages
• Develop BI report queries to provide dashboard and aggregated data with components such as charts, gauge and export functions

Tools: SQL Server 2012, Visual Studio 2013, Dundas Dashboard

ETL Lead Developer

Confidential, Herndon, VA

• Develop/architect report database using SQL Server with SSIS for timesheet analysis and resource allocation utilization based on timesheet log
• Implement slowly changing dimension mappings for Type 1 and Type 2 SCD
• Implement entity­relationship/multi­dimensional modeling in star schema
• Develop/architect SSIS packages to load data from various database sources including MS SQL server and Oracle that run daily basis.
• Develop BI report queries to provide dashboard and aggregated data with components such as charts, gauge and export functions
• Build ETL including transaction records with various frequency using SSIS

Tools: SQL Server 2012 (SSMS, SSIS), Visual Studio 2010

BI Consultant

Confidential, Richmond, VA

Tools: Oracle 11g, Logi Info, Visual Studio 2010 (C#, Web Service),

• Develop BI reports using Logi Info to provide dashboard and aggregated data with components such as charts, gauge and export functions
• Optimize database performance (memory, time and complexity)

Senior ETL Consultant

Confidential, Reston, VA

• Develop/architect data warehouse using SQL Server with SSIS for homebuilding and banking service provider that carries millions transactions per month
• Develop BI reports using SSRS, Dundas Dashboard and Site Catalyst to provide dashboard and aggregated data with components such as charts, gauge and export functions
• Implement entity­relationship/multi­dimensional modeling in star schema and snowflake schema
• Build ETL packages with various frequency using SSIS and AutoSys
• Optimize database performance (memory, time and complexity)

Tools: SQL Server 2008 (SSMS, SSIS), Visual Studio 2010 (C#, Web Service), Dundas Dashboard, Site Catalyst

Senior Consultant

Confidential, Reston, VA

• Develop/architect report database using SQL Server with SSIS for health care service provider that carries millions test results per year
• Develop BI reports using Logi Info to provide dashboard and aggregated data with components such as charts, gauge and export functions
• Develop web services to communicate with external systems for Confidential that carries all high school records in Virginia state
• Build ETL including transaction records with various frequency using SSIS
• Deploy BI pages into Sharepoint
• Optimize database performance (memory, time and complexity)
• Provide consulting service to clients to meet expectations and resolve technical issues
• Develop web services using Eclipse for financial companies that communicates with mobile applications

Tools: SQL Server 2008 (SSMS, SSIS), Visual Studio 2010 (C#, Web Service), Eclipse (Java EE)

Software Developer

Confidential, Falls Church, VA

• Develop/architect Report framework using SSRS, LINQ, CLR stored procedures/functions and reused conventional report system (Crystal report)
• Develop presentation layer with Crystal Report using Crystal Report Libraries to implement external data set into Crystal Report Object and deploy into SharePoint pages
• Develop file export framework retrieves data from database and/or client
• Develop mail address verification function using web service
• Optimize database performance (memory, time and complexity)
• Provide consulting service to clients to meet expectations and resolve technical issues
• Develop application/interface using Silverlight

Tools: Visual Studio 2008 (C#, Silverlight, SSRS), SQL Server 2008, Blend 3 (Silverlight)

Business Intelligence Consultant

Confidential, McLean,VA

• Provide consulting service to clients to meet expectations
• Provide business requirements Write technical specifications and receive approval from clients
• Develop customized business intelligence solution for internal/external usage using C# and VB.NET.
• Develop web pages to interact with users using ASP.NET in VB.NET Develop customized plug­in components using C# Develop reports based on user security
• Design/Develop ETL system involved with 100+ million records and 50+ tables using SSIS
• Integrate the new application with clients’ existing data stream using SSIS
• Optimize database performance (memory, time and complexity)

Tools: Visual Studio 2005 (C#, VB.NET), SQL Server 2008, Logi Info (BI report generator), Microsoft Team Foundation Server

Software Developer

Confidential, Hartford, CT

• Design/Develop customized Enterprise­level stock trading system using Cameron FIX engine that has 150,000+
• Design/Develop middle tier of the application independent from interface such as cache management and business object layer in agile development environment.
• Existing system is not able to handle high volume so I added features to reduce number of transactions in database server
• Develop cache management system (using hashmap) that holds database table values in application server.
• Develop java objects that communicates with Flash objects
• Optimize database performance (memory, time and complexity)

Tools: Visual Studio 2005 (C#, VB.NET), SQL Server 2005, ColdFusion, Java EE 5, MSMQ, Cameron FIX engine, XML

System Developer

Confidential

• Full life cycle N­tier, large­scale, enterprise­level development in complex financial applications
• Design and develop large complex databases containing more than 300 table, 200 stored procedures, 50 functions and 100 triggers
• Project management in various file export processes. (from writing development specifications to distributing jobs and releasing the products)
• Class design that takes XML as input and returns XML as output by connecting database (VB 6.0, Eclipse, IntelliJ IDEA)
• Report design that uses ADO objects to display requested information (Active Report)

Tools: Java, VS 2003(VB.NET), SQL Server 7.0 & 2000, XML, VB6.0, ASP