SUMMARY

• Extensive experience with Data Warehousing OLAP applications, Star and Snowflake Schemas designs / implementation. Extensive experience designing ETL for SQL Server Databases using T - SQL and SSIS packages.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Creating DB Diagrams, OLTP and OLAP.
• Extensive experience creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005/2008/2008 R2/2012 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Extensive experience creating jobs and schedule SSIS Packages using SQL Server Agent, Database Mail.
• Extensive experience using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) data.
• Extensive experience with different developer-related phases of project (project requirement and specification, designing system, coding, testing, and debugging new and existing client-server based applications).
• Extensive knowledge of fine tuning/troubleshooting T-SQL (DDL and DML) queries to improve the database performance.
• Extensive experience with advance data manipulating and presentation using SQL Server Reporting Services, based on OLTP and OLAP data sources; Data Grouping with Subtotals, Filtering, Sorting, Drill through Actions, Parameters, Expressions, etc; Reports Rendering for a variety of client-viewing formats.
• Experience using dtutil.exe utility to deploy SSIS Packages between File System and SSIS Store. Experience in running SSIS packages with cmdshell SQL command.
• Proficient in querying Optimization, creating Views, complex Stored Procedures and Functions, appropriate Triggers to facilitate efficient data manipulation, data consistency and complex business logic.
• Created deployment packages with supporting documentation. Installed, tuned and troubleshot SSIS packages.
• Extensive experience with SSRS Report Server manipulation and administration.
• Extensive experience with IBM Cognos Frameworks and Reports development and support.
• Experience building business objects and reports using Oracle Primavera Unifier, BI Publisher and uDesigner.
• Experience managing subscriptions, scheduling and deployment of reports and uploading files to a report server catalog from the report manager.
• Experience using and configuring rs.exe command line utility to deploy Reports and Data Sources to Report Server.
• Experience using Report Builder to create Report Models, deploy and use them for reporting purposes.
• Experience writing MDX queries, creating and customizing Cubes, DSV, Dimensions, Measures, Measure Groups, Aggregations, Perspectives and Hierarchies using SQL Server Analysis Services (SSAS).
• Experience analyzing, designing, developing, troubleshooting and tuning Client/Server, Business Intelligence (BI) OLTP database applications and various segments of SDLC.
• Extensive expertise building and migration of various MS SQL 2000 DTS packages to MS SQL 2005/2008 SSIS.
• Extensive experience creating XML-based and SQL Server-based SSIS packages’ configurations; Logging using text, XML and Windows event log.
• Experience with PostgeSQL database management system and PostGIS extension.
• Familiarity with Denodo and Cassandra databases’ interfaces and data manipulation processes.
• Experience managing Database authentication modes, configuring permissions and assigning roles to user groups and individual users.
• Experience with CA ErWin/Dell Toad logical/physical DB diagrams design, reverse engineering, reports.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2008 R2/2012/2014, MS SQL Server 6.5/7.0/2000 , PostgreSQL 9.X, Oracle, Sybase, MS Access, Denodo, Cassandra

Business Intelligence, ETL, Analytical, Reporting and Data Modeling Tools: MS Visual Studio 2005/2008/2010 , SSIS (Integration Services), SSRS (Reporting Services), SSAS (Analysis Services), IBM Cognos 8.4/10.2 BI Tool (Framework Manager, Report Studio, Query Studio, Cognos Workspace, Cognos Workspace Advanced, Active Reports, etc.), Informatica 9.1 (Data Integration Tool), Talend ETL tool, Tableau 8.2 (Reporting Software), CA ErWin, Dell Toad Data Modeler, Oracle Primavera Unifier, Oracle BI Publisher, Oracle uDesigner, Oracle SQL Developer

