OBJECTIVE:

• To obtain a challenging position as a senior SQL Business Intelligence Architect. Experienced professional and thought leader. Expert level programming and database skills. Pioneer in cutting - edge Business Intelligence visualization, data transformation, statistics and predictive analytics. Broad-spectrum success and mastery of operational dashboards and scorecards.

SUMMARY

• 15 years of progressive experience in database programming and designing databases on various versions ofSQLServer.
• In-depth knowledge of T-SQL. Experience in creating indexed views, complex stored procedures, TEMPeffective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Has a thorough knowledge of database backup/ restore/ Data import export.
• Has worked on normalization/de-normalization, Logical and physical data models.
• Involved in various projects relating to Data Analysis, OLTP Data Modelling, System Analysis, Design and Development.
• Worked on teh entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Ability to demonstrate deep understanding of entity relationships and all database types and their application to technology and functional solutions.
• Has Strong self-sufficiency and initiative working on Database projects.
• Data analysis is a key strength wifin quickest possible time.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Hands on experience wif performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience using SSIS tools like Import/Export Wizard, Package Installation, and SSIS Package Designer.
• Very good knowledge on another ETL tool, named Talend.
• Involved in creating Jobs,Alerts and Schedule SSIS, DTS Packages. Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling.
• Sound Experience and understanding ofSSAS, OLAP cube and Architecture.
• Expert in creating Star schema cubes usingSSAS.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Extensively involved in teh SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Good experience in writingMDXqueries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations usingMDX.
• Defining relationships betweenDimensionsandMeasure groups. Involved in teh design and development of teh SSAS cubes andMDXqueries.
• Involved in writing MDX Scripts for teh OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Created reports in SSRS wif different type of properties likechartcontrols, filters, Interactive Sorting, SQL parametersetc
• Experience in configuring and deployingSSRSreports onto Microsoft Office SharePoint Server.
• Created reports fromOLAP,sub reports, bar charts and matrix reports usingSSRS
• CreatedParameterized reports, Cross-Tab reports,Drill down reports& Summary reports by UsingSSRS.
• Created report snapshots to improve teh performance ofSSRS.
• CreatedETL metadata reportsusingSSRS, reports include like execution times for theSSISpackages, Failure reports wif error description.
• Applied conditional formatting inSSRSto highlight key areas in teh report data.
• Extensive experience on using Dynamic SQL statement in complex stored procedure to simplify any search or parameterized statement running.
• When SQL statement is dependent on user inputs or they may depend on processing work done by teh program, I used Dynamic SQL statement, which made it very easy and convenient.
• Expertise on writing complex Dynamic SQL statement when their needs very complex search or complex conditional parameters.
• Used IN and OUT parameterized stored procedure for Dynamic SQL command by converting it by NVarchar text slices.
• Automated teh SQL statement using Dynamic SQL Statement. It optimized execution dynamically.
• Used to Perform Dynamic SQL operation using Invoker-Rights.
• Strong front-endUIdevelopment skills using scripting languages likeHTML5,CSS3, JavaScript,JQuery,AJAX,JSON,ExtJs, Angular Js, DOM,JSP,JQueryPlug-ins.
• Expertise in Advanced JavaScript libraries and frameworks such asPrototype,ExtJs,AngularJs, andObjectorientedprograminginJS.
• Extensive experience in Cross-browserHTML,CSSJavaScriptcoding to offer responsive website layouts to modern browsers and mobile devices.
• Extensive experience wifCSS3and leveraging best practices, modifications of existing CSS files to enhance teh user experience.
• Intermediate experience wif Advanced JavaScript including prototype-based inheritance,AJAX,JSONand familiar wif JavaScript frameworks such as,JQueryandJQuery-UI.
• Experience in Developing Power BI Reports and Dashboards from Multiple data sources using Data Blending.
• Expertise in Business Intelligence application Power BI for 6 years.
• Analyze, assess and implement data and business processes, perform gap analysis and identify data quality issues wifin those business processes.
• Organize disparate data sources into single data models.
• Install and administer Power BI Server.
• Assist Client wif Power BI Server integration issues.
• Develop creative solutions for client problems.
• Expertise in creating data extract and transformation model and to create teh graphical user interface or presentation layer.
• Handles teh communication between clients and teh Power BI applications. It loads Power BI applications into memory and calculates and presents user selections in real time.
• Experience to create dashboards, graphical representation of data, straight table, pivot table, set analysis in Power BI.
• Able to normalize Synthetic keys which improves data loading and overall performance.
• Has designed incremental data loading.
• Connection between Power BI and Data mart and ensure teh smooth and error free data loading in regular basis.
• Strong hands on experience on different types of filters on visual level, page level, report level & drill through in Power BI.
• Able to generate DAX query for any kind of functional aggregation in Power BI.
• Using DAX, role based setup was done in Power BI.
• Extensive use ofDAX expressionsin tabular models as per business requirements.
• Using Power Pivot ensured data loading, calculation and analytics in Power BI.
• Any kind of ETL activity is performed through Power Query in Power BI.
• Using Power Map generated dashboards and reports in a geographical manner.
• Create dimensions for teh separation of teh data.
• Worked in Azure SQL Database to make teh database cloud managed (SaaS).
• While Azure SQL Data warehouse development downtime, scalability, data protection and performance maximization are tested.
• Manage Azure SQL servers, databases, and firewalls using PowerShell
• Extensive Knowledge on developing applications using C#.NET, VB.NET, SQL Server.
• Involved in Query Optimization and Performance Tuning.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Ability to handle Multiple Tasks, Self-Motivated, organized team player wif strong problem solving and analytical skills and total commitment to teh organization goals.
• Ability to Quickly grasp and Master new concepts and technologies.
• Able to design and develop TEMPeffective user friendly MIS.
• Good hands on financial analysis.
• Experience in designing relational database model and implementation as per requirement using SQL Server.
• Having experience in local, Multinational and USA based Companies.

