SUMMARY:

Highly skilled senior IT professional with over 9 years of experience in database, system, and application programming and development. Leverage exceptional technical, analytical, and logical skills to conduct all development activities, delivering enhanced capabilities based on clients’ requirements. Adept in analyzing, designing, creating, and maintaining SQL Server. Enthusiastic, versatile team player who works well with all levels of staff, eager to learn new technologies and work on cutting - edge creative projects.

CORE COMPETENCIES:

• SQL
• Stored Procedures
• Functions
• Views
• Data warehouse
• Reporting
• Extract, Transform, and Load (ETL)User Permissions
• Job Scheduling
• Web Pages / Controls
• Star Schema/ Snow Flake Schema
• Product Enhancements
• Operations /Process Improvements
• User Interface (UI) Design & Development

TECHNICAL SKILLS:

Languages: TSQL, MDX, ReactJS, C#, ADO.NET, jQuery, JavaScript

Framework: SQL Server Integration Services(SSIS), SQL Server Analysis (SSAS), SQL Server Reporting (SSRS),ASP.NET

Tools: Management Studio, Visual Studio, WebStrom, Datagrip, Tableau

Version Control: Team Foundation Server (TFS), Microsoft Visual Source Safe (VSS), Tortoise SVN

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Database Developer

Responsibilities:

• Integrated data required for reporting from Confidential Capital Markets Corporation (MCMC) into Confidential Securities core and risk databases
• Developed SSIS packages to extract, transform and load MCMC data to existing database of Confidential Securities
• Implemented business logic using Stored Procedures, Functions and Views
• Scheduled jobs using SQL Server agent and Tidal
• Translated business requirements into functional specifications in order to support reporting from Tableau

Confidential, New York, NY

Database Developer

Responsibilities:

• Contributed to the development and maintenance of Enterprise data warehouse to generate reports/footnotes
• Collaborated with Front office and Middle office teams to gather requirements and generate adhoc reports
• Developed a website for corporate accounting using ReactJS and SQL Server to load data and generate reports for General Ledger (GL) and Multi Ledger (ML)
• Created a tracker for front and middle office teams to set up and analyze payments of mortgage-backed securities
• Built an enterprise data warehouse on Star Schema and an SSAS cube, used by various business verticals for month-end reporting, foot notes generation, General Ledger and Multi Ledger
• Implemented business logic using T-SQL, stored procedures, user defined functions and views
• Used SSIS extensively to load data to database and warehouse
• Scheduled jobs using SQL Server agent and Orchestrator

Confidential, San Francisco, CA

Database Developer and Lead

Responsibilities:

• Automated a process for accounting team to calculate the monthly billing and rebate calculation processes for suppliers and customers
• Collaborated with the business users to gather requirements and delivered projects in Agile sprints
• Designed and developed various SSIS packages to load accounting data in to Star schema warehouse
• Developed SSIS packages to load data with transformations and performed incremental data load packages in SSIS
• Created database maintenance planner with integrity checks and re-indexing to enhance query performance
• Generated adhoc reports for business users, working with charts, linked/sub reports, and report subscriptions

Confidential, Foster City, CA

Full Stack Developer

Responsibilities:

• Developed a proprietary system to identify and flag fraudulent transactions by employees on corporate credit cards
• Created ETL packages with different data sources (SQL Server and flat, Excel source, and XML files) and loaded data into destination tables by performing various transformations, using SSIS packages
• Supported business users by gathering and documenting business requirements and developed reports using table and matrix controls
• Wrote queries to generate reports for data analysis using SQL Server Reporting Services and Report Builder
• Designed and created report templates, bar graphs and pie charts on financial data
• Developed T-SQL stored procedures, triggers, views and stored procedures
• Migrated existing data to all client databases created by using horizontal scalability
• Developed UI using ASP.NET and designed web services for communication between UI and database
• Built UI pages using JavaScript, jQuery, and Ajax and leveraging session variables, cookies, and query strings

Confidential, Dallas, TX

Full Stack Developer

Responsibilities:

• Built a system to calculate partners and directors bonuses based on client relationships and individual performance
• Developed Web Forms and middle-tier components services using .NET 4.0, C#, ASP.NET, and ADO.NET., that are used to calculate end of the year bonuses
• Designed ASP.NET pages with web forms, AJAX, and ADO.NET for data loading and processing with SQL Server 2005 database
• Developed Java scripts for client and server validation, using .NET validation controls, and worked with JavaScript AJAX technology for data services and user request processes
• Worked on Report Definition Language Client-Side (RDLC), SQL Server reports, to display reports on ASP pages
• Designed and developed data warehouses in star schema and loaded data using SSIS packages

Confidential, Fort Worth, TX

Database Developer

Responsibilities:

• Built a system to identify shortest available route for bags on conveyor belts at Miami International Airport
• Developed and executed functionality to automatically select next available shortest route when existing route is not available
• Developed ETL packages to load the bit information of conveyors in to database
• Worked with FactorySQL to trigger the bits from PLC in to the database

Confidential, Dallas, TX

Full Stack Developer

Responsibilities:

• Key member of a strategic reporting project to calculate engagement economics like gross economic margin to validate and report engagement profitability to leadership
• Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like charts, graphs and filters
• Created stored procedures using TSQL and MDX queries
• Tuned the queries by altering the queries, joins, indexes, statistics and executions plans

Confidential, Plano, TX

Database Developer

Responsibilities:

• Designed and developed SSIS packages to load employee information to the database
• Developed SSRS reports for banks to analyze employee matrix to the managers
• Designed Forms and reports using MS Access 2007.