OBJECTIVE

• Detail - oriented, organized and efficient SQL BI Developer seeking a position to utilize my knowledge and experience in a position offering opportunities for personal contribution and professional growth.

SUMMARY

• Over 5+ years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2012/2008R 2/2008/2005/2000
• Experience of the entire Software Development Life Cycle (SDLC), IT systems and processes, methodologies, etc.
• Knowledge and experience in dealing with Constraints, Querying, Joins, Keys, Indexes
• Experience in T-SQL queries, clustered and non-clustered Index, ETL, Data Cleansing and Data Migration
• Extensive experience in Microsoft stacks of BI solutions - SSRS, SSIS with MS SQL 2012/2008R 2/2008/2005/2000
• Experience in SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications
• Created SSIS package configurations using XML configuration, SQL Server, parent package variable, registry entry and environment variable
• Deployed the SQL Server 2005/2008/2008 R2/2012 SSIS packages
• Experience in building/migration of various DTS packages using MSDB, File system, File system storage methods
• Scheduled SQL Server 2005/2008/2008 R2/2012 SSIS packages using SQL Server Agent
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, etc.
• Created Sub, Linked, Ad-hoc and Map reports (by territory, by country, by state), Charts in SQL Server 2008/2008 R2
• Configured, administered Report Manager and created item level securities, group permissions in SQL Server Reporting services
• Scheduled Daily, Weekly & Monthly reports on sales & marketing information based on business needs using SQL Server Reporting services (SSRS)
• Proficient in design ofETLandSSISPackagesfor integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text, XML, Access, Oracle, DB2, SQL) bySSISsuch asAggregate,Data Conversion,Conditional Split,Bulk Insert,Fuzzy Grouping, Fuzzy Lookup andMerge)
• Knowledge in designing OLAP (Online Analytical Processing), OLTP (Online Transaction Processing) systems
• Experience in creating Packages, scheduling Jobs and sending Alerts using DB Mail
• Created Documentation, ER Diagrams using MS Visio and Erwin for ER modeling

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Develop technical design specifications and code specifications to meet business requirements/specifications.
• Interacted with Business Owners to understand the requirements & expectations through JAD and brainstorming sessions.
• Created database objects like Tables, Views, Indexes and Stored Procedures.
• Created Entity Relationship (ER) diagrams based on requirements.
• Created SSIS Packages to migrate database to Text files and developed SSIS packages for File Transfer using FTP task.
• Scheduled the SSIS package services to run at different intervals to fetch and transfer data into other database.
• Worked on SSRS reports to report the Daily, Weekly and Monthly Statistics of various service providers.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Involved in creation of various dashboard used for reporting to the end user.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Generated the drilldown, drill through and linked reports using the SSRS.
• Used Red Gate tools such as Data Compare, SQL Compare to keep the objects and Data in sync in various Environments.
• Transferred Data to data warehouse and exported files in various formats based on requirements using SSIS Packages.
• Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
• Create the necessary indexes to improve the query performance using SQL Server Query Analyzer.
• Gathered Analyzed and made available Patients Information to the appropriate authority.
• Verified entered Patients Insurance Information by reviewing, correcting, deleting, or reentering data.
• Generated reports, store completed work in designated locations and performed backup operations

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Maintained customer confidence and protects operations by keeping information confidential
• Applied data program techniques and procedures Created database objects like Tables, Views, Indexes and Stored Procedures.
• Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
• Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
• Database Administrative skills including, backups, recovery, database maintenance.
• Maintained customer confidence and protects operations by keeping information confidential information confidential Generated reports, store completed work in designated locations and performed backup operations
• Kept information confidential Analyzed source system data to determine the data model and ETL solution that will meet business requirements.
• Formulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.
• Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, for loop and for Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Created scripts for massaging, scrubbing and cleansing of legacy data in staging area.
• Knowledge in C# script component in SSIS packages.
• Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
• Created, Process, Partitioned the cubes using SSAS.
• Created various Stored Procedures to validate the data from the source and update/insert the records into target tables.
• Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.

Confidential

SQL BI Developer

Responsibilities:

• Have developed and maintained T-SQL Stored Procedures, Data Models with Primary Keys and Unique Keys according to the business requirements.
• Implemented complex SQL queries using joins, CTE’s, and T-SQL Stored Procedures with Parameters.
• Define reporting needs and implement Power Pivot/ Power Viewreports to satisfy needs
• Implemented company custom logging to enforce SSIS Package integrity for auditing purpose.
• Created packages using Integration Services (SSIS) for extracting data from XML, Excel files, OLEDB to SQLServer staging tables before loading into final destination.
• Responsible for loading the data using SSISpackages to fact and dimensional tables.
• Used SSISto create ETL packages to validate, extract, transform and load data to data warehouse databases, DataMart databases.
• Identified and defined the datasets for the report generation.
• Developed complex Stored Procedures and views to generate various reports using slicers and line graphs.
• Created Business Requirement Document based on the needs of the end users after one on one interviews and project meetings.
• Hosted several meeting with end users to create user stories and BRD
• Ability to communicate with Supervisors, Executives, BA’s, DBA’s,Developers
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• CreatedSSISpackages from an XML source combined with left joins stored procedures to capture the Incremental changes for the data warehouse.