TECHNICAL SKILLS

Databases: SQL Server 2008/2012/2016 , MS Access, Oracle (11g,10g,9i).

Database Tools: SQL Server Management Studio, SSIS, SSAS, SSRS, SQL Profiler, SSRS, TOAD.

Programming Languages: SQL, T-SQL, PL/SQL, JavaScript, jQuery, VB.NET, C#.NET, ASP.NET.

Data Visualization: Power BI, Tableau, QlikView.

Microsoft Office: Excel (Advance wif macro), Word, Power point.

Others: Talend, Dev Express, Crystal Report, Mirth.

PROFESSIONAL EXPERIENCE

Confidential - Houston, Tx

BI Data Analyst

Responsibilities:

• Design and development of interactive visualizations through Power BI and Tableau.
• Development of Power BI Reports and Dashboards from Multiple data sources.
• Installation and administration of Power BI Desktop and Services.
• To design graphical representation of data, straight table, pivot table, set analysis and charts.
• Use different types of filters on visual level, page level, report level & drill through in Tableau.
• Generate DAX query for functional aggregation in Power BI and to create role.
• Ensure row level security (RLS).
• Work on Power Query, Power Pivot and Power Map.
• Programming in T-SQL and wif BI tools (SSIS, SSAS, SSRS).
• Database administration, Data modeling and Enterprise Data Warehouse development and maintenance.
• DesignOLTP databases andcreate OLAP cubes.
• Work as Lead integration resource to help drive data integration deliverable.
• Work wif technology teams as well as business teams on solution architecture to successfully integrate data.
• Provide technical & Development Support to teh client, Design and prepare technical specifications.
• Involve in development, bug-fix,troubleshooting issues, performance tuning efforts.
• Ensures adherences to locally defined standards for all developed components.
• Ensures performance metrics are met and tracked.
• Mentor teh technical team and train them.
• Guide customers on best visualization adopted by KPI’s and business scenarios through Tableau dashboard.
• Prepare training manual and conduct training on Power BI.
• Course work in end to end software development life cycle including data extract, transform and load (ETL) development, visualization, testing and deployment.

Confidential - Charleston, SC

Lead BI Developer

Responsibilities:

• Design, develop and deploy Business Intelligence solutions.
• Translate business specifications and process designs into technical requirements for analytic solutions.
• Develop and execute database queries and conduct analyses.
• Develop data warehouse to integrate different data sources into one solution.
• Program teh procedures for necessary data transformation.
• Identify teh speedup techniques for faster data integration.
• Develop right dimensions and measures for smooth data analysis.
• Prepare a continuation plan of teh automation of integration packages and analysis services.
• To visualize data design and develop different reports and charts.
• Confirm teh administrative tasks and prepare test cases wif a smooth deployment plan.
• Maintain teh versions of all packages, cubes and reports using TFS (Team Foundation Server).
• Prepare project plan, estimate project timeline and meet deadline.

Confidential

