SUMMARY:

• Over 9 years’ experience in Database Design, Development, Architecture and maintenance of database applications on SQL Server 2005/2008/2008 R 2/2012/2014/2016 in OLTP/OLAP/BI environment.
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration.
• Specialized in all aspects of database design and programming with Sybase Adaptive Server Enterprise, Replication server and Sybase IQ Server and Oracle Data modeling, Database design, Transact SQL programming and Open Client programming performance & tuning issues and troubleshooting and security administration
• Long - standing experience with Sybase Adaptive Server enterprise (ASE) covering versions 10.x 11.0, 11.5, 11.9, 12.0, 12.5 and 15.0, starting in 1995.
• Experience with Sybase IQ database 12.0 and 12.5.Experience with Sybase Replication Server 12.0, 12.5 and 12.6. Experience with Open Client versions 10.x, 11.x, 12.0, 12.5 and 15.0 .Proficient in Joins (Inner join, Left Outer, Right Outer Joins, Full join and Cross join) and Indexes.
• Experienced in database design, performance tuning, data modeling & working with databases.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, Compiling and testing.
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services and experience in Importing/Exporting Data from various data sources like Excel, XML And Flat file using SSIS utility.
• Proficient in SQL Server and MySQL Performance tuning and Query Optimization.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Excellent command over design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation like Lookup, Fuzzy Lookup, Script Component, Derived Column, Conditional Split, Union All, Merge Join, Multicast, OLE DB
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data.
• Experience in using SQL Stored Procedures.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance
• Experience in creating and managing fragmentation of Indexes to achieve better query performance, Query ptimization and performance tuning.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries
• Creating and managing roles for security in reports.
• Proficient in creating DTS packages for transferred data modifications.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills as well as flexible to learn advancements in the IT industry.
• Effective management on multiple projects in order to meet deadlines.

TECHNICAL SKILLS:

Database: SQL Server 2010 2012, 2014, 2016 Oracle 10i

Programming Languages: T-SQL, PL/SQL, C, ASP.net, VB.net, C# (.NET), Unix Scripting, VB script, Ruby on Rails

Reporting Tools: SSRS, Crystal Report

ETL Tools: SSIS, DTS, SQL Loader

Application Servers: Internet Information Server (IIS) 5.0, 6.0

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. SQL Server Developer

Job Responsibilities:

• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• ETL/ELT - Plan and execute data migration procedures to move, transform and load data between platforms
• Developed scripts to automate ARC workflows and test the content before it goes into the feed.
• Automate SSIS packages to enable content by network for confidential  etc.
• Overlook the entire confidential workflows on an everyday basis.
• Developing ETL robust processes.
• Managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Develop uniform reporting standards, processes, and documentation to schedule, prioritize, deliver and quality.
• Identify and address expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions.
• Implemented reports from both Bottom-Up and Top-Down (i.e. layout first; data model last) approaches SQL Server Reporting Services (SSRS).
• Knowledge of various relational and non-relational systems (NoSQL - MongoDB, Cassandra).

Confidential, Secaucus, NJ

Sr. SQL Server Developer

Job Responsibilities:

• Re-designing and developing two major legacy systems using bleeding edge Java and open-source technologies.
• Legacy system functionality ported over to the new system and re-designed when necessary.
• Worked on various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, Message Queue Task. Collaborate with Risk Management and Audit departments on quality related tasks such as policy or procedure analysis and redesign, audits, benchmarking and performance standard setting, etc.
• Assist end-users to clearly define reporting needs, identify key performance measures, set benchmarks and design and develop measurement tools and reports. Communicate to ensure that measurement tools, reports and data are understood accurately and consistently across work groups.
• Implemented reports from both Bottom-Up and Top-Down (i.e. layout first; data model last) approaches SQL Server Reporting Services (SSRS).
• Knowledge of various relational and non-relational systems (NoSQL - MongoDB, Cassandra).

Confidential, Ewing, NJ

Sr. SQL Server BI Developer

Job Responsibilities:

