PROFESSIONAL SUMMARY:

• 9+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2008/2005/2000 in Development, Test and Production Environments with various business domains.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008/2012
• Migration of SSRS reports from SQL 2005 to SQL 2008.
• Extensive experience with data modeling techniques, logical and physical database design.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Used MDX to interact with the back end OLAP Services
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Expert ETL design.
• Created a custom SSIS transformation (Sequence generator) and let other developers use it in their packages
• Created a custom ETL Framework for logging and executing multiple packages in one stream using Master-Child hierarchy
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS.
• Good understanding in Oracle 9i/10g Database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), SQL Server Data Tools

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

Reporting Tools: SQL Server Reporting Services (2008/2005/2000), MS Access, MS Excel

Database: MS SQL Server 2014/2012/2008/2005/2000, MS Access, Oracle 9i/8i, DB2 iSeries, MariaDB

Programming: T-SQL, PL-SQL, C, C#

Web Technologies: HTML, DHTML, Java Script (Validation), CSS, ASP.NET

Operating Systems: Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential

SQL BI Developer

Responsibilities:

• Design and develop ETL SSIS Packages to pull data from production (MariaDB) into BI system using advanced incremental load technique
• Automate SSIS deployments using xcopy and dtexec utilities and deploying them on Mercurial Go Enterprise
• Led the team successfully for a proof of concept to use SSRS to replace existing home grown reporting solution Thales and automate deployment using RS utility and RSS script
• Created SSAS cubes and automated deployment using ascmd utility
• Used SSIS to connect to Hive to bring data into BI to create probability model
• Created parameterized SSRS reports with multiple data sets and dealt with time out issues
• Create and maintain job/plan/Templates scheduler using ActiveBatch Admin
• Hands-on experience using HG Tortoise repository for source control systems
• Developed an SSIS template to handle incremental loads and address data gaps so other developers can develop SSIS packages using it.
• Created SQL Reports using fact and dimensional tables
• Created new and modified existing SSAS cubes to include new measures and calculations
• Developed a SQL report that provides leads to the sales team to upsell products that eventually brought the company a revenue of approximately $75,000
• Analyzed, investigated and cleared discrepancies among Source, BI, DW each quarter for SOX audit reporting
• Analyzed cash to orders (CTO) discrepancies for finance to close every month.
• Assisted team lead in closing FY 2015 finance books.
• Identified Parameter Sniffing issue in a report for Data infrastructure team.
• Following Agile Scrum principles for every sprint at the company level and aligning objectives with the goals and objectives of the company using OKR tool.
• Responsible to monitor jobs and fix critical issues immediately on a daily basis to meet the SLA.
• Gather requirements from the product owners convert them into technical requirements and deliver.
• Perform full testing by playing the role of a QA within BI team and writing, validating test scripts.
• Participate in code review sessions to review and suggest code changes
• Wrote some complex T-SQL code and following industry best practices in stored procedures and experience using CLR functions.
• Wrote complex stored procedures for sales facts and dimension tables in T-SQL.
• Interacted directly with the sales and finance team requestors to gather, understand and revise requirements.
• Used table partitioning and switching for access logs tables.
• Experienced working on large databases and tables ( in the order of billions of records)
• Hands-on query writing experience in MariaDB (MySQL)
• Used ODBC DSN to define data sources to connect to MySQL.

Environment: Visual Studio 2008, 2012, SQL Server 2012/2014, T-SQL, SSIS, SSRS, ActiveBatch Admin, Redgate for SQL Server, MySQL, HG Tortoise Workbench, Jira, Thales, Query Explorer (SQL-Add-In), MySQL workbench, SalesForce, Confluence, Mercurial.

Confidential

Data warehouse Architect

Responsibilities:

• Design, develop, deploy and maintain SSIS packages.
• Modeling Data warehouse after a thorough understanding of the business and requirements.
• Implemented Auditing to log thousands of extract files processed on a daily basis.
• Designed, developed and deployed a couple of OLAP Cubes in SSAS for TAM Global Dwell and Transit
• Wrote MDX for SSAS calculations such as Median
• Developed a scoring algorithm in SQL to highlight missing data at Client - Site level based on certain criteria for assigning weights
• Created documentation such as Daily batch Processing timelines, Data Models for TAM, Missing Data recovery process flow etc.
• Created a BI solution to mask and load data for demo purpose to prospect customers
• Performed Stress testing on Reporting website with developers
• Re-designed cube processing strategy to improve daily processing duration
• Perform Unit testing in dev environment before deploying
• Experience using Toad Data modeler.
• Created and deployed Projects in SSISDB Catalogs.
• Troubleshot existing issues in ETL and Production box of SQL Server
• Working with customer service team to figure out cause for data discrepancies and imparting knowledge of source system data models and reporting to fellow team members.
• Discussing existing data quality issues and proposing solutions to VP.
• Used source control systems (Visual Source Safe and Team Foundation Server) to add, maintain and update existing BI solutions
• Implemented Database Maintenance jobs.
• Decent understanding of Yellow-Fin reporting suite.
• Resolving data issues based on service tickets from customer service team
• Adhering to best practices and I.D. Systems standards during development.

