SUMMARY:

• A Senior SQL Business Intelligence and Software Developer with 16 years of hand on experience in design, development and maintenance of Reports, Cubes, ETL Packages and Enterprise Applications.
• Having Solid Understanding of Data Mining, Deep Learning, Artificial Intelligence and Machine Learning.
• Handled large scale databases for both OLTP and Data Warehousing Systems, and developed BI Applications using SSIS, SSAS, SSRS, Power BI, Tableau and Alteryx tools.
• Experience also includes enterprise level large scale development of reporting system framework and software product development.
• Has core expertise in internals of critical Microsoft technologies.
• Expert in design and developments of Business Intelligence Reports and Dashboards Using Power BI, Tableau, SSRS.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Expert in design/development data visualization (Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart) reports using Power BI and Tableau.
• Good command in generating On - demand and Scheduled reports for Business Analysis or Management decisions using SSRS, Excel, Power BI, Tableau
• Experience in creating reports such as Parameterized, Cascading, Drill through/Drill down Reports, Conditional, Table, Matrix, Charts, Ad-hoc Specialized in using Relational data warehouse and OLAP Cubes for producing Sub Reports.
• Extensive hands-on experience in several Data Flow Transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union
• Hands on experience working with Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Hands on experience in developing and writing T-SQL Queries, Store Procedures, Creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS, SSIS, Alteryx
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in SSIS, Alteryx.
• Proficiency in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Strong experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS.
• Experience of Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using ERwin and SQL Server Enterprise manager.
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Solid understanding of concurrent, multi threading and distributed programming
• In-depth expertise in applying object oriented analysis and design and design patterns to business solutions,
• Designed and developed web and windows applications in C#, VB.NET, ASP.NET, SQL Server 2005/2008/2012 , HTML, Ajax, Web Services, Windows Communication Foundation (WCF), Windows Visual C++, DCOM, Visual Basic 6.0, Scripting Languages (Java Script and VB Script), Web Services, .NET Remoting, XML, XSLT, SOAP, ADSI, MSMQ Services
• Implemented SOA based enterprise and web based n-tier (B2B) systems
• Experience with agile/scrum project life-cycles, iterative processes, and traditional methodologies

TECHNOLOGY SKILLS:

Databases: SQL Server 2000/ 2005/2008/2012 , 2014, 2017 Oracle, MS-Access

ETL Tools: SSIS, DTS, Alteryx

REPORTING TOOLS: SSRS, Power BI, Tableau, Active Reports, Crystal Reports, Power Pivot, BISM

Analytics Tools: SSAS, MDX, ExcelWeb Technologies, Server-side

Scripting, Languages: ASP.NET, PHP, Java Script, VB Script, APS.NET Languages, C#, VB.NET, C/C++

Analysis & Design Methodology: OOA/OOD, UML, OMT, .NET Based Design Patterns, Agile & SCRUM

Operating System: Windows 2010, Windows Server 2008, UNIX, MSDOS

PROFESSIONAL EXPERIENCE:

Confidential, McKinney, TX

Sr. SQL and BI Developer Architect

Responsibilities:

• Analyzed existing database (tables, views, stored procedures, indexes, constraints, etc.) and designed new and improved database schema based on existing business functionality.
• Created Stored Procedure for complex business logic to integrate with sitecore and website design teams, designed tables using RDMS rules, recover deleted rows from production database.
• Designed various SSIS/SSRS packages for ETL and Reporting including writing to flat files, appended files, transformation and loading data to/from third party systems, report generation, etc.
• Create stored procedures and views used for reporting and data mining.
• Create OLAP cubes and dimensions for star, snowflake and constellation schemas
• Utilizes attribute combine properties to combine different attributes used in hierarchy construction in order to optimize performance.
• Build calculated measures using complex MDX expressions to perform YTD, MTD percentage of cumulative total
• Designed SSIS package to import legacy data into new database, transformed values and data type, made validation on data integrity for data consistency.
• Implemented stored procedure error handling for logging and debugging.
• Implemented Change Capture Data (CDC audit) to captures records Inserts, Updates and Deletes on various databases.
• Created Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Refactored cube and SSIS packages to improve long running jobs and processes.
• Created BI reports using Power Pivot for Multidimensional Data and BISM
• Write SSIS Adapters and used third party Kingsway soft data migration tools for migrating data from Microsoft Dynamic SQL Server
• Created schemas and write complex queries for the PHP applications which used data bases on MySQL Server
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Drill through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.