• Collect data and produce, troubleshoot and distribute routine reports regarding project operations on a daily, weekly, monthly, quarterly, semi-annual, and annual basis on an aggressive, deadline-oriented schedule.
• Deliver ad hoc reports, as per business needs.
• Extracted data from internal data warehouse system to SSRS
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Understand existing business incorporated in Oracle db and come up with workaround functions in Sybase.
• Interact with back office and make amendments as requested.
• Implemented complex business requirement in backend using efficient T-SQL stored procedures and flexible functions and facilitated easy implementation to the front end application.
• Created and managed schema objects such as tables, views, clusters, indexes, stored procedures and triggers in order to maintain Referential Integrity.
• Extracted data from various data source including OLE DB, Excel, flat files and XML using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, and Merge.
• Experienced in developing ETL packages using SSIS SQL Server Integrated Services. Developed those packages bringing data form various heterogeneous sources like: Oracle, SQL server and OLEDB sources. Also did transformations like Execute SQL Task, Conditional Split, Merge, Lookup, fuzzy Lookup and Slowly Changing Dimension while loading the data into destination.
• Good experience in maintaining batch Logging, Error logging with Event Handlers and configuring connection managers using SSIS. Packages. Plus implemented Checkpoints, Break points to make the packages dynamically work.
• Managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, Message Queue Task. Collaborate with Risk Management and Audit departments on quality related tasks such as policy or procedure analysis and redesign, audits, benchmarking and performance standard setting, etc.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, supported more than 20 client companies' general business reports and benefit plan administration processes.
• Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Employee/benefits census report, Benefits statements report, Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2008/2012.
• Develop uniform reporting standards, processes, and documentation to schedule, prioritize, deliver and quality.
• Identify and address expected and unforeseen data complexities to mitigate their impact on the analytic outcome and associated business decisions.
• Keep abreast of developments within the broad area of IT and look for opportunities to apply them to the company/department goals.
• Perform other duties as assigned by management.

Environment: MS SQL Server 2016, MS Access, VBA, SQL Server Integration Services SQL Server Reporting Services, Business Intelligence Development Studio (BIDS),, T-SQL, Power BI.

Confidential, Moorestown, NJ

Sr. SQL Server BI Developer

Job Responsibilities:

• Working on Database Load Performance, Database Mirroring for environments which includes data for more than 2 set of environments of 1 TB.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Translated Business Requirements into working Logical and Physical Data Models.
• Expertise in troubleshooting ETL packages by implementing SSIS functionalities, like: breakpoints, checkpoints and event handler.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Expertise in troubleshooting ETL packages by implementing SSIS functionalities, like: breakpoints, checkpoints and event handler.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Tune ETL procedures and STAR schemas to optimize load and query Performance.
• Prepare all ETL processes according to business requirements and in corporate all business requirements into all design specifications.
• Experienced in using SSIS catalog, File System SQL Server deployment process to deploy ETL packages.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Implemented Custom Logging, Auditing and custom Email notifications using SSIS.
• Expert in creating Star schema cubes using SSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Prepared visible columns and formulas; imported data from SAP and exported data for metrics.
• Designed, created, and maintained DB2 database objects
• Managed database growth and performance with database reorgs
• Audited application SQL code with DB2 Explain prior to production implementation
• Assisted developers in database and application tuning for optimal performance
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Environment: MS SQL Server 2014 /2012/2008 R2, SQL Server Integration Services (SSIS 2014/ 2012/2008 ), SQL Server Reporting Services (SSRS 2014/2012/2008 ), Business Intelligence Development Studio (BIDS), MS Excel 2003/2007, T-SQL, Power BI.

Confidential, New York, NY

SQL Server BI Developer

Job Responsibilities:

• Developed and configured applications for Data Obfuscation in confidential for more than 100 applications with data ranging more than 1 TB.
• Managed projects from operations as well as development group based on business needs and priorities.
• Implemented DB2 Version 6 Query CP parallelism to support COGEN/MP property and casualty system from CSC.
• Installed, implemented, and trained staff in the use of Platinum DB2 tools, Candle Monitor for DB2, and DB2 tuning techniques.
• Supported team members in pricing module development of fixed income products using Excel and VBA.
• Worked on the 3NF tables in the OLTP system and denormalized to load the data into facts and dimensions.
• Used Powershell for coding and running scripts.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Created Time Dimensions on OLAP Cubes using SSAS.
• Created and Maintained Logical Data Model (LDM) for the project. Includes documentation of all Entities, Attributes, Data Relationships, Primary and Foreign key Structures, Allowed Values, Codes, Business Rules, Glossary Terms, etc.
• Generated snapshot report at the end of data obfuscation for each application for the purpose of validation of the different tables in the schema.
• Worked on different SQL queries to check the record count in source and destination, before and after Data Obfuscation.
• Administration of Sybase and Oracle environments.
• Create, modify and test the snapshot reports for auto validation.
• Worked on numerous NTPA and Asset Servicing Applications.