Environment: Visual Studio 2010/2012,SQL Server 2012, T-SQL, SSIS, SSAS,SSRS,Yellowfin,MDX,Visual Source Safe, Toad for Data Modeler,Team Foundation Server, SpiceWorks, Visio

Confidential

SQL ETL Developer/ Deployment Engineer/Data Architect

Responsibilities:

• Working as a SQL ETL Developer for i-RM.
• Working as a data architect and designed logical model for Reservoir Management.
• Experience using Erwin Data modeler.
• Upgrading and migrating 2008 SSIS Packages to 2012 SSIS Packages.
• Extracting data from SSAS cube to relational tables.
• Implemented SSAS cube warming.
• Wrote MDX queries to pull data from various measures and dimensions.
• Developed SSIS Package to pull data from a file on a share point list using SharePoint client DLL in C# code
• Worked on ODS (Operational Data Store) implementation
• Implemented Master-Child SSIS Packages
• Used GAC (Global Assembly Cache) utility to register DLL files
• Understanding of business and how it works in Oil and Energy industry
• Developing, maintaining SSIS Packages and deploying them onto Server
• Monitoring SQL Agent Jobs and reporting issues to DBA and working on bug fixes.
• Working closely with data architect to understand technical requirements and suggesting data types and approaches.
• Reporting to each member of team daily about the tasks that were done yesterday, to be done today
• Participating in team meetings, ETL developers technical discussions.
• Discussing with solution architect and deployment engineers about changes to the proposed solution
• Creating complex stored procedures and ownership of SSIS Solutions.
• Participating in training sessions on other technologies like petro web and GIS analysis
• Updating and creating documentation for the developed processes.
• Handing off completed processes to petro web developer and helping them understand data
• Working on performance tuning, determining SQL Agent Jobs.
• Working on Chevron ETL Framework, and monitoring error log tables.
• Adhering to best practices and Chevron standards while working.
• Identifying queries that depend on a few databases and documenting them for migration.
• Implementing sprint and responsible to user stories on scrum board
• Implemented CLR functions in SQL server 2008

Environment: Visual Studio 2008/2005,SQL Server 2008/2005/2012,SQL Server Data Tools, T-SQL, SSIS, SSRS,MDX,LOWIS,SSMS,Erwin R9,Toad for Oracle, Petro web Gateway,SSAS,Team Foundation Server, Agile Scrum, Red gate, Share Point, Oil Field Manager

Confidential, Dallas, TX

Sr. MS SQL Server/ BI Developer

Responsibilities:

• Involved in SSIS Packages development and also architecture of projects
• Created a web portal for various file upload like Excel, Text and CSV formats.
• Designed architecture for asynchronous File processing requirements
• Migrated objects from one server (SQL) to another.
• Moved objects from SQL Server to DB2(iSeries).
• Experience working on iSeries for Windows Navigator.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created multiple dynamic stored procedures and have experience working with XML Data in SQL
• Developed SSIS packages that daily/weekly run to transfer data from/to different servers.
• Experience working with Service Broker in SQL Server 2008.
• Worked on ASP.NET to write various functions as per requirements.
• Experience working on TIBCO SpotFire to generate reports.
• Created SQL Agent Jobs and scheduling them.
• Developed SSIS Packages that use iSeries client tool to pull/push data from/to iSeries
• Worked on MS-DOS commands to retrieve files into a text file from huge amount of data( folders/files)
• Worked on with script task and script component in SSIS.
• Experience working on Visio to represent design diagrams.
• Created a SQL Agent Job queue Stored Procedure to process files order by FIFO method.
• Experience with Team Foundation Server and BI Documentor tool.
• Worked on Java Script and CSS for styling web page in web portal for file upload.
• Worked with outlook and got it integrated with SSIS for reporting purpose.
• Worked on dynamic column mapping for excel and flat files in SSIS.
• Dynamic Table creation based on file name and populating it.
• Developed SSIS Packages to validate on row counts, identity value and column counts after data transfer.
• Worked on WQL to check if file is created then run a SSIS Package.

Environment: Windows XP Professional SP2, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSRS, T-SQL, C#.NET, Visual studio Professional 2010, iSeries Windows Navigator, MS-DOS,OLTP, BI Documentor, TIBCO SpotFire, Office-2007,Excel 2007, Visio 2010, MS TFS,WMI

Confidential

SQL Server Developer/SQL Server DBA

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 2005 / 2000(2003, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.