SUMMARY

• 7 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008/2008 R2/2012.
• Extensively worked on Data Extraction, transforming the data by using SSIS.
• Hands on experience in scheduling and deploying reports on report manger.
• Experience in configuring report manager for creating report subscriptions, snapshots, and caching.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing, SQL joins, performance tuning and query optimization.
• Worked in OLTP and OLAP System Study, developing Database Schemas in relational and dimensionalmodeling.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in web technologies like HTML, XML, CSS, JSP, JavaScript, J-query, SOAP, and Bulk & Metadata API.
• Experience in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types (UDT), Cursors, Functions, data dictionaries, and maintaining data integrity and Indexes using T-SQL.
• Experience with the .NET framework including C#, ASP.NET 4.5 and Web Services.
• Experience in enhancing and deploying the SSISPackages from development server to production server.
• Knowledge of MDX queries to interact with the back end SSASOLAP Services.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on Microsoft OLAP/ Analysis Server (SSAS).
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server 2012/2008.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Teradata, Sybase, Flat File and MS Access.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions
• Extensively worked on SSIS, Data Cleansing and Data Migration.
• Capable of handling multiple critical business applications as a primary point of contact which involves Development, Enhancements and production support activities

TECHNICAL SKILLS

Databases Tools: 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 ( 2012/2008/2005/2000 ), MS Access, MS Excel, Crystal Reports, Tableau Desktop

Database: 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, CSS

Operating 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

Sr SQL/MSBI Developer

Responsibilities:

• Build a data cube around the existing offer click, impression and revenue statistics from redirectors
• Construct different hierarchical dimensions suitable for offer analyst to use.
• Build a set of reports which includes historical same-period comparisons.
• Enhance and build selected redirect reports with the flexibility of an OLAP service
• CreatedSSIS packagesto load data into staging table and data mart and also Performed logging inSSIS packagesto capture error data and for error handling.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• PerformingT-SQLtuning and optimizing queries for reports that take longer execution time.
• Extract data from flat files which comprised of header and input files to SQL server 2008R2 and Created Testing scripts for staging validation, generated the Map Force file for mapping between flat file and database.
• Involving in Installation, configuration ofSQL Server 2008R2on Windows 7.
• Created different kind of reports like cascading reports, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports and charts in SSRS 2008R2.
• Excellent command on subscriptions, report snapshot and report cache.
• Created trace in SQL Profiler for Performance tuning onstored proceduresand Scripts.
• Monitored the system utilization and checking the execution plan to improve the performance.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services 2008R2, Integration Services SSIS, Analysis Services SSAS, T-SQL, MS Access, MS Excel, Map Force, XML Spy, Version Control, Agile Environment.

Confidential, Houston, TX

MSBI & Dashboard Developer

Responsibilities:

• Work with data architect to identify and understand source data systems.
• Assist with source data analysis and profiling and in the development of the source to target mapping documents.
• Map source system data to the data warehouse and data marts.
• Created complex stored procedures, triggers, tables, user functions, CTE, user profiles, relational database models and data integrity, SQL joins and query writing.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Created complex SSIS packages to extract data and scheduled Jobs to call the packages using SQL server agent.
• Formulated and documented the ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills, including source to target mappings, transformations, look ups, aggregations, and expressions.
• Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Row count, Cache Transform and Derived column while developing the packages.
• Implemented of Data Viewers, Logging, and Error Configurations for error handling the packages.
• Developed Master Child Package using Execute Package Task and Parent Package Variable Configuration
• Deployed and configured various SSIS packages.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports
• Deployed and scheduled Reports using SSRS to generate all reports including current status
• Configured the report viewing security for various users at various levels using Report Manager.
• Successfully worked with Report Server and configured into SQL Server.
• Created user interactive Dashboards using Microsoft Power Pivot and deployed them into SharePoint.

Environment: SQL Server, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Power pivot, Dundas.

Confidential - Los Angeles, CA

SQL MS / BI Developer

Responsibilities:

• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Developed the flow charts and diagrams as well as translation of the detailed designs with Lotus Notes application.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Provided ongoing Qlikview implementation and support.
• Outlined new features of Qlikview for clients.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Handled Tableau admin activities granting access, managing extracts and Installations
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases extensively
• Worked on Database Compression for different databases to save space across different environments. used Joins and Common Table Expressions to simplify complex queries involving multiple tables

Environment: Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2005/2008/2012 , TSQL, PL/SQL 11g, Informatica, Visual Studio 2008, Sharepoint 2007/2010, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin

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.
• Developed large number of standard and customized reports usingSSRSfor data feeds and for Reports on server.
• 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 BI 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.