We provide IT Staff Augmentation Services!

Bi Resume

Philadelphia, PA


PROFESSIONAL SUMMARY:

  • Over 8 years of IT experience in all the aspects of Software Development Life Cycle (SDLC) which includes Analysis, Design, Development, Testing of applications using Data Warehousing concepts and Business Intelligence tools.
  • Working experience with MS SQL Server (2008/2005/2000/7.0) and Visual Studio (2008/2005/2003) used to generate reports, integration, developing custom utilities and applications using .NET.
  • Extensive experience developing and implementing Microsoft SQL Server integration services (SSIS), Reporting Services (SSRS), Anaysis Services (SSAS) and MDX for data warehousing and data mart solutions.
  • Created packages using SQL Server Integration Services (SSIS) for data Extraction from/Load to Flat Files, Excel File MS Access, DB2, Oracle etc.
  • Creating and monitoring the batch jobs using SQL Server Agent and third part tools like Global Event Control Scheduler (GECS) etc.
  • Extensive Experience with IBI tools Webfocus 7.6.X/7.5.X used to develop and maintain reports using Developer Studio and IWAY an XML based tool to perform the ETL operations and running SSIS packages on demand setting the IWAY Listener.
  • Created reports, graphs under both MRE (Managed Reporting Environment) as Dashboard reports and under SELFSERV providing report as url accessing from .NET and other third party applications.
  • Created adhoc, drilldown, drillthrough, tabular, excel etc reports using SQL pass through keeping the complexity in SQL Server stored procedures improving the performance and even developed SSRS reports using these procs.
  • Scheduled jobs to run the reports on a specified date time and distribution of information to users using Report Caster.
  • Created Master File, Access File, Business Views for the reporting, isolating from the database avoiding changes unless it is needed for the reports.
  • Used XML configuration files mapping through environment variables to test and run the SSIS packages manually in the case of job failure.
  • Worked on SQL Server Reporting Services (SSRS), Crystal Reports and developed reports depending on the needs and the scope of the application.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and migration. Also used OLAP in Webfocus and created reports for the users.
  • Experience with design of datawarehouse and datamarts using Bill Inman and Ralph Kimball methodologies based on the organization.
  • Experience with design and implementation of Star Schema and Snowflake Schema Dimensional model.
  • Experience in RDBMS database and tables design Normalization, De Normalization, Clustered, Non clustered, Unique, primary, foreign keys and Indexes.
  • Extensive experience with T-SQL in writing and debugging complex stored procedures, triggers, table views and user-defined functions.
  • Working experience with ASP .NET and C# and its integration with Webfocus Reporting and SQL Server Reporting Services.
  • Connecting to database using ADO.NET and data retrieval using Dataset and Data reader. Also using LINQ and AJAX in the new frameworks.
  • Development of Interoperable WebServices, Winforms, Console Applications using C# and VB. Net.
  • Well versed with IIS, registry, assembly configuration. Used Powershell script to register .net assembly in GAC.
  • Experience with Test and debugging Webfocus reports using Dialog manager commands and also running the TRACE to identify the issue.
  • Also has experience in MS SQL Server configuration, performance tuning (using Sql profiler and tuning advisor) client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
  • Delivered 24/7 support including scheduled and emergency night and weekend work.
  • Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.

Technical Skills:


Databases:

MS SQL Server 2008/05/00/7, Oracle 10g/9i/8i, DB2, Access

ETL Tools:

SSIS, DTS, I way

Reporting Tools:

IBI Webfocus 7.6.x/7.5.x, SSRS, Crystal Reports X1/X.

Languages:

C, C++, C#, LINQ, Visual Basic, Focus

.NET Technologies:

Web Forms, ASP.NET, ADO.NET, .Net 3.5/3.0/2.0/1.1, Web Services

Web Servers:

Microsoft IIS., Apache Tomcat 5.5.25, SharePoint

Scripting Languages:

JavaScript, JQuery, AJAX, HTML, XML, XSD, CSS, T-SQL

Methodologies/Tools:

UML, MS Visio

IDEs/CMS/Tools:

MS Visual SourceSafe VSS, TFS, Visual Studio 2008/05/03

Operating Systems:

Windows 2000/2003 Server, Windows XP