Programming Languages, Supporting Tools and Software: ETL, DTS, SQL DDL and DML, T-SQL, MDX (Multidimensional eXpressions Language), VB.Net, CSharp (C#), ASP.Net, Active Server Pages (ASP), XML, HTML, pgAdmin III, MS Visio, TFS (Team Foundation Server), Visual SourceSafe, Perforce, VBScript, Visual Basic, JavaScript, ADO, ODBC, OLE DB, Windows API functions, CSS, Seagate Crystal Reports 4.6-7.0, MS Office (Word/Excel/Outlook/Access/PowerPoint/Publisher), MS SharePoint, GNU Privacy Guard (GnuPG), IIS, WS FTP Pro, CuteFTP, FileZilla, Red Gate SQL Backup, Team Viewer

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Senior Application/Database Developer

Responsibilities:

• Support, installation, configuration and enhancements of SOLIS Intranet application (front-end and back-end) for managing contracts/vendors/tasks/invoices workflows.
• Design ETL process for company client to export data from SQL Server relational database into PostgreSQL Data Warehouse database with PostGIS extension to handle spatial (geographical) data. The ETL is based on SSIS. The data validation module is written using Java.
• For company client created Cognos BI Solution, involving Oracle DW as a Data Source, set of 5 relational and dimensional Frameworks, canned reports and dashboards.
• Wrote numerous SOW, Approach documents, Technical/Functional/ETL/Report Specifications, Project Plans.

Confidential

Senior IBM Cognos Framework/Report/ETL Developer

Responsibilities:

• Designing, developing, deploying and supporting IBM Cognos Frameworks and Reports for several different P&C projects, based on SQL Server Data Warehouse databases.
• Responsible for managing new and existing Cognos connections, user permissions, report formats and delivery methods, etc.
• Designed and developed several SSAS cubes to use as data sources for Cognos Reports.
• Involved in existing Data Warehouse design’s improvements, optimizations and extensions.
• Involved in development/support new/existing ETL processes, based on SSIS and Informatica Data Integration Tool.

Confidential

Data Warehouse/ETL Architect, Tableau Report Developer

Responsibilities:

• Designed, developed, deployed and supported SQL Server Data Warehouse database for analytical and reporting purposes for non-profit organization.
• Designed, developed, deployed and supported ETL to load data into Data Warehouse from PostgreSQL Server.
• Developed custom data verification process applied to the raw data, identifying data issues, fixing them wherever possible and/or moving data into error tables for future analysis. Reported results back to users as a part of email notification in the end of ETL process.
• Based on DW data, created numerous reports, mostly dashboards, in Tableau.
• Based on DW data, created SSAS Cube to analyze data in Excel, as well as for reporting purposes in Tableau.
• Heavily interacted with business users on various data-related issues (meetings, VoIP conferences, presentations).
• Wrote Data Warehouse, ETL, reports technical documentation, user guides, etc.

Confidential

Senior Microsoft BI/Data Warehouse/ETL and IBM Cognos Architect/Developer

Responsibilities:

• Created numerous ETL processes to load large size data files (10-20 Million records) (Excel, comma/pipe-delimited) into Data Warehouse Databases utilizing SSIS. Packages include data transfer using FTP, zipping/un-zipping files, data validation, custom scripting, error handling/logging. The Conventional/Interest-Only/NegAm/Repurchased Home Mortgages-related data has been purchased from third-party information sources (Lewtan, CoreLogic, Economy.com, Neuberger Berman, etc). The data is used to identify Servicer’s performance, defective loans, loan status history, deal/loan/pool/tranche current/historical analysis, historical and projected HPI and Interest Rates, etc.
• Develop, support and enhance complex Intex Claims Processing Solution, combining .Net module to retrieve data from encrypted text files using Intex Wrapper library, SSIS packages to cleanse, massage and prepare the data for reporting needs, Cognos Framework, Congos Reports, Cognos Workspace Dashboard, retrieve loans’ statistics and performance data for business users from Web-based IntexCalc system to support existing data comparison for QA purposes and new data for analysis and future inclusion into existing Solution.
• Converted multiple SSRS and Crystal Reports into IBM Cognos Reports.
• Created, managed and supported IBM Cognos Frameworks for multiple projects and developed multiple Cognos Reports and Dashboards based on them.
• Designed the Data Warehouse DB and ETL process to load Claims status-related review process tracking data, combining Oracle DB, user-provided Excel files and HPI projections SQL Server DB. Same process also extracted and massaged final data for load into OnBase. Developed Cognos Framework and Reports to present loaded data.
• Write deployment scripts/documentation/step-by-step instructions and deployed SSIS packages to DEV/QA/UAT/PROD Servers.
• Create Database Diagrams using CA ErWin.

Confidential

Senior ETL Developer/Data Warehouse Support

Responsibilities:

• Supported ETL process, loading NOOK-related data into DW, while in transition to Aster Data Management System.
• Created numerous reports utilizing SSRS/SSAS/SQL Server 2008 environment. Used both SQL Server and SSAS cube based data sources. Reports identify various aspects of USD/Non-USD MTM/Counterparty Breaks on Derivatives swaps.
• Intensive experience in writing, modifying and extensively optimizing complicated SQL queries, stored procedures, etc. Created numerous SQL DB objects: tables, indexes, triggers, views, functions, etc.
• Actively participated in design and development of in-house Data Warehouse for Trade Reconciliation Processes. Created new/modified existing Data Warehouse objects to provide the most efficient and fast data extraction.
• Loaded data from various data sources into Data Warehouse tables, utilizing SSIS and T-SQL.
• Managed multiple Report Servers. Manipulated with Data Sources, New/Existing Reports, Subscriptions, User Permissions, Linked Reports.

Confidential

BI/Report Developer

Responsibilities:

• Created numerous reports utilizing SSRS/SSAS 2008 environment for company clients, underwriters and auditors. Used both SQL Server and SSAS cube based data sources. Made extensive use of MDX queries and SQL stored procedures with parameters for data manipulation. Created combined Reports (tablix/charts combination, SSAS & SQL data sources). Extensive report rendering to meet user requirements.
• Managed existing Cube, adding new/formatting existing dimensions, creating/managing hierarchies, establishing relationships, creating perspectives, DSV diagrams, etc.
• Participate in testing cube data against third-party QA system, based on MS SQL Server 2008 database.

Confidential

Database Developer/Administrator, SSIS/SSRS Developer

Responsibilities:

• Supported the following company’s clients’ custom-built procurement applications: Verizon, Pfizer, AT&T, Bill and Linda Gates Foundation, Mass Mutual, Teradata, Medtronic, Ingersoll Rand, Lucent.
• Completed the DTS to SSIS packages’ conversion for the most of the company’s client systems (Fortune 100 and Fortune 500 companies). Designed, developed, deployed and supported numerous SSIS packages and online Reports.
• Made extensive use of SQL Server objects (views, stored procedures, triggers and functions) to retrieve, manipulate, convert and temporarily keep the data.
• Made extensive use of Stored Procedures and Views, Variables and Expressions, and Indexes to speed up data upload and transformation. Performed query optimization for efficient execution.
• Designed the standardized folder structure used to install SSIS package.
• Designed, created and managed SSRS reports, using grouping, totals, sub-reports, expressions, adding actions.
• Published reports on a Report Server, created Linked Reports and customized them for different users, managed user rights to access reports, created and managed subscriptions, exp.
• As a member of DBA team designed, created and maintained numerous databases and database objects in numerous OLTP type databases. Performed database backup and restore using Red Gate SQL Backup 5.
• Participated in data loading into Data Warehouse Database using T-SQL and SSIS packages. Based on Business Requirements created several Cubes for company’s Data Warehouse application.