SUMMARY

• SQL/MSBI consultant with over 5 years of IT experience that includes Analysis and Design, Development & Support of MS - SQL 2014/2012/2008 R2/2008 and Business Intelligence including SSRS/SSIS.
• Highly qualified in implementing end-to-end BI solutions using the Microsoft BI Stack(SSIS, SSRS and SSAS ) within several industries.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Expert in designing complex reports like Drill-Down reports, Drill-Through Reports, Parameterized Reports, Sub Reports, Ad-hoc reports and Dashboard Reports using SSRS based on client requirement.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
• Experienced in Creating dimension tables inTeradatato fit our reporting needs.
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables.
• Proficient in Job Scheduling, Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Excellent understanding of full Software Development Life Cycle (SDLC)
• Ability to work independe Designed and coded application components in an Agile environment utilizing a test driven development approach, also created and maintained project tasks and schedules. ntly, demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment.

TECHNICAL SKILLS

Databases: MS SQL server 2014/2012/2008 R2/2008, Oracle 9i/10g, PL-SQL,MS Access

Database Design Tool and Data Modeling: Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server DTS, Visual Studio, Crystal Reports and Knowledge in SQL Server Analysis Services (SSAS),FullstackMSBI.

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console

Microsoft tools: MS Office, Management studio, Visual studio

PROFESSIONAL EXPERIENCE

Confidential, DALLAS, TX

MS SQL Server Developer/BI Developer

Responsibilities:

• Gathered business requirements related to data and business intelligence needs, HLD design for the ETL and Reporting requirements.
• Liaise with business subject matter experts in analysing Business Requirement Document(BRD)and translating them into conceptual data models and schema developmentto be implemented with T-SQL, ETL and Reporting to develop a solution.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Optimized the database by creating new tables, various clustered, non-clustered indexes.
• Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Responsible to created views with multiple Facts and dimension tables inTeradatafor building cubes.
• Diagnosing and tuning the server optimal performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.
• Map source system data elements to target system and develop, test, and support extraction, transformation, load processes, data profiling, data quality and clean ups for SSIS packages.
• Used various SSIS tasks such as Data flow task, Fuzzy lookup, Conditional Split, Derived Column and Union All which were used for Data Scrubbing, data validation checks during Staging.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data base.
• Created SSIS packages to load data into Data base using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Planned to schedule reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs using SQL Server Reporting services (SSRS).
• Designed for Alerts for successful or unsuccessful completion of Scheduled Jobs..

Environment: SQL Server 2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Teradata, Database Tuning wizard and Visual Source Safe.

Confidential, Dallas, TX

SQL Developer/ SSIS/SSRS Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of reports in SQL Server Reporting Services (SSRS).
• Designed and developed a full-scale reporting solution for an environment using SQL Server 2008 and SSRS 2008.
• Worked on developing Tables, Indexes, Views, Complex Stored Procedures, Triggers, Functions, SQL joins and other T-SQL code to implement business rules in SQL Server 2008.
• Wrote T-SQL, designed and modified database objects such as Tables, Stored Procedures, and UDF for SSRS report requirement.
• Extensively utilizedTeradatautilities for loading the data in to CPM DWH system.
• UsedSQLto query the databases and do as much crunching as possible inTeradata, using very complicatedSQL.
• Defined Check constraints, Business Rule, Indexes and Views.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Installed and configured MS SQL Server 2008R2 along with Visual Studio on a network domain system.
• Designed develop SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to AMS database.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions and more using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Proficient in using Table variable, Temp table, Dynamic SQL, Loop, CTE, and various built-in functions in SQL server.
• Developed Tabular, Chart, Matrix, Drill down and Drill through reports using SSRSas well as managed the Subscriptions of the reports.
• Generated Multi Parameterized reports in SSRS allowing users the ability to make selections before executing reports; thus making them user friendly.
• Experience in deployment of the generated SSRS reports through report manager.
• Designed and developed corporate performance management solutions including Dashboards, Score cards and analysis of SSRS reports using the data from SQL Server 2008.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensively used SSRS for creating reports like Sub-reports, Linked reports, Cascaded Parameterized reports, Matrix reports and different types of Graph reports.
• Created official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.
• Subscribed many of reports useful for the clients through scheduled Email subscriptions.

Environment: SQL Server 2008, SQL Server Reporting Services (SSRS), Microsoft Visio, SQL Profiler, Database Engine Tuning Advisor and Visual Source Safe.

Confidential

SQL Server/SSIS Analyst

Responsibilities:

• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them
• Extracted data from heterogeneous sources and transferred to OLAP using SSIS 2012
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations
• Involved in automating SSIS Packages using SQL Server Agent Jobs and configured various event driven e-mail notification process in SSIS packages.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Deployed SSRS report to SharePoint and Report Server Web Service.
• Configured report server and report manager for SSRS report deployment and management.
• Rebuilding/Reorganize indexes and running Database Consistency Check Commands (DBCC).
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking full Backup, Transaction log backup & differential backup in daily Routine.
• Collaborated with network operators, application developers, and DBAs to enhance end user experience.

Environment: SQL Server 2005/2008/ R2/2012, BIDS, Visual Studio 2005/2008/2010 , T-SQL, MS Access, MS- Excel, SSIS,SSRS,SSAS, Report Builder 2.0/3.0