Environment: SQL Server 2012, SQL Server 2008R2, SSIS, Web Services, SSRS, SSAS, Kingsway soft data migration tools, Crystal Reports 10, HTML, JavaScript, XML, Visual Studio 2008, 2010, Visio 2002, Power Pivot, BISM, MySQL Server Visual Source Safe.

Confidential, Plano, TX

Sr. BI Developer

Responsibilities:

• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Did data modelling and schema design for Broker Agent Commission Disbursement, Tennant Application Processing, Property Management and Property Listing Module applications.
• Published reports and dashboards using Power BI.
• Created artifacts for system diagrams, object models, data flow diagrams, high/low level designs
• The project operates on agile project development cycle with Monthly sprints, daily standup, retrospective sessions and sprint planning.
• Involved in requirement gathering, designing, development, UI reviews, architectural work and schema design.
• Created SSRS reports using Microsoft SQL Server Reporting tools.
• Write SSIS packages for transferring data from Experian to generate quality leads.
• Also helped .Net Development with Architecture and System Design, Web API, Created Web APIs using C#

Environment: SQL Server 2012, SSIS, SSRS, Power BI. Tableau, Alteryx, MySQL Server, .NET, ASP.NET

Confidential, Dallas, TX

Sr. Business Intelligence Developer

Responsibilities:

• Created more than 100 reports related to Customers, Auctions, Bids, Departments for Sr. Executives, Digital Marketing Team using SSRS and Tableau
• Created SSIS packages to get data from various sources to update data related to Mass Email and distal marketing.
• Write complicated Queries and stored procedure for both Microsoft SQL Server and MySQL Server
• Used Alteryx for ETL operations from heterogenous data sources.
• Also worked on enhancement and maintenance of .NET application

Environment: SQL Server 2012, SSIS, SSRS, Tableau, MySQL Server, .NET, ASP.NET

Confidential, Plano, TX

Sr. SQL Developer

Responsibilities:

• Worked on reconciliation project (Wrote several complex stored procedures to compared actual money deposited every month to Confidential ’s bank and money received/refunded every month from various banks, credit cards, online transactions etc.)
• Created SSIS packages to load the data from PALS to Insight database.
• Did optimization of ETL jobs.
• Created Reports to handle Ethnicity Information.
• Designed and developed SSIS packages for State of Illinois, Oregon, Ohio, California and Washington.
• Created SQL Reports for University of Illinois using SQL Server 2005/Server 2008
• Wrote stored procedures to implement complex business rules related to coverage and member match and member merge.
• Worked on improving performance of Stored Procedures, SSIS Packages, and Report Generation.

Environment: SQL Server 2008, 2008 R, SSIS, Web Services, SSRS, SSAS, Crystal Reports 10, HTML, JavaScript, XML, Visual Studio 2008, Visio 2002, Visual Source Safe.

Confidential, Irving TX

Technical Architect

Responsibilities:

• Tasks performed by Solution Integration Engineer include architectural design, design and development of critical components and test programs, code review, general development consulting, performance tuning, memory dumps analysis.
• Designed and developed business processes, system architectures, object models, high/low level designs using object oriented design methodologies and .NET based designed patterns.
• Designed and developed several critical components for several Microsoft’s Premier Customers in .NET (C#, VB.NET), Visual C++, DCOM, Visual Basic 6.0, Scripting Languages, Web Services and .NET Remoting, XML, XSLT, SOAP, ADSI.
• Reviewed the application architectures of more than 20 Microsoft Premier Customers and helped them to tweak/revamp the architectures of their applications to remove critical bottle necks (hang/crash/sluggishness) from the applications running under production environment.
• Developed expertise in resolving the tough issues related to heap corruptions, memory leaks, hangs, access violations, performance tuning, networking and threading spanned over multiple technologies.
• Extended Biztalk Server Components and developed and integrated web services with several .NET custom applications.
• Resolved critical issues related to Content Management Server, Commerce Server and BizTalk Server and developed expertise in using different kinds of debugging tools: - Windbg, DMatrix, Leakdiag, Performance Monitor and Managed/Unmanaged profilers.
• Developed expertise in analyzing memory dumps