PROFESSIONAL EXPERIENCE:
Client: Confidential,Philadelphia, PA. May 09 - Present
Role: Sr. BI Developer
Responsibilities:

  • Analyze Design, Development and Testing of applications using MS SQL Server and Visual Studio.
  • Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
  • Understand the functional requirement specifications and preparing design documentation.
  • Installed, configured and maintained SQL Server Integration Services (SSIS).
  • Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, DB2, Oracle etc.
  • Created new SSIS packages for the existing legacy DTS packages in the due course of data migration from SQL Server 2000 to 2005.
  • Scheduled and monitored the execution of the jobs using a third party tool Global Event Control Server (GECS) and SQL Server Agent.
  • Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.
  • Implemented SQL Server SSIS packages for ETL methodologies involved in the migration from SQL Server 2000 to 2005 and 2008 and created new SSIS packages for the legacy DTS packages and scheduled and monitored the execution of the jobs.
  • Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and multi-dimensional reports.
  • Migrated some of the SSRS reports from 2005 to 2008 environment.
  • Supporting Business Intelligence efforts and created ad hoc Reports, Graphs, Dashboards under both DATASERV and MRE using Webfocus Development Studio.
  • Made extensive use of Focus coding in generating and styling the Reports using Text Editor and free-hand SQL Queries using SQL Editor.
  • Migrated some of the existing legacy Webfocus (.FEX files) reports to SSRS (.RDL files) and enhancing them when required improving the performance and look of the reports.
  • Involved in migration of Webfocus from 7.6.4 to 7.6.10 version and worked with IBI in resolving a couple of issues.
  • Supported Style Sheets that contain drill down parameters and links to arbitrary URLs and embedded GIF images in report headings and footings.
  • Created Standard Reports and Report objects under the dashboard.
  • Used Change Management Train to move the code from one environment to other.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and used MDX script for querying the data.
  • Developed Business views, Report objects, Cubes for the users to analyze the data and help them in decision making.
  • Deployed SSRS reports to Report Manager and made a call to those reports through a URL from Webfocus dashboard (.html) and from .Net API (.aspx).
  • Developed reports using SSRS and exported directly to EXCEL, CSV and PDF formats bypassing the report manager screen running the reports from ASP.NET application.
  • Performing Unit testing and internal QA for the developed application.
  • Involved in Performance Tuning of SSIS Packages, reports, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.
  • Created and maintained the SSRS reports, design documents and other scrum status trackers available on SharePoint for the business users and the steering team.
  • Communicate with project managers as to the progress of open items and work with other developers.
  • Working closely with the users supporting the existing reports and creating new reports.

Environment: MS SQL Server 2008/2005/2000, SSIS, SSRS, SSAS, IBI Webfocus 7.6.4/7.6.10, DB2, MS Access, SQL *Plus, ASP.NET, C#.NET, ADO.NET, Windows XP, .NET Framework 3.5/3.0,Visual Studio 2008/2005, HTML, JavaScript, AJAX, LINQ.

Client: Confidential,New Jersey, NJ. Sep 08 – Apr 09
Role: Sr. SQL Server Developer
Responsibilities:

  • Documented and delivered functional specification document to the project team.
  • ETL (Extract Transform and Load) data by developing SQL Server Integration Services (SSIS) packages.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
  • Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files Oracle, Access, DB2 etc.
  • Worked using XML configuration files mapping through environment variables to test and run the SSIS packages manually in the case of job failure.
  • Migrated Data from SQL server 2000 to SQL Server 2005 using SSIS and converted some of the old dts packages to ssis packages.
  • Developed reports using SQL Server Reporting Services (SSRS).
  • Designed the User Interface (UI) using HTML javscript, Ajax, web interface of the application using ASP.Net and code behind in C# and integrated the Reporting Services (SSRS) reports to these applications.
  • Built and Deployed reports to the Report Manager from Visual Studio and generating output directly to PDF or Excel format from an URL.
  • Sorted and aggregated source data to build the answer set and also generated report statistics in order to avoid unnecessary load on the reporting server.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Responsible for database design, including optimizing the database schema and coding database procedures/queries.
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Designing and building data load procedures using MS SQL Server.
  • Configured product meta-data tables to support client data reporting needs.
  • Worked on large number of business analytical functions.
  • Incremental and full database recovery with experience of complex recovery scenarios.
  • Working with Different methods of taking Database Backup and Recovery procedures.
  • Design and development of classes using C#.NET, ADO.NET, XML for database connectivity.
  • Provided production support monitoring overnight processes and fixing them upon failure.


Environment: Webfocus 7.6.2, MS SQL Server 2005/2000, SSIS, SSRS, SSAS, Oracle 10g,DB2, Sybase, Active X, ASP.NET, C#.NET, Visual Studio 2005, XML, Microsoft Source safe, Windows XP/2003

