SUMMARY:

• Over 8 years of IT Experience in System Design, Development and Support of Microsoft SQL Server in various domains.
• Over 8 years of ETL experience using SSIS.
• Over 8 years of IT experience in BI reporting and data visualization with SSRS, Crystal Reports and Tableau.
• Over 5 years of experience in designing and developing of Data Warehouses in SQL Server.
• Over 3 years of IT experience in Oracle and PL - SQL programming.
• Over 3 years in Netezza developing.
• Participated in all phases of BI solution development and software development lifecycle.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Understanding of ASP.NET applications and communication processes between database and application layer.
• Experience in Dimensional Modeling, Business Intelligence (BI) and Data Warehousing.
• Development of customized data marts for specific business disciplines.
• Support of production data warehouse and resolve errors in a timely manner in order to minimize service interruptions.
• Experience in MS SQL Server configuration, performance tuning, and query optimization, backup/recovery.
• Proficiency in creating of reports, graphics, charts and dashboards using SSRS, Crystal Reports and Tableau.
• Perform database tuning, instance performance monitoring, schema object management, database capacity planning, backup and recovery strategies.
• Optimization of ETL with proper utilization of multithreading, staging, partitioning and other performance tuning techniques.
• Optimization and performance tuning of SSRS reports by optimizing data source queries, proper parameter usage, visual formatting and other useful techniques.
• Proficient in complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions and Triggers to facilitate efficient data manipulation and data consistency.
• Coordinate testing with other development groups and operations. Identify required level of testing and ensure that testing is complete before singing off.
• Create appropriate technical documentation as required for the project team.
• Participate/assist in production cutover and migration.
• Collaborate with other team members in issue diagnosis, resolution and ongoing application support.
• Quick response to bug fixes and enhancement requests and be able to take directions and complete task on time with minimal supervision.
• Assist business analysts and end users across all functional areas in identifying long-term, strategic data needs for the enterprise and defining how the data is related to the business processes.
• Ability to work efficiently in both Agile and Waterfall environments.
• Ability to work independently or as part of a team to accomplish critical business objectives.
• Very organized, proactive, excellent communication skills and strong attention to detail.

TECHNICAL SKILLS:

Databases: SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005, 2000, Oracle 11g, 10g, Access, Netezza, Shell scripting

Tools: SSMS, Visual Studio, BIDS, SQL Profiler, Power Shell, SQL Developer, Sales Force, People Soft, Tableau, Crystal Reports, TFS, SVN, Jira

Languages: T-SQL, PL-SQL, C#, VB, XML,HTML, CSS, MDX, DAX, Power Shell, Unix/Linux

Applications: Word, Excel, Power Point, Visio, Project, Power Pivot, Power View, Power BI, SharePoint, VMware, etc.

Operating Systems: Windows Server 2012/R2/2008/R2, Windows 10/8/7/Vista/XP, Mac OSX, Linux

WORK EXPERIENCE:

Confidential, Dublin, CA

ETL Developer

Responsibilities:

• Analyze requirements, provide suggestions and improvements.
• Plan, coordinate, develop and support EDW development including architecting table structure, building ETL processes, documentation and long-term preparedness,
• Meet business requirements of the projects as new data sources are added.
• Provide production support of existing ETL processes.
• Document steps needed to migrate database objects between various environments
• Provide regular project updates to management as needed.
• Communicate issues, risks and concerns proactively to management.
• Monitoring and fine tuning databases for optimal performance.
• Providing expertise in devising, negotiating and defining the tables and fields provided in the database.
• Coding, testing, and troubleshooting features and enhancements in the current database environment.
• Assist in the design of user interfaces and business application prototypes.
• Document ETL processes thoroughly to allow other developers to assist with support as needed.

Confidential, San Francisco, CA

Database Developer

Responsibilities:

• Analyze business requirements, create technical and design documents for current development activities.
• Identify, assess and create source to target mappings.
• Define and apply business rules for transformation processes and develop transformation logic for ELT processes.
• Design and develop data transport and population processes for working environment.
• Adapt ELT processes to accommodate changes in source systems and new business requirements.
• Develop and manage BI dependency plan, job scheduling and cycle management.
• Assist in performing system integration testing and user acceptance testing as required by software development lifecycles.
• Interface with DBAs and other development teams to deliver proper results on time.
• Create, classify, monitor and track the defects, verify fixes.
• Propose best practices and solutions to resolve the engineering problems.
• Active participation in all sprint and release related meetings.

Confidential, Sacramento, CA

BI/ETL Developer

Responsibilities:

