SUMMARY:

• Results oriented SQL Developer with proven track record of implementing enterprise wide software development projects. A Professional with extensive experience and insight of business, technology and the knowhow of implementation processes which combine technology and business to enhance the vision of the organization. Sound management and communication skills to handle multiple projects at intra organization levels as well as inter organization levels.
• Over 6+ years of IT experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse.
• Business/Data Analyst with experience in all phases of the Project Development Life Cycle: Planning, Analysis, Requirements Management, Reporting, Testing and implementation of projects.
• Generating Complex Transact SQL (T - SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the Stored Procedures, User-defined Functions and Views.
• Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, Efficient coding standards.
• Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2005/2008R2/2012.
• Proficient in developing complex SQL queries for reporting needs.
• Implemented Report Subscriptions and scheduled them to run on specific day and time and send to the top-level management using email subscriptions.
• Used Parameters in the Reports such as Cascading Parameters, Multivalve Parameters, Queried and Non-Queried Parameters (Date Time) etc.
• Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS).
• Extensively used Execute SQL task, Bulk Insert Task, Data Flow Task, Look up, Union All etc in the SSIS Packages.
• Expertise in working under Agile Methodology.
• Experience in authoring Business Requirement Documents (BRD), Data Mapping documents and Functional Design documents by gathering Business and Technical Requirements and Expectations from Subject Matter Experts (SMEs) and defining business processes, identifying risks, performing Feasibility Analysis and Impact analysis.
• Proficient in preparing Business and System Use Cases and supporting all the documents for Business process flows, data Mapping and UML Diagrams such as Use Case Diagrams, Class Diagrams, Activity Diagrams, Data Flow Diagrams, Sequence Diagrams, Process Flows (Business and System) using UML modeling tools such as MS Visio and Rational Rose.
• Extensive experience developing source to target data mappings, business rules and data definitions with strong understanding of Data Governance principles.
• Strong working experience in data quality assurance processes and procedures.
• Extensive experience writing the User stories, Acceptance Criteria, Flow diagrams and exposure to TDD (Test Driven Development)
• Proficient in performing Gap Analysis, by evaluating the key differences between the As-Is and the To-Be system and identifying the key requirements for system reengineering
• Excellent analytical and inter-personal skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Operating systems: Windows XP/2000/2003/NT 4.0/9x/Vista and MS-DOS

Programming Languages: SQL, T-SQL, PL/SQL Dynamic SQL, XML, Visual Studio, ActiveX, MS Access, Lotus notes.

RDBMS: Microsoft SQL Server 2012/2008R 2/2005/2000/7.0 , MS-Access 97/2000/2003 , Oracle 10g

Data warehousing: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS). Business Intelligence Development Studio (BIDS), SSMS, DTS Packages.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0

Business Intelligence Tools: Business Intelligence Development Studio (BIDS), Visual Studio, Tableau 10.1

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Informatica Power Center, Tableau Desktop, Tableau Server, Salesforce

Packages: MS Office, MS Outlook (Microsoft Office Suite), Microsoft Office SharePoint Server, Salesforce

Version Control and Configurations: Visual SourceSafe, Visual Studio Team Foundation Server.

PROFESSIONAL EXPERIENCE:

Confidential, FL

SQL Developer

Responsibilities:

• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Gathered requirements from business users as a part of loan submissions to government portal and handled technical specifications.
• Written complex T-SQL queries in the stored procedures, functions and triggers.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler/Query Analyzer/SSMS.
• Designed and implemented report layouts according to reporting standards of the department.
• Created SSRS reports involving tabular, matrix, drill through and drill down reports in Business Intelligence Development Studio.
• Created linked reports in report server and subscriptions to deliver the reports through email and file server.
• Hands on experience in Team Foundation server for logging all the SSRS reports, stored procedures and SSIS packages as a source control.
• Designed SSIS packages, configuration files, tables, views, and functions; and implemented best practices to maintain optimal performance.
• Created Package Configurations, Event Handlers for On Error, On Warning, and On Task Failed Event Types.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL Table and log files.
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.

Environment: SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS), Tableau, Power BI, SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows 7, SharePoint, VB Script.

Confidential, Dallas, TX

SQL Developer/Data Analyst

Responsibilities:

• Worked closely with the senior management to understand the business needs, to drive the requirements for migrating data out of legacy SQL databases to newly implemented Oracle databases.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Perform and document root-cause analysis of data quality issues and recommend changes.
• Performed Data Analysis, Data Integrity and Data validation tests by writing SQL queries and responsible for downstream impact to the data warehouse.
• Create data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations rules required, data definitions and business rules to be applied.
• Develop views, functions, stored procedures, and packages using PL/SQL & T-SQL to transform data between source staging area to target staging area.
• Uses data analysis techniques to validate business rules and identify low quality missing data in the existing data warehouse. Responsible for documenting and reporting data quality goals and standards.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables.
• Documented data quality, traceability documents and also responsible for defining the Functional Specifications Documents (FSD ) for each source to target interface.
• Designed and implemented report layouts according to reporting standards of the department.
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Worked with Technical Experts to Improve Report Performance and performed System testing.

Environment: SQL Server 2008R2/2012, Visual Studio 2008, SSRS, SSIS, MS Office 2007, MS Office 2010, Oracle 10g, MS Access, Tableau, SQL Server Analysis Services (SSAS 2008), Visual Studio Team Foundation Server (VSTFS), MS Excel, MS Outlook 2007, Erwin, Crystal Reports, PowerPoint 2007, SharePoint.

Confidential

SQL Developer

Responsibilities:

• Created Stored Procedures, User Defined Functions, Views and Implemented the Error handling in the Stored Procedures and SQL Objects and also Modified already existing stored procedures, views, indexes depending on the requirement.
• Used various report items like Tablix, Sub reports, Images, Charts to develop the reports in SSRS.
• Implemented technical features such as hyperlink reports, parameterized reports, sub reports etc.
• Implemented Report Subscriptions and scheduled them to run on specific day and time and send to the top-level management using email subscriptions.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions. Developed data mapping documents between Legacy, Production, and User Interface Systems and Source to Target Mapping documents for multiple subject area with all the transformation rules.
• Extensively used SQL to create ad-hoc reporting, data analysis and manipulating database systems.
• Design, develop, test, and maintain data visualizations from a wide variety of data sources to understand historical trends across core KPIs as defined by the business.
• Perform ongoing data mining of data across all Direct Capital platforms.
• Work closely with the reporting team to support the design, development, and QA of Tableau Reports and Dashboards, while working with the business to understand requirements and assist with the roll out of new and enhanced reports.
• Developed complex queries to retrieve data from multiple sources, charts, tables and crosstabs using SQL Queries.
• Created reports for executives to show quality and quantitative trends to define key metrics.
• Responsible for loading production scrubbed data into multiple DEV/QA environments.
• Designed the Structure of Staging Database and Staging Tables used in the ETL Process to dump data into a common Staging.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables.
• Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS).
• Performed User Acceptance Testing (UAT), Unit Testing and Documentation.

Environment: SQL Server 2008R2, Visual Studio 2008, Microsoft CRM4M, SalesForce.com, Reporting Services (SSRS 2008), Integration Services (SSIS 2008), MS Office 2007, MS Office 2010, MS Access, MS Visio 2003, Windows XP, Tableau, SQL Server Analysis Services (SSAS 2008), ETL, MDX, Performance Point Server 2007, Visual Studio Team Foundation Server (VSTFS), MS Excel.