Environment: MS-SQL Server 2012/2008R2 Enterprise Manager, TOAD, MS Business intelligence 2008 R2 (BIDS) SSIS, SSRS,SSAS, SharePoint Server 2010, XML, T-SQL.

Confidential, Boston, MA

SQL Server BI Developer

Job Responsibilities:

• Developed SSIS Packages for running the different claims.
• Generated automated passwords for sending email to the different clients.
• Responsible for auto- generation of different user ids for the users.
• Created the Conceptual Model for the Data Warehouse using Erwin Data Modeling tool.
• Reviewed the Conceptual EDW (Enterprise Data Warehouse) Data Model with Business Users, App Dev. and Information Architects to make sure all the requirements are fully covered.
• Created Logical & Physical Data Modes using Entity Relationship Diagrams.
• Designed the physical data models using data provisioning and consumption techniques in Oracle environment.
• Maintain accurate records of client interactions.
• Responsible for creating complex Cross tab, OLAP Cube report using Crystal Reports integrated with SSMS.
• Designed Report Templates, Bar Graphs and Pie Charts in Crystal Reports for data analysis.
• Configured OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions to business.
• Used several OBIEE reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, Security etc.)
• Worked on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements
• Involved in development of the application by determining standard procedures to execute from the users end.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Send notifications and data via email to the different users.
• Worked with project sponsors and team leaders to prioritize existing and new issues based on the size of the impact on process efficiency, data quality, the Project timeline, and the organization’s ability to affect change.
• Testing the emails sent to the different users using the application.
• Responsible for dealing with the end users for any production support issues.
• Provide technical support to end users.
• Strong in SQL, scripting, and understanding of how web access to SQL needs be configured.

Environment: MS SQL Server 2014, MS Visual Studio 2012, MS Outlook, MS SharePoint, T-SQL, C- Sharp

Confidential, Minneapolis, MN

BI Developer

Job Responsibilities:

• Developed scripts for building stored procedures in SQL
• Modified procedures to check them back into TFS
• Responsible for the creation of the applications by using vb.net and enhancement of the projects for .net applications
• Responsible for the automation and the development of the business environment
• Managed XML scripts to build codes for SSIS packages
• Data analysis and reconciliation
• Write Stored Procedures, Views and Functions to support reports
• Develop and customize reports to support the hedge fund of funds business
• Worked to improve the performance and migrate the existing database application
• Used .NET to develop the codes and migrate to production
• Developed advanced workflow - based on event notification applications using the SSRS to notify subscribers via email
• Administration of Microsoft SQL Server Database environment
• Delivered package enhancements for the promotion to UAT.
• Performing testing tasks with a minimum of oversight and direction.
• Responsible for transferring the data using SSIS packages.
• Worked in support of a custom .NET development environment.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Worked with the production and data warehouse teams.
• Created indexes, constraints and rules on database objects.
• Knowledge of data warehousing concepts.

Environment: MS SQL Server 2005, MS SQ­­L Server 2008, C-Sharp, MS Visual Studio 2005, Unix, Oracle, MS Visual Studio 2008, T-SQL.

Confidential, Hartford, CT

SQL Server Developer

Responsibilities:

• Worked on the database to build the reports using SSRS 2008.
• Created the data sources to get the required data.
• Generated data sets from the stored procedures created using SQL Server 2008 R2.
• Built stored procedures for the balanced and control reports required for product design.
• Partnered with CPAs, attorneys, and other professionals to provide comprehensive analysis for businesses on all lines of insurance from employee benefits to business policies.
• Developed and implemented cost reductions strategies on healthcare renewals and other employee benefit packages.
• Assessed client risk exposure and recommended corresponding solutions to optimally meet client needs and objectives.
• Created and initiated local marketing programs resulting in over 30 new accounts.
• Worked as a data architect for the BI environment.
• Developed complex stored procedures for ETL.
• Loaded data from heterogeneous sources using various tasks and transformations in SSIS.
• Created jobs to automate and schedule data loading, backup, reporting with SQL Server agent.
• Worked with 64 bit Windows OS.

Environment: SQL Server 2008, C-Sharp, SSAS 2008, SSRS 2008, MS Outlook 2010, T-SQL.