• Collaborate with business analysts, subject matter experts and other team members to determine data extraction and transformation requirements.
• Perform necessary data mapping and transformation to prepare for validation and loading.
• Validation of complete data delivery by customers and verification of mapping to existing systems.
• Develop and deploy SSIS packages to cleanse and load data to SQL Server and Oracle databases from different source inputs.
• Conversion of DTS packages or complete recreation of DTS to SSIS to synchronize existing data migration processes.
• Building of ETL for data import from People Soft to relational databases.
• Good understanding of source control like TFS for version control, testing and release management.
• Implement data mapping between People Soft and SQL Server and Oracle databases objects.
• Gather user requirements to implement business logic analyze and design database solutions.
• Interact with business users and analysts to document technical and business metadata.
• Performance tune of SSIS packages to improve the overall execution time.
• Generate different types of report as per the cleansed data using different criteria.
• Crystal Reports analysis and conversion of multiple reports to SSRS for different state application.
• Configure the report viewing security for various report users at various level of report manager.
• Write Parameterized Queries and Stored Procedures for generating Tabular and Sub reports using Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS and Report Builder.
• Follow data standards, resolve data issues, complete unit testing and system documentation of ETL processes
• Custom scripting using .net compiled language (C#, VB) to define custom transformational process in SSIS.
• Troubleshoot long-running SQL Queries for maximum efficiency and performance using SQL Profiler, Execution Plan and Database Engine Tuning Advisor.
• Configure the report viewing security for various users at various levels using Report Manager.
• Administer interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Design, develop and maintain data visualizations, dashboards and interactive reports using Tableau Desktop.
• Customize Tableau visualizations and dashboards using expressions, calculations, parameters and other available in-app features.
• Support the development, implementation and daily administration of SQL Server databases; perform database design, modeling and implementation of new database structures, as required.
• Participate in the overall data management strategy.
• Provide support to troubleshoot any issues on existing application system.
• Mentoring BI Developers to improve technical skills and provide guidance for less experiences staff.

Confidential, Harrisburg, PA

BI Developer

Responsibilities:

• Involved in writing T-SQL Programming for implementing Stored Procedures and Functions for different tasks.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Documentation of business rules and existing processes for development activities.
• Developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
• Designed Database, Tables and Views structure for the new data mart.
• Created Tabular reports, Cross Tabs, Drill down, Drill through, Pivot, Charts, Functions and Maps.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Converted existing reports based on Oracle database to SQL Server. Rewrote all oracle based queries and stored procedures for these reports to SQL Server based.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Created ad-hoc queries and reports as requested and provided ongoing analytical support for these requests.
• SSIS scripting using Script Task and Script Component through utilization on .NET code.
• Enable data usage for business users via SSAS cubes by utilizing MDX, DAX, PowerPivot and Sharepoint.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Design, implement and support business intelligence reporting using Tableau.
• Creating data visualizations using multiple data sources to create performant Tableau dashboard.
• Coordinate with customers in order to manage expectations and timelines.
• Optimization and performance tuning of reports by optimizing data in relational source, remodeling data source queries, proper formatting, parameter usage and other useful techniques.
• Configure the report viewing security for various report users at various level of report manager.
• Used customer requirements to improve functionality (speed, performance, usability).

Confidential, Jersey City, New Jersey

ETL Developer

Responsibilities:

• Defined and Designed data based on business requirement and provided documentation.
• Wrote complex store procedures, triggers, views, user defined functions and other objects.
• Trouble shooting errors and changes for application in front end and database in backend process.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Designed and implemented Data Marts, Facts, and Dimensions having Star / Snowflake schemas using Dimensional Modeling principles.
• Build, optimize existing and expand existing cubes to support business reporting needs using SSAS and SSIS
• Created expressions/queries for accessing cubes, involved in query structuring and performance optimization.
• Designed and developed database models, ETL engines and OLAP cubes using BI technologies and concepts.
• Manage and maintain data models, including physical and logical model of data warehouse.
• Created SQL server configurations for SSIS packages.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Produced and documented physical database design using data modeling tools like ERWIN.
• Participation in code reviews and ensure that all solutions are aligned to predefined architectural and requirements specifications.
• Maintained the Enterprise data model repository
• Monitored and analyzed existing application systems.
• Worked closely with the engineering team to develop new tools and methods for data ingest and integration of new systems.
• Support IT staff and business users in the development, usage and troubleshooting of database-driven applications.

Confidential, New York, NY

SQL Server/SSIS Developer

Responsibilities:

• Design, develop and maintain ETL processes using the appropriate data load technique.
• Developed, maintained and administered complex ETL processes using SSIS 2008/R2.
• Debug and tune if developed data integration processes.
• Improved automation of existing processes of SQL using stored procedures and SSIS packages.
• Provided documentation (data mapping, technical specifications, production support, data dictionaries, test cases etc.) for all projects.
• Planned and executed SSIS Package step process to load and validate data and recommending task to resolve performance issue with loading data in to the Data Warehouse.
• Scheduled Jobs for executing the stored SSIS packages developed to update the database on daily basis using SQL Server Agent.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW).
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Create and modify documentation related to integration to ensure that processes are sustainable and repeatable.
• Communicate with project stakeholders to ensure project timeline integrity.