PROFESSIONAL SUMMARY:

• Highly motivated IT Professional with 5+ years of experience using SQL Server Programming
• Having worked thoroughly in MS - BI development tools such as T-SQL (SSMS), SQL Server integration (SSIS), Reporting (SSRS) services. These where implemented using Microsoft SQL Server 2008 R2 and 2012 platforms in development, testing & production environments
• Well versed with T-SQL and database development tasks
• Created unique and complex solutions with the optimization of Stored Procedures, Triggers, Views, Joins, Indexes, and Tables for various applications
• Created SQL queries to retrieve complex data from different tables in various databases using database links, joins, and formatted the results into different reports
• Created and optimized stored procedures to create Clustered and Non-Clustered Indexes for Query Performance
• Gather business requirements from end users, executive management, and clients.
• Prepared and presented analytical data, KPI’s, and recommendations.
• Used complex stored procedures and input/output parameterized reports
• Developed many detailed charts and matrices to show detailed visuals of data that was provided
• Experienced in Designing Customized Interactive Dashboards in SSRS using drill down, Drill Through and variables
• Wrote highly complex formulas in SSRS reporting services to query database and generate different types of reports (Drill downs, Drill Through, Linked, Parameterized, and Subreports) for Business Intelligence
• Performance tuning of slowly running reports
• Deployment of SSRS reports using Native mode and Share-point Integration
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Hands on within SSIS using Data transformation to create complex packages consist of transformations like Conditional Split, For Each Loop, Multi-Cast, Sort Component, Data Conversion, Script Components, Merge Join, Lookups, Row Count
• Used many different control flow items constantly such as Execute SQL Task for incorporating set updates and deletes, also execute task for parallel package execution
• Scheduling Jobs automating ETL process I created logging, communicating users via email notification using SSIS email tasks about data loads/package failures
• Experienced in de-bugging failed SSIS packages using checkpoints/breakpoints
• Reliable knowledge and experience with creating Jobs, Alerts, SQL Mail Agent

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

SSIS/SSRS Analyst

Responsibilites

• Helped Develop BRD’s in order to help the development know what the business needs to track company risk.
• Worked with cross functional teams to collect requirements, analyze, and identify critical metrics and KPIs and design BI or Reporting solutions to meet business needs.
• Used SSIS to migrate raw data from many sources including Excel, Sharepoint, Access,etc.
• Created tables and views to manipulate the data from the System of Record.
• Used SSRS to develop a view (Matrices, Charts, Graphs) to explain to the business whats is happening in particular metrics.
• Developed and loaded Sharepoint views for other teams as called upon for business needs/priority
• Used Tableau to check track of what is happening within the business on daily basis.

Confidential, Downer Grove, IL

SQL Database Developer

Responsibilites

• Creation of new databases to preserve legacy data when upgrading from SQL Server 2005 to SQL server 2012
• Creating views and tables for data when in a testing environment to gauge performance cost when being promoted to Production environment
• Built complex stored procedures to be used store legacy data and to be executed hourly to handle just the present day data that is new
• Spoke with Manager to gather the business requirements for any new processes.
• Used ddl and dml commands when querying T-sql statements.
• Used SDLC process to be able to have matching data in different environments such as Development, Test/QA, and Production.
• Ability to report any necessary changes to manager regarding changes in code based on performance time.

Confidential, Chicago, IL

SQL developer, Technical services

Responsibilities:

• Data mining to understand and solve root causes for issues within databases
• Scrub incoming property tax data from different counties to make sure data is ready for the next step in the process.
• Created tables, views, and cleanup scripts to be used recursive specifically for counties.
• Served as backup to the help desk team to solve one off tickets that were being pulled from zendesk.

Confidential, Irving, TX

SQL/SSIS Developer, Technical Services

Responsibilites

• Used stand-alone platform for ETL processes
• Built data conduits and Data requests with table definitions and key requirements.
• Created complex SQL queries and stored procedures within SSMS to validate data for imports, data failures and warnings.
• Ability to talk to client to help them understand and potential compliance risks and penalties under the ACA
• Handled confidential employer data pertain their tax information.

Confidential, Irving, TX

Data Integration Specialist/SQL Developer

Responsibilities:

• Excelled in a fast paced healthcare (ACA) environment responsible for making sure new enrollment were properly put into system correctly
• Responsible for using/developing Stored Procedures to update table with the system.
• Created/Updated/Assigned tickets for company use to be split workload across team.
• Used temp tables to be able to edit table in testing environment to make sure it was up to business requirements before updated within the production.
• Worked as relay between businesses to understand what company needed/wanted data to be viewed.
• Used analytical skills to optimized stored procedures in order to make production more efficient.

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Installation of SQL Server 2012/2008 Enterprise edition and enabling SSIS/SSRS on Analytical Development server
• Created logical and physical database design, data structures, primary key, foreign key and implemented large databases
• Created and managed structured objects like tables, views, stored procedures, views and triggers all while maintaining Referential Integrity
• Built high performance data integration solutions, including extraction, transformation, and load (ETL) packages and scheduled packages and jobs
• Extracted data from SSMS tables, Excel Files, Flat file docs using SSIS source components
• Standardization and cleansing of data (Transformation) in the ETL process
• Utilized slowly changing dimension wizard to keep track of updates within the tables
• Created SSIS Packages to load each dimensions, Fact tables, Then Configuring packages using XML, SQL Server, Parent package variable methods
• Involved in extracting the data using SSIS from OLTP to OLAP
• Responsible for ongoing maintenance to existing reports and optimized report performance within SSRS
• Discussed new data feeds with business managers and understood how they need data to be reported
• Deployed and uploaded the reports to SharePoint Server for the end user and involved in making modifications

Environment: Windows server 2008, MS Excel 2010, SQL Server 2012/2008 R2 SSIS/SSRS/SSAS Enterprise edition

Confidential, Grapevine, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations
• Involved in transferring databases from SQL Server 2008 R2, and SQL Server 2012
• Coordinated with the front-end for implementing logic in Stored Procedures and User Defined Functions (UDF)
• Designed Dashboards to show inventory/sales in hourly, daily, weekly, etc. operations
• Created automated T-SQL scripts to process database transaction that run off-hours
• Scheduled stored procedures for end of day operations using SQL Server Agent
• Used SSIS to transform and load data into SQL database via FTP from XML and Excel files as Source data
• Designed package using many transformations to load data into Data Warehouse from various source files
• Worked with tabular, matrix, gauges & chart reports, drill down reports as well as interactive reports according to business requirements.
• Created ad-hoc reports for unit team lead as requested and provide on-going analytical support for these requests.

Environment: SQL Server 2012/2008 R2 SSIS/SSRS Enterprise edition BIDS, SSMS