SUMMARY:

• Solutions focused, meticulous and result in oriented SQL Developer, Power BI Developer and IBM Certified Cognos 10.2 BI Report Author coupled with Master’s in Information Technology and MBA professional offering 10 years of successful career in IT arena distinguished by commended performance and proven results.
• Hands on experience in creating Indexed Views, Complex Stored Procedures, Functions, Triggers, CTE’s to assist efficient data manipulation and data consistency and used DDL, DML commands for various business applications.
• Excellent knowledge SQL Server Reporting Services, performance tuning and query optimization.
• Experience in data modeling, designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS Architecture by using Erwin Data Modelling tool.
• Experience in Extraction, Transformation, and Loading (ETL) data by using SSIS.
• Experience in importing/exporting data between different sources like DB2, Oracle, SQL Server, Excel etc. using SSIS/DTS utility.
• Hands on experience in PL SQL, T SQL, Data warehousing, Reporting.
• Thorough understanding of Kimball's' methodology , KPIs, SQL Architecture.
• Experience in SQL Server Analysis Services (SSAS) to develop Online Analytical Processing (OLAP), by creating cubes using data from data marts / data warehouse for deeper and faster data analysis.
• Efficient in upgrades and migration from MS SQL Server 2000/2005 to MS SQL Server 2012/2008.
• Expert in using Power BI to connect, model, and explore the data with visual reports which could collaborate, publish, and share.
• Integrated custom visuals based on business requirements using Power BI Desktop.
• Designed and developed the Dashboard reports in Power BI using Report View
• Used M language in the Query Editor to transform data before loading into Data Model.
• Used DAX Functions for analytical data calculations creating calculated columns and measures in the Data View.
• Extensive experience in reporting using Powerplay and Cognos 8 (Framework Manager, Map Manager, Report Studio, Analysis Studio, Metric Studio and Query Studio, Cognos dashboard), Cognos 10 report studio and transformer, Cognos 11 IBM analytics report studio.
• Hands on experience in migrating Cognos v 8.4 to Cognos v10 and Cognos v10 to Cognos v 11.
• Good knowledge of SaaS environment and developing analytics in a cloud platform.
• Good grip on Team Foundation Server (TFS) using for source code management, reporting, requirements management, project management.
• Ability to work efficiently in demanding work environments, strictly adhere to schedules and meet deadlines.
• Experience in all aspects of the project from requirements through development, planning, business analysis, execution, monitoring, scheduling and estimation of medium to large sized projects involving complex business solutions. Excellent interpersonal, communication and organizational skills with proven abilities in team management and planning.

TECHNICAL SKILLS:

Languages: SQL, TSQL, PL SQL/Java, HTML, Python, C#

OS: UNIX, Linux, Windows 9x/NT/XP/2000/Vista, OS/2, DOS

Databases: MS SQL Server, MS Access, Oracle, MS SQL, IBM DB2

Tool: Erwin Tools, IBM Cognos 10, Power BI, Tableau

WORK EXPERIENCE:

Confidential, Charlotte, NC

Senior SQL Developer/Power BI Developer

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Planned, designed, and implement application databases code objects, such as stored procedures and views.
• Build and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Wrote CTE, Functions, and Triggers
• Performed quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Excellent Troubleshooting and analytical skills
• Created ETL Packages using SSIS to extract data from flat files to SQL server.
• Created ETL Packages using SSIS which upserts data from staging table to database tables.
• Using Power BI to create business intelligence report which helps the management to better understand the facts and figures of the outcome which helps in decision making and boost productivity.

Environment: SQL Server 2012, 2014, 2016, Azure, Oracle, Windows Server 2010, Power BI, Power Query, CUBES, DAX, MDX, Dashboard Report, C#, SSIS, SSRS and SSAS

Confidential

Senior MS SQL Developer/ Cognos BI Developer

• Developed database for manufacturing and retail business and linked with User Interface Application to feed data. This saved time by eliminating manual feeding of data and enabled the accuracy of data.
• Automated regular daily, weekly, monthly and quarterly business reports by using Cognos BI tool, which saved manual effort and ensured accuracy and on - time delivery of the report.
• Developed business reports as per business requirements, this helped the higher management to take a strategic decision about manufacturing and marketing and make long-term and short-term plans accordingly.

Environment: SQL Server 2012, 2014, Windows Server 2008 R2, 2012, Management Studio, Cognos 10.

Confidential

Senior MS SQL Developer /Cognos BI Developer

• Developed data mart for Hyderabad Duty-Free and developed BI report for sales and marketing. This helped the marketing team to analyze the pattern, change marketing plan and thereby increased the sales and profitability.
• Handled Data warehouse Project and migrated old version Cognos 8.4 t o new version cognos10
• Handled HR Management Project. Developed a database for HR department. Developed various HR report by using Cognos 10. This helped the HR team to have a better hiring and employee retention plan in place.
• Developed database for Baggage Handling System for the airport and developed Baggage delivery report. This helped to understand the baggage delivery performance of each airline with different parameters like sectors, flight type, and bay allocation. It, in turn, helped to set the baggage delivery standard time, monitor and improve the baggage delivery performance.
• Handled Data warehouse Project and migrated old version to new version.
• Handled Abhudabi Airport Consortium project. Developed BI report for all operational areas of Abhudabi Airport, a third-party client by using Cognos 10.
• Customer Relationship Management (CRM) Projects; Created a database for CRM. Linked data from the different source, to the database. Developed various reports by using IBM Cognos 10 as a reporting tool.

Environment: SQL Server 2012, 2014, Windows Server 2008 R2, 2012, Management Studio, Cognos 10. AIX and Linux Operating System.

Confidential .

SQL Developer

• Worked as an SQL developer for Fuel Farm Management System.
• Worked as database designer/developer for Guest Relations Management System.
• Involved in all the phases of software development life cycle (SDLC) including requirement gathering and analysis, design, implementation, testing, deployment, and maintenance, related to various database projects.
• Developed Data warehouse logical and physical data model using Erwin tool.
• Built Star Schema data model DW.
• Built SSIS packages to Load data from source systems to Datawarehouse.
• Built SSIS packages for dimension and fact tables.
• Depending on the size of the data in dimensions handled type 2 slowly changing dimension using merge statement or the lookup component.
• Loaded fact table with millions of data by partitioning and loading the fact table using metadata columns.
• Designed SSIS packages to handle both full and incremental data load.
• Designed, developed and deployed dashboard using Tableau.
• Used staging tables to cleanse the data and, also to transform data wherever required.
• Used Foreach loop container to load multiple files at a time into the table and archived the loaded files.
• Deployed SSIS package to different environments and scheduled the packages using SQL Server agent job and monitored the deployed packages on the production server.
• Tuned the performance of the SSIS packages by avoiding the blocking transformation, by configuring the default buffer size and default buffer max rows, by using column store index wherever necessary.
• Audited daily data load.

Environment: SQL Server, T-SQL, Query Analyzer, Outlook, SSIS, BCP, SQL-Profiler, Enterprise Manager, VB script, Windows 2000, Windows 2003 Server, SQL Backup, Diagnostic Manager, C#, ASP.NET., Tableau

Confidential

assenger Data Analyst

• Conducted analysis of passenger data to understand the passenger load pattern to the different sector as per season and carrier.
• Linked the report with different market research and actual performance. This helped the airline to make the marketing plan, launch aircraft to the new sector thereby achieved a 10 percent increase in market share.