SUMMARY:

• Over 9 years of real time experience in Data Modeling, Data Mart development & maintenance of Data Warehouse which includes ETL, OLAP Cubes, applying Data Mining algorithms, writing Transact SQL, and designing SSRS Reports.
• Hands on experience in creating end to end ETL strategies that will include data profiling as well as Extracting, transforming, Conforming and Loading data warehouse/data marts for reporting purpose.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate, Script, and Derived Column Transformation.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Event Handlers, Breakpoints, and loggings (SSIS or Custom loggings) and Securing Packages.
• Expertise in developing and maintaining Relational and Multidimensional Database Schemas.
• Worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflakes Schema
• Good SQL Server Administration skills including Backup, Recovery, Database Maintenance, User Authorizations database, tables, and indexes creation.
• Experience in performing Integrity Checks, troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace Statistics and Index Tuning Wizard.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Very good experience on RDBMS Concepts, writing Stored Procedures, Views, Triggers, Functions and extensive usage of SQL commands.
• Expertise in Front and Back End Web Development.
• Good understanding of Object - Oriented Programming Concepts, Client/Server Architecture, Online and offline processors.
• Strong technical and intra-personnel skills.
• Real time experience working directly with the clients from requirement gathering to implementation of custom data warehouse suite.
• Very good experience in Analyzing Business & System Requirement specifications and involved in designing, and developing the core components of DW Application
• Self-learner team & result oriented and able to work independently as well as in team.
• Proactive in interacting and collaborating with Business Analysts, Technical Analysts, and other team members to identify and understand the appropriate business requirements and providing solutions.
• Accommodate 100% of travel if needed.

TECHNICAL SKILLS:

Programming Languages:: C, C++, C#, Java, VB, VBA, Perl, and PHP

Database Management:: Microsoft SQL Server 2014/2012/20, Oracle 8i/9i/10i, MySQL, MS Access, T-SQL/ PLSQL.

Web Programming:: Bootstrap, JavaScript, VBScript, ASP, JSP, HTML, DHTML, CSS, and XML.

Internet Tools:: Share Point, Office MS-Front Page, Macromedia 6(Flash, Fireworks, Dreamweaver), Internet Information Server (IIS), CSS, FTP, TCP/IP, LAN, VPN, Remote Desktop Access, NetMeeting, MS-Outlook.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Collabera Senior Consultant | MS SQL/SSIS Developer

• Enterprise Data and Application Integration Projects
• Development, maintenance and support of vendor integrations including but not limited to Property Management (MRI), Financial (Workday), CRM (Dynamics 365) and Enterprise Data Warehouse (EDW) systems.
• Technical Issue resolution
• Adherence to industry standards and best practices for ETL Development, Data Quality and Data Governance
• Incremental load with use of SSIS, Temporal Table and Redgate Compare
• Used T-SQL to create: Stored procedures, Triggers, Views, Functions
• Development, Execution and recording of Unit testing and rest results
• Adherence to the RCS CHEF methodology

Confidential, Columbia, South Carolina

Revenue Premier Data Warehouse

Responsibilities:

• Gathering Business Requirements directly from business users
• Analyzing and documenting different system flows, process flows and work flow
• Participate and/or facilitate production assurance testing and end user acceptance testing
• Assist in implementation and production support activities
• Architect complex solutions manage development and collaborate with testing teams
• Support technology to enable integrated reporting of the Risk landscape
• Persuade and influence stakeholders in other areas and occasional external parties through developed communication and negotiation skills
• Provide in-depth and sophisticated analysis with interpretive thinking to define problems and develop innovative solutions.
• Building ETLs using SSIS packages to load data from various data sources including data from internal and external sources.
• Converting all Embarcadero legacy ETLs to SSIS packages. Historically, the Data Warehouse team has used the proprietary ETL tool Embarcadero DT/Studio tool.
• Used various Package Configurations available for SSIS Packages like XML files and SQL Server Tables.
• Implemented the Master Child Package Technique to manage Big ETL (SSIS) Project efficiently.
• Automated the ETL process by scheduling SSIS package job execution.
• Developed multiple SSIS C sharp shared functions that I deployed in the global assembly Cache (GAC) to be executed by any SSIS script task transformer. For example: convert signed money, name parse...etc.
• Created SSAS cubes to facilitate the reporting of the business based on historical and current data.
• Created cubes based on the reporting and application requirement of the business users.
• Creating deployment methodology concepts including design, build, testing, and deployment.
• Full development life cycle around real-time integration with SSIS, SSAS, SSRS and SQL Server.
• Changed daily Refresh Java code to execute and check the status of SSIS packages (instead of embarcadero).
• Create and Document Logical Data Integration (ETL) Strategies for Data Flows between disparate Source/ Target Systems and the Enterprise Data Warehouse.
• Created Parameter-drive Reports using parameters tab in the SSRS GUI procedures by setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them in the data field
• Created ad-hoc reports using power pivot and performance point extracting data from heterogeneous sources.
• Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, identifying and adding the report parameters.
• Experience weighing the tradeoffs between bulk inserts and single updates in database and ETL processes for speed optimization.
• Performed a variety of Data Analysis, Data Modeling and Data Administration tasks with limited supervision.
• Interacted with business users to plan, develop, improve, and maintain complex components of the Logical/ Physical Enterprise Data Warehouse and related Models.
• Maintained and Administered Meta-Data Repository.
• Conducted quality assurance for loaded data.
• Created and executed Views, Triggers, Stored procedures, functions as required.
• Established, Maintained and Adhered to Enterprise Data Modeling and Data Integration Standards.
• Worked closely with users to understand and help develop functional specifications.
• Setting up and running the proprietary Portfolio Warehouse Associate and Grow (A&G) offline process. This includes configuring the A&G match keys with consultation from the business users and SCDOR Data Warehouse team.
• Developed and presented training materials as needed to clarify model meaning and usage.
• Provided functional advice or training and served as a mentor to less experienced Data Warehouse Analysts.

Confidential, Atlanta, GA

Discover Tax Data Warehouse

Responsibilities included:

• Developed, tested, migrated, and implemented various Extract Transform and Load of data tasks processes using SSIS
• Optimizes packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source
• Responsible for data analysis, data designing, data mapping, data quality business and Minimum Data requirement (MDR) gathering, Technical Specification writing.
• Redesigned and developed data warehouse refresh process.
• Developed a comprehensive unit and system testing plans for data in the warehouse.
• Reviewed and tested the work products produced by either clients or RSI team members and provided feedback/comments on any data quality issues.
• Analyzed complex problems and, either independently or working with others, developed elegant and practical solutions. Made sound decisions and used good judgment.
• Be open to new concepts and incorporate these ideas to improve the solution.
• Effectively identified and used best practices.
• Identified potential issues and brought them to management's attention appropriately and followed through with issue tracking and resolution.
• Analyzed development and installation of IT systems including documenting system requirements, preparing technical program specifications, and writing user manuals.
• Completed the compliance program, including the Functional Design Specifications, Test Results, and implemented Production Solution deliverables.

Confidential, New York, NY

Asset Financial Staffing Consultant |SQL developer

Responsibilities included:

• Create ER diagram and performed normalization on them to ensure faster querying
• Developed ad hoc reports for tax consultants.
• Used DTS to extract and transform and load data coming from excel and the mainframe to the SQL server database.
• Scheduled dashboard to run after loading tax exposed account.
• Optimized database by using SQL profiler and the SQL indexing wizard
• Wrote Views that helped see transactions in a filtered way
• Developed Stored procedures that calculated total cash depending on tax and interest rate
• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using Transact- SQL, SQL Analyzer and Enterprise Manager.
• Used SQL profiler trace to determine tuning performance of Stored Procedures, Triggers and Views and User Defined Functions.
• Used SQL wizard index to determine the best way to index a table for fast query performance.