SUMMARY:

• Over 7+ years of extensive experience in database design and development using MS SQL Server 2014/ 2012/2008
• Expert in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Expert in Data Modeling and Multi - Dimensional Modeling
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse.
• Excellent knowledge on RDBMS principles.
• Proficient in MS SQL Server suite of products like TSQL, SSRS and SSIS of MS SQL Server.
• Proficient in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS.
• Maintained existing reports and created new reports according to the business needs and integrated them in performance point server.
• Experienced in using global variables, expressions and functions for the reports.
• Maintained securities, roles, subscriptions in report manager in SSRS.
• Expert in designing SSAS cubes with slowly changing dimension, partitions, Aggregation and KPIs
• Excellent ability to develop complex Crystal reports using custom SQLs, use of unions, creating subquery sections etc.
• Extensive experience of writing complex T-SQL queries, Views, Triggers, Functions and Stored Procedure
• Experienced in migrating reports from Crystal Enterprise to SSRS.
• Experienced in managing Tableau driven dashboards and reports
• Extensive experience in creating SQL Server analysis projects using MS SQL Server.
• Experienced in creating complex SSIS and DTS packages for ETL purposes.
• Implemented complicated transformations to be used in SSIS packages.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity, SQL joins and query writing.
• Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
• Knowledge of Reverse and forward Engineering, Logical and Physical models, Dimensional Modeling.
• Highly motivated and competent individual with good communication and analytical skills.
• Creative and passionate for technology.
• Good team player, extremely adaptable and a fast learner.

TECHNICAL SKILLS:

Databases Tools: Sr. SQL/MSBI Developer with Logi Analytics, SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Teradata SQL Assistant

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SSRS ( 2014/ 2012/2008 /2005/2000 ), MS Access, MS Excel, Crystal Reports, Tableau DesktopDatabase: MS SQL Server 2012/2008/2005/2000 , MS Access, Oracle 11g/10g/9i

Programming: T-SQL, PL/SQL, C, ASP.NET 4.5/4.0/3.5, C#.NET

Web Technologies: HTML, DHTML, XML, XSL, Java Script, CSSOperating Systems: Windows 2003/2008 Server, Windows XP, Windows 7,Windows 8,Windows 10

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

MSBI / SSIS /SSRS / SSAS Developer

Responsibilities:

• Responsible for creating and designing SSIS packages.
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
• Use event handing to send e-mail on error events at the time of transformation
• Use login feature for analysis purpose
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Design SSRS and excel reports, expense analysis, and balance sheet analysis.
• Deployed reports onto the production report server through various ways
• Worked on managing Tableau driven dashboards and reports
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Prepared the data mapping for all the migrated jobs using SSIS
• Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance in order to tune them
• Created script to migrate SQL server object from one environment to another environment
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes
• Modified the queries to achieve better performance
• Designed ETL process using SSIS to extracted data from flat files, excel files and SQL server database
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Worked on migration of SSIS 2008 packages to SSIS 2012
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, VBA (Visual Basic for Applications), Share point, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential, Houston, TX

MS SQL Server/Data Ware House/ ETL Developer

Responsibilities:

• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Extensive use of DAX expressions in tabular models as per business requirements.
• Experienced in using Data Analysis Expressions DAX to creating custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Involved in Writing SQL Queries, Views, and Stored Procedures on SQL Server 2005.
• Designed databases for applications with requirements for large numbers of transactions, heavy access, and high availability.
• Optimized T- SQL code.
• Worked with Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin

Environment: T-SQL, MS SQL Server 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005,MS SQL Server Reporting Services 2005, DAX, PowerPivot.

Confidential - Los Angeles, CA

MS SQL Server SSIS/SSRS/ETL Developer

Responsibilities:

• Worked with business stakeholders, application developers, and productions teams and across functional units to identify business needs and discuss solution options
• Gathered requirements from business users
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Foreach Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension and more
• Performed ETL mappings using MS SQL Server Integration Services
• Implemented Event Handlers and Error Handling in SSIS packages
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases
• Supported Production Environment by schedule the packages and make the package dynamic with SQL Server Package Configuration
• Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Created/Updated database objects like tables, views, stored procedures, function, packages
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS)
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS
• Involved in table and index partitioning for performance and Manageability
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance

Environment: MS SQL Server 2008, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer

Confidential, Austin, TX

SQL BI Developer

Responsibilities:

• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and technical specifications.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Written different T-SQL scripts for automated execution of the tasks.
• 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.
• Extensively used SSIS to move data from heterogeneous data sources Oracle and SQL Server 2008 to SQL Server 2012.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Converted DTS packages in SQL Server 2008 to SQL Server 2012 using Integration Services (SSIS).
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, and triggers.
• Implemented Complex business logic with User-Defined-Functions, Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files.
• Scheduled and executed different automated and manual jobs once the package is executed.
• Managed the Clustered environment databases and was fixing the errors when they arose.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Web-App Developers.
• Created Technical Report Requirement document for the Standard Reports.
• Implemented Column, Bar, Line, Pie, Doughnut charts using C# Chart control.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Created multi-dimensional cubes with different dimensions and measures in it using SSAS.
• Diagnosing and tuning the server optimal performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.

Environment: MS SQL-Server 2012/2008, MS Visual Studio 2012/2008, Erwin, SQL Server Management Studio, SSIS, SSRS, SSAS,, C#, Windows 2008 R2 Server, MS Access, T-SQL, MDX, DTS.

Confidential

SQL Developer

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Created DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Development of T-SQL Stored Procedures for moving and maintaining synchronization of data between legacy system and newly developed application.
• Expertise in using variables, property expressions, and script tasks in SSIS Integrated Database Maintenance jobs to perform full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Documented and maintained history of changes for future reference.
• Tuned the batch programs and online transactions to alleviate performance problems.
• Developed & executed several Optimized queries in SQL.
• Assigned Index tuning scripts to run at regular intervals.
• Performance monitoring and tuning MS SQL Server.
• Assisted the Application team in data modeling and T-SQL coding.

Environment: SQL Server 2000/2005, SSRS, SSIS, T-SQL, Script, JavaScript, Microsoft Office, Windows 2003/XP.