Database Developer Lead Resume
Tampa, FL
SUMMARY
- Around 11 years of IT experience with expertise in MS SQL Server 2005/2008/2012 suite of products like SSIS, SSAS, SSRS and SQL Server Data tools.
- Experience in programming languages using .Net, C# .Net, ASP.Net, ADO.Net, MVC, AJAX and XML.
- Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
- Experience in Data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
- Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
- Extensive experience in working with T - SQL queries (DDL and DML) and writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
- Experienced on Extraction, Transformation and Loading (ETL) process using DTS and MS SSIS application tools.
- Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
- Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Involved in Analyzing, MSAS Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services (SSAS).
- Experience in using tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
- Performed installation of SQL Server (to include clustered environment) and applied required patches to development, staging and tan to production systems after thorough testing.
- Ensured teh integrity and security of data from unauthorized individuals and also performed recovery of lost or corrupt data.
- Proactively monitored database systems to ensure secure services with minimum downtime.
- Extensive experience with Database Backups, Restoration & Disaster Recovery Procedures, Backup strategies and scheduling Backups.
- Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
- Experienced in migrating Crystal Reports into SSRS Reports.
- Experience and Expert in Generating on-demand and Scheduled Reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
- Experience on Policy-Based Management on SQL servers which includes four major steps those are Selecting Facets, Setting Conditions, Creating, evaluating Policies and Executing teh Policy
- Experience in following domains: Health Care, Pharmaceutical Supply Chain, Investment/Banking, Health Insurance, Financial and Telecommunication.
- Excellent team player with good organizational, communication, interpersonal & analytical skills. Possess strong ability to quickly adapt to new applications requirements, processes, platforms and languages.
TECHNICAL SKILLS
Databases: SQL Server 2005/2008/2010/2012/2016 , Oracle 9i
Languages: C, C++, T-SQL, PL/SQL, ASP.NET, Visual Basic 6.0, VB.Net.
Scripting Languages: HTML, VBScript
Operating Systems: Windows Server 2003, Windows XP.
Tools: Visual studio 2016/2012/2010/2008 , Erwin 4.0/3.5, IIS, SAP BO Data Integrator XIR 2/11.7/11.5.
Reporting: SSRS (MS SQL Reporting Service), Crystal Reports XI, Excel
PROFESSIONAL EXPERIENCE
Confidential, Tampa,FL
Database developer Lead
Responsibilities:
- Developed enhancements to enterprise financial planning Web-based .NET applications like asp.net,c#.net.
- Working with SQL queries (DDL and DML) and writing complex stored procedures, Indexed views and triggers for data consistency and manipulation.
- Performance Tune teh Stored Procedures, User Defined Functions and long running queries.
- Analyzed teh data to implement incremental load.
- Worked on OLAP Dataware house model,Design and implementation.
- Involved in migration of large amount of data from OLTP to OLAP using ETL packages.
- Designed packages in SSIS 2012 with various complex transformations such as derived column,conditional split,lookup,aggregation,execute SQL task.
- Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner
- Good understanding and experience inSQL 2012 new features likeChange Data Capture CDC, Transparent Data Encryption TDEand Policy based Management.
- Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
- Developed, deployed, and monitored SSIS Packages.
- Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2012/2008.
- Worked on different reorg jobs for cleaning up data using purge conditions to clean for every 18 months.
- PerformedSQL and PL/SQL tuningand Application tuning using various tools likeExplain Plan, Sql Trace, andAutotrace.
- Performed operations like Datareconciliation, validation and error handling after Extracting data into SQL Server.
- Good knowledge in data warehouse(star and snow flake schema), fact table, cubes, dimensions, measures usingSQL Server Analysis Services.
- Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
- Used XML to create Web-based tools for transactions on SQL and Oracle databases.
- Developed WinForms user interface projects with initial layout and base controls.
- Troubleshot and resolved bugs in .NET applications to ensure optimal development environment.
- Developed in java development environment to use SQL Server Databases as backend database
- Worked on IBM Db2 quries for creating reports using java appliactions as backend and created Cr report store procedure to drive teh data using metadata for all teh reports .
- Worked on different tables like standard cash and custom cash with account tables .
- Worked on different extracts for different clients to feed data and generated different reports like weekly, monthly which shows projections, holiding data and tax reclaims.
- Generated different kinds of standard reports which is available to all clients and entitled reports that only visible if a user is entitled to them and private reports made specifically for and available to certain clients
- Developed different kinds of reports like transactions like securities and cash history, sk settled transactions and sk unsettled transactions, cash balances,cash projections,cash transactions,paid income,projected income, market claim reports
- Worked on settled positions reports which displays an account statements that shows teh settled quantity of any traded position and dis traded quantiy of position viewed by using drill down feature or by cutomizig teh report to display teh traded quantiy on teh summary page.
- Worked on positon and pending reports which displays current settled and traded positions for a specific security where there are unsettled pending trades
- Worked on available position reports which displays all available positions that have not settled.
- Worked on Traded and Settled Positions Detail report is a statement of holdings that displays teh quantity of a specific position in an account. dis report shows teh traded quantity, teh settled quantity, and teh local market value of teh position.It also shows a ledger balance as of a specific date.
- Created Fixed Income Analytics Daily Summary report provides a daily analytic summaryon portfolios of Fixed Income securities, it represents bond data and related portfolio calculations such as duration, average life, average maturity, etc for US Safekeeping Accounts
- Worked on different cash transactions reports display a summary of all cash related transactions posted to an account for a specific date range.
- Worked on teh income reports to displayall income account statements in relation to cash holdings.
- Worked on Projected Incomereportdisplaysincome in relation to a holding that is expected to be paid/received in teh future.
- Worked on teh market claim report displays all claims that have been made whether paid or notassociated with teh contractually entitled party that TEMPhas not received teh underlying securities at close of business on record date.
- Used Team foundation server (TFS) for version control for teh store procedures, tables, indexes for different environments like SIT/UAT and Prod .
- Worked agresssively on release management from starting change ticket creations and approvals with different teams like cab teams, developer, qa teams and deploying databases and in and out of release using udeploy versions of java appliactions and sql versions and start and stop of autosys jobs.
Confidential, Lakeland, FL
Database developer Lead
Responsibilities:
- Wrote complex T-SQL queries, stored procedures, and Views
- Created different types of store procedures for revisions, remodel and new store data of teh Confidential
- Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
- Created ETL controller process for controlling teh monthly and daily process of loading by using ssis packages and configuration tables
- Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
- Designed Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load.
- Developed on SSRS extensively to create and design reports.
- Developed with Report Builder to build Ad-hoc Reports.
- Developed on SSRS extensively to create and design reports.
- Developed with Report Builder to build Ad-hoc Reports.
- Created various kinds for reports like drill down, drill through using visual studio 2012/2015 .
- Revision reports, new store reports, remodel reports, submittals reports and landmark reports
- Performance Tune teh Stored Procedures, User Defined Functions and long running queries.
- Used Team foundation server (TFS) for storing teh store procedures, tables, indexes from development environment and used that for deploying into test and production environment.
- Created Maintenance Plans to do Backups, and setup log files to monitor jobs.
- Developed UI/Components/Classes/Methods/Functions for teh application and also Functionalities such as Data retrieval using disconnected record sets, using ADO.NET / ASP.NET / Windows Forms / Web Forms / Server controls.
- Developed in ASP.NET /C# application development environment to use SQL Server Databases as backend database
- Used SQL Server Reporting services for creating, editing and scheduling various reports by using data driven subscriptions and SQL Server Agent
Confidential, Tampa, FL
Database developer Lead
Responsibilities:
- Involved in teh complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
- Involved in analyzing different modules of facets system and EDI interfaces to understand teh source system and source data.
- Developed ssis migration from oracle data base to sql server database
- Developed with data analyst and data modeler to design teh complete data warehouse Schema using Erwin with proper relationships defined.
- Developed with data analyst to figure out teh business logic that needs to be implemented in teh warehouse day-to-day load.
- Profiled data from teh source, and transformed teh data to meet teh user’s requirement.
- Designed and developed teh Staging Database and loaded from source to staging and from staging to teh Destination tables applying different transformations.
- Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatics Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle and SQL Server Databases.
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in teh Informatics Designer Used different sources like DB2, Mainframes and Flat Files to Extract Data.
- Extensively Developed on Stored Procedures, Functions in T-SQL.
- Used sysdts log table and configuration files in teh packages.
- Used Tabular and Matrix Reports Layout to design reports, based on teh requirement.
- Created Dashboards and KPI’s using SSRS.
- Developed on SSRS extensively to create and design reports.
- Developed with Report Builder to build Ad-hoc Reports.
- Used complex expressions to calculate, group, filter, parameterize, and format teh contents of a report.
- Used SQL Profiler to trace Performance of Queries and to index teh Tables..
- Experience in resolving on-going maintenance issues and bug fixes; monitoring sessions as well as performance tuning of mappings and sessions.
- Developed extensively on teh Query studio and canned reports to carry out teh UAT.
- Successfully did teh GO-Live for loading of teh CVS data of 10 million records into teh Facets.
- Developed on teh ETL documentation for teh packages.
- Experience with Tivoli job scheduling
- Attended functional testing and user acceptance sessions and Developed on teh feedback provided by them.
Confidential, Horsham, PA
SQL/ETL Developer
Responsibilities:
- Developed on SSIS migration packages for loading orcs(checks data) and claims daily and monthly data into teh database by using various transformations
- Involved in loading bulk data from CDW tables and files data into teh ocrs bill line history fact tables by using store procedures
- Created linkage process by linking teh claims data to teh premium tables for pulling teh data for Various columns like service from date, servicecerteffectivedate, genederid,Premiumdueageid, planbenmodskey .
- Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update teh tables. Created Backend validations using Insert/Update and Delete triggers.
- Wrote complex T-SQL queries, stored procedures, and Views.
- Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
- Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data, and Garbage and Unnecessary Data like removing empty rows.
- Performed various SSIS tasks such as Conditional Split, Derived Column on teh data retrieved, performed Data Validation Checks during Staging, and tan loaded teh data into teh Data warehouse.
- Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
- Created ETL controller process for controlling teh monthly and daily process of loading by using ssis packages and configuration tables
- Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and change Data Capture.
- Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting.
- Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
- Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
- Created various kinds of reports like Parameterized reports, drill down, drill through and sub reports for monthly and quarterly sales of claims data reports using SSRS and Tableau, Qlickview
Confidential, Daytona Beach, FL
ETL Developer Lead
Responsibilities:
- Will responsible for developing tools for reporting tool in support of Enterprise Data warehouse.
- Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
- Experience in converting SQL 2005 SSIS packages to 2012 SSIS
- Experience in writing script tasks using C# in ssis packges
- Responsible for designing and implementing SSRS Reports(SQL Server Reporting services)
- Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
- Created views and Stored Procedures for generating report. Responsible for creating teh reports based on teh requirements using SSRS 2010/2012. Extensively Developed in sorting teh data, defining subtotals for teh reports
- Performance Tune teh Stored Procedures, User Defined Functions and long running queries
- Wrote complex SQL queries, stored procedures, triggers, cursors and user-defined functions.
- Transferred teh MS Excel Sheet Reports into SSRS based reports by migration teh data by using SSIS packages and tan Use views and tables and stored procedures to develop new reports.
- Created Excel for generating reports to state of Florida format using macro in excel by writing VBScript code.
- Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in teh extracted data and rebuilding teh relationship.
- Created Parameterized reports, Linked reports, Snapshot reports, Cached reports, Ad hoc reports, drilldown reports, Drill through reports and sub reports
- Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet reporting needs.
- Used Team foundation server (TFS) for storing teh store procedures, tables, indexes from development environment and used that for deploying into test and production environment.
- Performed SAP Data Migration by using Business Objects Data Services as teh ETL tool
- Experience with Tivoli job scheduling
- Experience in using ServiceNow database and execute that report in real time.
Confidential, Jackonsville,FL
SQL/ETL Developer
Responsibilities:
- Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
- Merged Data from Heterogeneous Data stores and Legacy System implementing SSIS on teh System.
- Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
- Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
- Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions.
- Participated in to Design ETL architecture and processes for near real time loads of insurance and policies related record from different locations. Successfully met challenges of very high volume (over Three million rows a day), dependency on multiple source data feeds, short ETL time windows..
- Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve teh problems.
- Migrated and Converted Crystal Reports into SQL Server Reporting Services (SSRS) by using MS SQL Server Reporting Services.
- Experienced into Tested, Cleaned and Standardized Data meeting teh business standards using Fuzzy /exact lookups.
- Optimized teh performance of queries by Data Manipulations which includes modifications in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
- Installed and configured SQL Server 2005, SQL Server Integration Services and SQL Server Reporting Services which were highly efficient to Monitor teh Central console and SQL server Instances and detecting problems before effecting transaction of Online users.
- Deployed SSIS and SSRS, which halped connect its data sources that range from legacy mainframe data to multiple clusters of database server in different format.
- Interviewed Clients and management to identify additional reporting needs Develop report requirements and specifications to meet reporting needs.
Confidential, Seattle,WA
Database Developer
Responsibilities:
- Installed and Configured Confidential SQL Server 2005/2008 and Confidential CRM
- Developed on cross platforms like SAS (Statistical Analysis System) to SQL server, Transformed teh SAS Macros to SSIS.
- Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources and converted SAS environment to SQL Server.
- Developed in transferring teh data using SQL Server Integration Services packages Extensively used SSIS Import/Export Wizard for performing teh ETL operations
- Utilized Integration Services (SSIS) to produce a Data Mart for reporting.
- Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
- Expertise in creating Property Expressions, Script Tasks for SSIS packages
- Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated Services
- Implemented SSIS data, created maintenance procedures and provided data integrity
- Implemented Snow Flakes Schema and Star Schema
- Developed with Development teams in relation to application tuning and Performance tuning
- Involved in teh Database design (Logical Data Modeling and Physical Data Modeling) of teh system and Developed with tools like ER Studio 8.5
- Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
- Created views and Stored Procedures for generating report. Responsible for creating teh reports based on teh requirements using SSRS 2005. Extensively Developed in sorting teh data, defining subtotals for teh reports
- Delivered teh reports using ‘pulled’ and ‘pushed’ methodologies and formatted teh reports using teh Global variables and expressions.
Confidential, Los Angeles, CA
SQL Server Developer
Responsibilities:
- Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
- Created SSIS packages to export data from Oracle to SQL Server Database.
- Rectifying and performance tune teh diamond data feed process. Debug, Performance tune and enable teh DTS packages for error logging. After tuning teh DTS packages now take minutes rather than hours load teh same amount of data.
- Backing up system & other databases and restoring them as per requirements.
- Developing, deploying reports using SSRS.
- Applying various release from time to time.
- Performance Tune teh Stored Procedures, User Defined Functions and long running queries.
- Used SQL Server Reporting services for creating, editing and scheduling various reports performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
- Configure Permission for teh Distribution Agent and created subscription.
- Monitored teh Publication and Subscription and Verified that Changes at teh Publisher are replicated to teh Subscriber.
- Prepared documentation for teh SQL Server 2005 Replication.
- Created backups and restore of database and schedule to run.
