We provide IT Staff Augmentation Services!

Sr. Bi/ms Sql Application Programmer (consultant) Resume

New York, NY

SUMMARY:

  • BI/ MS SQL Professional specializing in full life cycle development - design, implementation deployment, maintenance, documentation.
  • Work with Windows Operating System using MS SQL Server, ETL, .Net framework and
  • Reporting Tools to deliver consistent defect-free product.

TECHNICAL SKILLS:

Databases : MS SQL Server 2012, 2008/R2, 2005, BI, MS Access, MySQL

Programming Languages: T-SQL; C#; Visual Basic

Development: MS Visual Studio 2010 - 2005, IIS, Enterprise Manager, SQL Server

Tools : Management Studio, ODBC, .Net

Internet Technologies: VB.NET, ASP.NET, ASP, XML, HTML, DHTML, VBScript, Jscript

Source Control: MS Visual Studio 2012 - 2005Team System, MS Visual SourceSafe

Reporting: SQL Server Reporting Services, SAS, Crystal Reports, Cognos

Operation System: Windows 2012/2008/ 2003/ 2000/ XP/ NT, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. BI/MS SQL Application Programmer (Consultant)

Responsibilities:

  • Design, development and maintenance of system records for Independent Commercial Risk - Confidential .
  • While DBA services for applications provided by Citi’s IT Infrastructure, the day-to-day management and support of the datahandled exclusively by the IT Analysts team, due to the sensitivity of the risk portfolio data.
  • With SQL Server 2012, MS Access, Excel and VBA environment, design, develop and script database objects, including performance tuning and capacity planning.
  • Design of new and migration of existing MS SQL Server 2008/R2 BI objects to SQL 2012 version.
  • Building ETL System with SSIS for data uploads from outside of BI environment.
  • Development of consumer friendly sophisticated reports and charts with complex prompts and filters, using Cognos report studio.
  • Promote database coding standards and guidelines for logical and physical design.
  • Provide training and mentoring to team members to enhance the quality of reports and meet business expectations.

Confidential, New York, NY

Sr. BI/MS SQL Developer

Responsibilities:

  • Designed and developed Usage Based Billing system ( Confidential ). The system is used to charge line of businesses a variable, monthly price for storage, based on the actual amount of space used. The Confidential provides unprecedented insight to the company’s 1,500 TB of File and Print data.
  • One of the major benefits of the system is transparency for the Confidential ’s File and Print storage expenses, allowing them to manage usage and eliminate waste and.
  • The Confidential system comprises of 5 SQL servers linked together using replication.
  • With SQL Server 2012, designed and developed db objects: tables, views, UDFs, stored procedures and assemblies (using TSQL and CRL).
  • Provided Administrative functions as database backup, replication, creation and maintenance (rebuilding) of indices for new and existing tables to improve query performance.
  • Designed and developed distributing system: Replication, Integration Services (SSIS) packages, Web Services.
  • Maintained web site using ASP.NET 2.0
  • Created reports using Reporting Services (SSRS).

Confidential, New York, NY

Sr.SQL Developer/Systems Analyst

Responsibilities:

  • Designed, developed and maintained SQL Server objects: databases, schemas, tables, views/materialized views, stored procedures, user defined functions.
  • Identified and troubleshoot performance issues using SQL tuning tools: execution plan, profiler.
  • Designed and developed data import from various sources using SSIS.
  • Created and scheduled SQL Server jobs to run SSIS packages and SQL stored procedures.
  • Responsible for running process to provide MonthEnd analytical reports for the team.
  • Migrated and automated MS Access processes to production SQL Server environment: Remedial Risk & Opportunity (R&O), Delinquency Reports. Using MS SQL Server 2012 DML and SSIS, developed analytical solutions that reduced manual processing time from 2 business days to seconds.
  • Worked closely with business to gather specs and create documentation for existing and new processes.

Confidential, New York, NY

SQL Developer

Responsibilities:

  • Designed and created databases using normalization techniques. Implemented DDL statements to define database structure or schemas and DML to manage data within schema objects.
  • Developed advanced queries, stored procedures, views and functions to retrieve, analyze and update data using MS SQL Server 2008/2008 R2.
  • Designed, developed and implemented data import using SSIS to load data from various files into database.
  • Created packages and scheduled server jobs according established business rules.
  • Provided administrative functions for SQL Server such as implementing database backups, performance tuning and optimization, importing and exporting database objects. Support of high-transaction database.
  • Designed and implemented security by setting up users, profiles and roles and assigning system and object privileges.
  • Developed analytical and reporting solutions using SSRS. Types of reports included cross-tab, drill down, summary, charts. Reports used parameters, interactive sorting, grouping, system and user functions, custom codes and calculation.
  • Developed Web based applications under IIS and the Microsoft.Net framework using C# programming language with ASP.Net connecting to an SQL database.
  • Prepared and presented status reports to Line of Businesses and Central Technology Senior Management.

Confidential, New York, NY

SQL Developer/Systems Analyst

Responsibilities:

  • Maintained existing MS SQL Server databases and modified database objects: views, USP’s, UDF’s.
  • Managed VBScripts and SSIS. Created and scheduled new SQL Server Agent jobs.
  • Created Crystal Reports using charting, grouping, sorting, alerting, field highlighting, drill-down.
  • Designed documentation and manuals for the process. Provided user support and troubleshoot server related issues.

Confidential, New York, NY

SQL Developer

Responsibilities:

  • Designed, developed and maintained databases in MS SQL Server 2005 relational database: data modeling, indexing, stored procedures, views, user-defined functions, table partitioning.
  • Using Business Intelligence Development Studio with Integration Services and Reporting Services developed and maintained reports and data export/import processes. Created and scheduled SQL Server Jobs .
  • Designed and coded web based applications used by different lines of business using ASP.NET 2.0 and C#.

Confidential, New York, NY

SQL Server/Crystal Reports Developer

Responsibilities:

  • Completed reports through the full live cycle in .NET environment, including requirements gathering, program design, coding, debugging, testing and deployment.
  • Created and responsively handled complex SQL Server queries, stored procedures and .NET data access parameters passing components. Created reports to reflect data on incidents creation through the EMIS application and audit trail incident changes with formatting options such as charting, mapping, grouping, sorting, alerting, field highlighting, drill-down.
  • Modified content and export reports in multiple formats based on user input.

Hire Now