PROFESSIONAL SUMMARY:

• 5+ years of experience in SQL and SQL - BI suite including of SSRS/SSIS/SSAS along with professional database design, development and maintenance of SQL SERVER 2008/2008 R2/ 2012/2014
• Excellent T-SQL Developer skills including Store procedures, Triggers, Tables, User defined Functions, Views, Indexes, SQL joins and Performance based query writing.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, CTE using SQL Servers to facilitate efficient data manipulation and data consistency.
• Expertise in creating and managing Conceptual, Logical, Physical Data Models, database Backup and Restore.
• Expert in High Level Design of SSIS Package for integrating data from heterogeneous sources (Excel, CSV, flat file, Text Format Data) and Data conversion process.
• Experience in creating SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleansed data.
• Involved in Huge data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
• Proficient in creating and designing report layout, sorting the data, defining sub totals using SQL Server Reporting Services (SSRS) 2008,2008R2, 2012
• Experienced in generating various reports like drilldown, Sub reports, Parameterized reports using SSRS and integrated and deployed them on various web applications on to the web browsers.
• Involved in deployment of packages and created job scheduling, alert notifications for errors.
• Involved in Installation, Configuration and Updates of SQL Server.
• Excellent Communication skills, Analytical skills, understand business requirements in various domains.
• Expert in researching, identifying the problem and putting solution together.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experience in writing expressions in SSRS and Created many Drill through and Drill Down reports using SSRS.
• Expert in creating Parameterized Reports.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

APPLICATIONS AND TOOLS:

Language: TSQL, Visual Basics, HTML, XML

RDBMS: MS-SQL Server 2005, 2008, 2008R2, 2012, Microsoft Access, Oracle

ETL Tools: SQL Server Integration Services (SSIS) 2008, 2008R2, 2012

Operating Systems: Windows 7,8,10/Window server 2007/ Windows Server 2008/2008R2/window XP/Vista/

Application Packages: Microsoft Office, Microsoft Outlook, Citrix, Jira

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Data Analyst/SQL Developer

Responsibilities:

• Played a major role in production support of SSIS jobs and other ETL process.
• Optimized SSIS packages and stored procedures that improved the processing time of the heavy ETL process.
• Troubleshooting solution was the daily function on my role in various environments, Development, QA and production.
• Involved in architecting the data flow for the new and existing integration packages.
• Understood the process of every single data flow and created the diagram using Visio for documentation.
• Created normalized Data mart that used for business decision making.
• Normalized the existing complex packages.
• Extract Transform Load (ETL) development using SQL Server 2012 Integration Services (SSIS).
• Fulfilled BA positions by gathering information and explaining technical terms to business partners.
• Created numerous SSIS packages using the Microsoft various tools and task factory.
• Identified data process improvements and leverage technology to automate and streamline existing process.
• Develop queries to retrieve and analyze data from multiple sources in the database.
• Experience in creating parameterized Reports, Sub reports using SQL Server Reporting Services.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Wrote the expressions in SSRS wherever necessary.
• Provided numerous technical solution within the company to avoid manual and lengthy process.
• Created reports with different features like drill through capabilities jump to another report, optional parameter and multiple parameters.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Designed and implemented Parameterized and cascading reports using SSRS 2012.
• Created derived columns on the final fact and dimension tables as per the business requirements.
• Created various shortcuts for the users to manually run SQL agent jobs from their own work station using batch coding.
• Developed many complex queries using stored procedures, CTE, user defined function, views etc.
• Created numerous SQL agent Jobs to run packages and store procedures automatically.
• Developed a template for error logging to use in the SSIS package and the store procedures.
• Created integration to sync SharePoint application with database using Semigo.
• Source to target mapping for various analytical data mart.
• Developed XML files using the SSMS for various application needs.
• Developed many new technologies to adopt the fast paced environment, company grew from four hundred employees to seventeen hundreds within two years.
• Created many backend storages for application developer and provided data to project on the application.
• Data warehouse monitoring on scheduled basis.
• Developed numerous new solution to provide automation to reduce manual process and risk that may cause.

Environment: SQL Server 2012/2014 Enterprise Edition, SQL BI Suite (SSIS, SSRS), VB Script, Enterprise manager, Citrix, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle, Office 365, Citrix

Confidential, Grapevine, TX

SQL/ BI Developer

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data.
• Written complex stored procedure according to the business requirements for reporting purpose.
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States.
• Managed the ETL processes between various environments through SSIS Configuration.
• Identified various data sources and established the connections using SSIS and constructed data source view based on the required reports.
• Worked with various SSIS tasks including execute SQL task, for each loop container, file system tasks
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, CTE's, Triggers etc. according to the requirements.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, and indexes depending on the requirement.
• Developed various types of complex reports like Drill Down, Drill through.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), MS Visual and Windows Server 2008

Confidential, Dallas, Texas

SQL/ETL Developer

Responsibilities:

• Identified and specified complex business requirements and processes.
• Involved in creating Indexes for faster retrieval of data.
• Created SSIS Packages to import and export data from, MS Access, Text Files, CSV files, and Excel Spreadsheets
• Scheduled the reports to run automatically.
• Provided database development support to development team.
• Involved in SSRS report deployment and report server configuration.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
• Produced ad-hoc queries and developed reports to support business needs.
• Performed unit testing of developed solutions.
• Identified the database tables for defining the queries for the reports.
• Supported database administration and participated in special projects related to database administration.
• Developed and maintained SQL scripts in Microsoft SQL Server.
• Designed, developed, tested, tuned, and implemented relational databases and procedural database code.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extensively used T-SQL in constructing User Defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: MS SQL Server 2008 and 2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS, ETL, ODBC, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#. Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, OLTP, Access, Windows 2003 Server, IIS 6.0.