Client: Confidential,Chicago, IL Nov 07 – Sep 08
Role: .Net/SQL Developer
Responsibilities:

  • Worked in a busy environment on multiple projects. There being a release every month.
  • Designed interactive web pages in ASP.NET and user controls using C#. The pages are developed using dynamic controls with java scripting.
  • Implemented validation controls and set up the roles and responsibilities to a privilege table avoiding hard coding and complexity.
  • Written business rules and resolved some of the issues faced by the Analysts.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Governed and maintained performance and analysis portfolio of SQL Server Reporting Services report.
  • Defined parameters to SSRS in C#.NET to run dynamically at runtime.
  • Assigned reports using C#.NET to the web application to the end users.
  • Developed, prepared unit test documents for all SSRS reports.
  • Developed several stored procedures to handle large amount of data manipulation.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Implemented data cleansing, data standardization.
  • Created SSIS Packages for populating the data into dimension tables and fact tables.
  • Implemented different partition techniques for parallel loading process.
  • Involved in Performance Tuning of SSIS Packages, reports, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.
  • Defined production support document with recovery process.
  • Implemented SQL Server OLAP services (SSAS) for building the data cubes.
  • Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
  • Designed relational Database and Datawarehouse Databases.
  • Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
  • Created SQL scripts for data load into tables getting customer data from different servers and databases.
  • Created user defined functions, Stored procedures, views and triggers in Sql Server 2005.
  • Worked on LDAP connectivity using C# to retrieve the contact information.
  • Worked on SSIS creating dtspackages, scheduling and monitoring jobs.
  • Used ADO.NET Dataset and Datareader for loading and retrieval of customer information.
  • Provided production support, addressed issues and provided maintenance for the projects.

Environment: Webfocus 7.5.6 ASP.NET, C#.NET, ADO.NET, MS SQL Server 2000/2005, SSIS, SSRS, Windows XP, Visual Studio 2003/2005, .NET Framework 2.0/1.1.

Client: Confidential,TX. Dec 06 - Oct 07
Role: .Net/SQL Server Developer
Responsibilities:

  • Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.
  • Developed interface pages using HTML, Javascript facilitating the user to pass parameters into the report.
  • Design/Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse and claim systems.
  • Worked on Stored Procedures and Database Triggers.
  • Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
  • Worked Extensively with SSIS to import, export and transform the data between the linked servers.
  • Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Created databases and specified automatic growth options.
  • Design and development of classes using C#.NET, ADO.NET, XML for database connectivity.
  • Responsible for data transfer and replication over internet between the offshore development site and onsite implementation site.
  • Created named backup devices to backup the server regularly.
  • Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
  • Designing and building data load procedures.
  • Generated database SQL scripts and deployed databases including installation and configuration.
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Fine-tuned the logic in stored procedures, Functions and Triggers for optimum performance.
  • Used Microsoft Source Safe for version control and configuration management.
  • Provided 24/7 support to all production, development, staging and clustered servers.

Environment: Webfocus 7.5.2, SQL Server 2000/2005, SSIS, SSRS, SSAS, Visual Studio 2003/2005, Visual Basic 6.0, DTS, T-SQL, Oracle 9i,Active X, C# .NET , ADO.NET, XML, Windows XP/2003

Client: Confidential,NJ. Apr 06 - Nov 06
Role: .Net/SQL Server Developer
Responsibilities:

  • Extensively worked on various financial products like equities, funds, fund of funds, derivatives, bonds, treasuries, notes, warrants, currency contracts, futures, options etc.
  • Interacted with the end users and business analysts to transform business specifications into technical requirements.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
  • Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives
  • Frequent teleconferencing and e-mail communication with business leads from across the globe to understand business rules and data structure.
  • Creating tables, relationships, triggers and indexes for enforcing business rules.
  • Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
  • Gathered detailed business and functional requirement for equity systems.
  • Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.
  • Configured product meta-data tables to support client data reporting needs.
  • Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
  • Written complex SQL statements using joins, sub queries and correlated sub queries.
  • Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
  • Created SQL reports, data extraction and data loading scripts for different databases and schemas.
  • Copied production SQL Server 7.0 databases to test server running Windows 2000 Advanced Server and SQL Server 2000
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.

Environment: Microsoft SQL Server 2000, Visual Studio 2003, Transact-SQL , Active X, .NET, ASP, MS-Excel, Oracle 9i, Windows 2000.

Company: Confidential,India Apr 04 - Feb 06

Role: SQL Server Developer
Responsibilities:

  • Involved in designing of Conceptual Logical Model and Physical Model.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.

  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
  • Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 7.0, Oracle 8i, Windows NT, C++, HTML, T-SQL, PL/SQL, SQL*Loader.

Education: Bachelor of Technology

Hire Now