Lead SQL BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of analytics.
• Involved in Planning, Defining and Designing database on business requirement and provided documentation accordingly.
• Developed complex T-SQLcode such as Stored Procedures, functions, triggers, Indexes and views for teh applications.
• Worked on AGILE methodology in development of Database Objects in SQL Server 2008/2012.
• Involved in designing teh physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Improved performance of PL/SQL program units by analyzing teh complexity and memory management.
• Wrote conversion scripts using SQL, PL/SQL, Stored Procedures, Functions and Packages to migrate teh data from teh SQL server database to Oracle database.
• Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Involved in Agile methodology by analyzing business requirements and understanding teh functional work flow of information from source systems to destination systems, completed work through Sprints.
• Worked wif teh team to design, develop, test & implement system. Creation of database objects like tables, procedures using Oracle tools like PL/SQL, TOAD. Written Stored Procedures using PL/SQL.
• In SSIS packages creation I used parameterized Dynamic SQL, which took different variables runtime.
• In mostly complex stored procedures, I used Dynamic SQL command where teh static SQL command did not serve purpose.
• Expert in creating Star schema cubes usingSSAS.
• Extensively involved in teh SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• For User input dependency, I also used Dynamic SQL statement.
• When IN and OUT parameters were needed in stored procedures I converted teh SQL command into text slices to create Dynamic SQL statements.
• Attended dailyScrummeetings, kept up-to-date on best practices forJavaScriptframeworks and techniques.
• Designed user interface for teh product of gift card usingAngular JS, jQuery, CSS3, HTML5 and JavaScript.
• Produced client side validation throughJavaScriptandAjaxfor asynchronous communication.
• Involved in development of front-end components usingSpring MVC, JSP, JavaScript, JAVA, and JSON.
• Responsible for validation of Client InterfaceHTMLpages usingJavaScriptandJQuery.
• Expertise in Advanced JavaScript libraries and frameworks such asPrototype,ExtJs,AngularJs, andObjectorientedprogramminginJS.
• Design and developPower BI reports based on user requirements.
• GeneratedPower BI Dashboards, Scorecards wif filters, quick filters, context filters, global filters, parameters and calculated fields on reports.
• GeneratedPower BI reports wif Trend lines, Reference lines and Bands and generated several drilldown and drill up reports.
• Develop Power BI straight table and pivot table for tabular reports and graphical representation.
• Used Power Pivot, Power Query, Power Map for loading data, creating analytics, ETL activity and geographic dashboards.
• Managed aggregation and functional tasks through DAX.
• Gatheird Client requirements and converting them into teh Technical Specifications and developed Web forms using ASP.NET and VB.NET.
• Works as a part of a project team to coordinate database development and determine project scope and limitations.
• Created SSIS package to load data from SQLServer 2012 toSQLServer 2014, MS Excel, Text etc.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed and modified Triggers, Packages, Functions and Stored Procedures for data conversions and PL/SQL procedures to create teh database objects dynamically based on user input.
• Scheduled Jobs for executing teh stored SSIS packages, which were developed to update teh database on Daily basis usingSQLServer Agent.
• Worked on agile Software Development Life Cycle(SDLC) of teh application like Requirement gathering, Design, Analysis and Code Development.
• Provide technical support and guidance for application and report development for SQL databases.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas, Microsoft Queries, Macro.

Environment: MSSQLserver 2008/2012/2014 , SSIS, SSAS, SSRS, SQLProfiler, Power BI, QlikView, VBA, Agile, Visual Studio 2015, ASP.NET, C#.NET, VB.NET, Dev Express, MS Excel.

Confidential

Database Development

Responsibilities:

• Installation ofSQLServer wif latest Service pack and established connectivity wif teh database created, configured and maintained database maintenance plans.
• Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views for remote instances.
• Created T- SQLqueries, stored procedures, triggers, views, Indexes, Constraints and user defined functions (UDFs) on various database objects to create, modify and/or maintain databases.
• UsedSQLProfiler and Database Tuning Advisor for troubleshooting, monitoring, optimizingSQL Server and T- SQLstatements.
• Involved in developing Extraction-Transformation-Loading (ETL) process. Used SSIS package and Talend both for developing data warehouse.
• Experience in creating complex SSIS Packages wif error handling using control and dataflow elements.
• Created, Tested and Deployed SSIS Packages for Data Migration into Fact and dimension tables in teh data marts from teh source data warehouse tables.
• Configured data sources (e.g: web services, EXCEL 2010, 2012, 2007, Access, Flat files, text files etc) according to new servers and databases.
• Excellent analytical skills and problem solving techniques as a data modeler.
• Performed T-SQL performance tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQLServer 2008/2012.
• Gatheird data into PL/SQL tables for validating and loaded into Oracle tables.
• MigratedSQLserver 2008 R2 packages toSQLServer 2012 SSIS packages usingSQLServer 2012 Upgrade Advisor.
• Mostly involved in code reviewing and performance tuning wif optimization techniques in PL/SQL.
• Created packages wif different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Configured Dynamic Checkpoints to allow rerunning a package from teh point of failure.
• Actively involved in identifying business requirements wif teh client.
• Responsible for documenting and implementing newly developed programs used in company database application, by working wif other IT experts, developers and end users.
• Designed and developed various reports containing data analytics and visualization wif reporting tools such as Excel Pivot tables and Power BI on SSAS Cubes and data warehouses as teh data sources.
• Worked under teh Agile methodology, using teh scrum tool Jira, to monitor our work/tasks on sprints basis.
• Created jobs and scheduled jobs using SQL Server Agent.
• Expertise in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis.

Environment: MSSQLServer 2008R2/2012, Agile, Access, T-SQL, SSIS, PowerBI, SQL Profiler, Excel, ASP.NET, VB.net, Talend.

Confidential

Business System Analyst, IT

Responsibilities:

• Gatheird and collected process & system requirements and Actively supported business users for change requests.
• Analysis teh Business Policies and gathering Business Information.
• Convert teh business requirements into software project and develop TEMPeffective database as per teh business rules.
• Development, Maintenance and troubleshooting of databases.
• Manage IT Projects as teh key opinion leader.
• Development of teh Softwares.
• Building up and maintenance a Data Warehouse using SSIS.