Objective

To obtain a position as a SSIS ETL Developer, SSRS Report Developer, BI/SSAS Developer, Microsoft SQL Server Developer, DTS to SSIS Conversion Specialist, IBM Cognos Framework/Report Developer, BI/DW/ETL Architect, SSRS/Cognos/Crystal Reports Conversion Specialist

Databases

• MS SQL Server 2005/2008/2008R2/2012, MS SQL Server 6.5/7.0/2000, Oracle, Sybase, MS Access, MS FoxPro.
• Programming Languages, Reporting and Supporting Tools and Software
• MS Visual Studio 2005/2008, SSIS Integration Services, SSRS Reporting Services, SSAS Analysis Services, ETL, DTS, SQL DDL and DML, MDX Multidimensional eXpressions Language, T - SQL, IBM Cognos 8.4/10.2 BI Tool Framework Manager, Report Studio, Cognos Workspace, Cognos Workspace Advanced, etc., VB.Net, CSharp C, ASP.Net, Active Server Pages ASP, XML, HTML, CSS, TFS Team Foundation Server, Visual SourceSafe, Perforce, VBScript, Visual Basic, JavaScript, IIS, ErWin, ADO, ODBC, Windows API functions, Seagate Crystal Reports 4.6-7.0, MS SharePoint, MS Office Word/Excel/Outlook/Access, GNU Privacy Guard GnuPG, WS FTP Pro, CuteFTP, FileZilla, Red Gate SQL Backup

Professional Summary

• Extensive experience with Data Warehousing OLAP applications, Star and Snowflake Schemas designs/implementation. Extensive experience Loading Data ETL into 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, OLAP.
• Extensive experience creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005/2008 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.
• Created scheduled Jobs to run the SSIS packages.
• Extensive experience with Report Server development and administration.
• Experience with IBM Cognos Framework and Report development and support.
• 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 2005/2008.
• 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 SSIS.
• Extensive experience creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Experience creation of Database authentication modes, configuring permissions and assigning roles to user groups and individual users.
• Experience with ErWin logical/physical DB diagrams design, reverse engineering, reports.
• Experience using Windiff for files comparison.

confidential

Senior BI/SQL/Data Warehouse Developer, IBM Cognos Report Developer

• 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, 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.
• Created, modified and supported multiple SSRS Reports while in transition to IBS Cognos BI Environment.
• 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.
• Write deployment scripts/documentation/step-by-step instructions and deployed SSIS packages to DEV/QA/UAT/PROD Servers.
• Create Database Diagrams using ErWin.
• Utilized MS SQL Server 2008/2008R2, MS Visual Studio 2008, SSIS/SSRS, T-SQL, DDL, DML, Oracle, VB.NET, C, ErWin, FileZilla, SourceSafe

confidential

Senior ETL Developer/Support

• Supported current daily ETL data warehouse process while in transition to Aster Data Management System.
• Utilized MS SQL Server 2008, MS Visual Studio 2008, SSIS, T-SQL, C, bcp, CuteFTP

confidential

Senior BI/SQL Report Developer

• 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.
• Utilized MS SQL Server 2008, MS Visual Studio 2008, SSAS/SSRS/SSIS, MDX, T-SQL, VB.NET

confidential

BI/Report Developer

• 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.
• Utilized MS SQL Server 2008, MS Visual Studio 2008, SSAS/SSRS, MDX, SQL, VB.NET

confidential

Database Developer/Administrator, SSIS/SSRS Developer

• Supported the following company's cliens' custom procurement applications: Verizon, Pfizer, AT T, Bill Gates Foundation, Mass Mutual, Teradata, Medtronic.
• Completed the conversion for most of the company's client systems Fortune 100 and Fortune 500 companies from DTS packages to SSIS. 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 numerous reports within SSRS, 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.

confidential

• Completed numerous large scale projects involving the development and customization of the company's client systems.
• Optimized the hiring process and timecard/expense preparation of the company's client systems for the contract workers' management process.
• Moved code and data between Development, QA, Pre-production and Production environments.
• Utilized ASP, Visual Basic 6.0, JavaScript, MS SQL Server 2000/2005, COM/DCOM, DTS, FileUp Component, Artisan Email Component, PC Anywhere, bcp

confidential

Database Administrator/Developer

• Designed, created and maintained: 1 MS SQL Server Databases for company's clients/projects 2 DB objects tables, stored procedures, views, triggers, database schemas, etc. 3 DTS packages 4 ad-hoc reports 5 SQL Server Jobs to run DTS packages and ad-hoc reports.
• Managed Users Accounts on Server and Database Levels.
• Managed SQL Server Database backup and restore procedures.
• Designed and developed the process for data exchange between MS SQL Server DB and Canto Cumulus 5 for the project
• Developed various managing tools for the site content.
• Wrote ASP/SQL code for new and existing parts of the site. Provided maintenance and support.
• Created COM components.
• Developed the mechanism of generating XML files based on data from SQL tables
• Implemented XML files as a part of HTML/ASP informative screens as XML data islands with the ability to navigate between records.
• Wrote XML schema files.
• Developed a process that allowed XML files to be generated based on user input and then passed to COM component for parsing and storing in SQL Server tables.
• Developed the SQL Server data to XML file converting system for a publishing company. The system populates data from SQL Server tables according to user-selected criteria and converts it into an XML file and then sends the file via the Internet to a remote server.
• Created a VB application that lets users create the list of products desired using extensive set of criteria and then creates flat files for uploading to several main Internet search engines such as Yahoo, Excite, AOL Search.
• Utilized ASP, HTML, JavaScript, Visual Basic 6.0, ADO, MS SQL Server 7.0, XML, bcp, COM/DCOM, MTS

confidential

Practice Support System Analyst

• Designed and developed Temporary Stuff Time Tracking System, Clients Living Wills Managing System, Estates Payments Managing System, ImageBase Dynamic Report Generator, ImageBase Login System, Inventory Tracking System, etc. All of these systems included GUI, data exchange between Sybase DB and MS Access DB, importing/exporting data from/to Excel/CSV files, etc.
• Utilized Visual Basic 6.0, Sybase System 11, MS Access 97, ADO, DAO, Active Reports, API functions

confidential

Access/Excel Programmer

• Designed and developed the data repository system to analyze and compare incoming data and produce various reports for Latin American analysts' team. Generated ad-hoc Excel Reports on request.
• Utilized Visual Basic 5.0, Access 97, Windows API functions, Crystal Reports 5.0, MS Excel 97