SUMMARY

• 7+ years of experience working as Senior SQL Database Developer with excellent experience in BI suite - using Microsoft SSIS, SSAS, SSRS, Azure, BI Oracle Warehouse Builder, Oracle data Integrator services, Pentaho PDI for ETL, reporting services SSRS, Pentaho PRD, oracle report builder for creating different types of reports using SQL queries and analysis services OLAP, SSAS, Mondrian schema (schema workbench ) for design complex cubes using MDX query's, Tabular Module DAX Query's for reporting, Power BI, tableau, SAS Visualizer for visualization reporting.
• Experience of working in the complete SDLC process, Waterfall Model and Agile - Scrum methodology.
• Well versed with the knowledge of RDBMS concepts and strong experience in writing SQL queries, triggers, functions, procedures, optimizes the procedure, views, joins, subqueries, and indexes.
• Experience in design the architecture of the complex enterprises system with back support of legacy logical data.
• Design data warehousing across multiple platforms with multiple sources & compute data in different work environments.
• Experience in oracle, DB2, Sybase, SAP to facilitate efficient data manipulation to maintain data consistency.
• Strong experience with integration designer, runtime engine, data flow task, transformation, pipeline & and executables, define and maintains database objects, and work force database.
• Experience in database administrative skills including, optimizes the procedure, backups, disaster recovery, database maintenance, database analysis, database management and enhancement, user authorizations and database creation.
• Experience with visual FoxPro tables, SQL, understand and debugging knowledge of old legacy code and find database migration approach.
• Developed multiple BIDS/SSIS Packages for loading the data from single and multiple source to staging and target database.
• Experienced with deployments, Maintenance and troubleshooting applications on Microsoft cloud infrastructure azure(saas, paas, iaas).
• Write code for program which run through batch/scheduler and do automated loading job periodically.
• Expert in Enterprises data warehousing (EDW) for OLTP (Data Vault model) & OLAP systems, creating Slowly Changing Dimension 1&2 for historical data, dimensional data modeling using schema-workbench, SSAS (multidimensional, Tabular), Dimension, Hierarchy, relationship, cube, measure, measure group, calculation, partitioning, KPI, optimization and aggregations.
• Experience in Reporting tool- SSRS/PRD, Visualization tool- Power BI/ Tableau/SAS Visualization, Security -server level, item level, cell level & accessibility to various reports in multi-user environment.
• Excellent in creating Power BI (Power view, Power Pivot ) mobile publishing power BI(html5) dashboards from multiple data sources using data blending cross tab, maps, scatter plots, pie, bar, density charts and SSRS reports cross-tab, conditional, drill-down, top-n, summary, form, sub reports, Ad-hoc, parameterized, interactive and custom reports.
• Utilize power query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Manage and retrieve data from a variety of sources and perform data statistics and solve complex business and research problems through a user-friendly interface Use extensions, Python and R programming language code to integrate with open-source software using SQL, SPSS Statistics.
• Excellent in Big Data Hadoop, Vertipaq (In-Memory) database, Tableau data analysis and visualization.
• Experienced in Cloud-Native ELT Tool MATILLION for cloud data warehouse.
• Experienced in interacting with business users/partners/stakeholder to analyzes the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Expert in creating business data and capacity planning requirements and convert the business requirement (database schema, data maps, ERDs and application objects) into technical detailed document.
• Experience on Visio tools for developing data flow and high level /low level design presentation for team.
• Extensive experience in ETL, structured system development, data transfer and interface methodologies.
• Excellent strong presentation, collaboration skills and can communicate all aspects of the job requirements.
• Excellent analytical and problem-solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches, technology and training.
• Thorough subject knowledge, Strong analytical skills to solve complex technical issues & troubleshooting skills

TECHNICAL SKILLS

OS Systems: Linux, Windows 10/7, XP, Vista, UNIX, Windows 2000, Windows NT, DOS.

DBMS/RDBMS: MS-SQL Server 2018-2017, JSON for SQL Server, Sybase, SAS, SAP, DB2 DB Visualizer, MongoDB, Azure PostgreSQL, Cosmos, HBase, Oracle Database 11g/10g/9i, T-SQL, PLSQL, Python, Visual FoxPro (vfp9.0),MS Excel, MS Access.

BI ETL & Reporting Tools: SQL Server Integration Services (SSIS), SSAS (MDX, DAX) tabular Model, SSRS, Oracle Warehouse Builder & Oracle Data Integrator, Power BI, Tableau, Pentaho PDI/PDD/ PAZ /PIR /PRD/PDI,HP Vertica database, MATILLION, MDM, MDS, DQS, Data Mart, Data Vault, MicroStrategy, SAS, SAS Visualization, SAP Business Objects, In-memory, T-SQL using stored procedures, indexing, aggregation, pivot queries, query optimization, Azure, AWS Redshift, azure data storage.

Tools: Visual Studio 2017 - 2017, Toad, dB visualizer.

Database Connectivity: ADO.NET, Entity framework, OLEDB, and ODBC.

Front End/ Tools: ASP.net, C# TFS, VSS, SVN.

Languages/Web: C, C++, Java, PL/SQL, Python and R, HTML5, XHTML, JavaScript, XML, Visio.

Job Scheduler: Autosys VM Architecture, Remote Desktop.

PROFESSIONAL EXPERIENCE

Confidential - Jacksonville, FL

Sr. SQL developer

Responsibilities:

• Drive Agile methodologies & attend daily stand up call for project updates.
• Writing sql queries for data profiling and calculate risk score.
• Create Power BI reports to demonstrate finance risk data statics to stockholders, using bar chart, slicer, Pie chart, Stacked Bar chart, R script visual, Python visuals, Matrix, Hierarchy Slicer.
• Responsible for creating data model design for finance spend system, developed risk entity, attributes, measure, KPI, partition, Perspectives.
• Creating database objects table, view, store procedure, trigger, functions, Index.

Application: MS-SQL Server 2016, (SSIS), SSAS (MDX, DAX), SSRS, Power BI, MS Azure, Data lake, Azure Data factory, Azure DevOps, PostgreSQL, AWS Redshift, Git Hub, MS SharePoint, Visual Studio 2017.

Confidential

Sr. SQL developer

Responsibilities:

• Developed Ad hoc Queries for Finance department. Designed and Developed AR Reports, Daily Payment Reports, Ledger Reports using Oracle Toad Reporting Services for Data Analyst.
• Used SSIS for large Data Migration Tasks.
• Developed Statements, Invoices, Notices, mortgages and Violations that are sent to SunPass Customers.
• Designed and Developed Toad Reports and Stored Procedures for Audit and Finance departments to suit their needs.
• Integral part of the Production Support Team on a biweekly rotation basis.
• Modified existing complex analytical and ad - hoc queries to run faster using OLAP approach.
• Analyzed financial data using graphs and pictures in SSRS for predicting future data. The level of automation achieved due to deployment of this project helped the department view the entire MDX Turnpike Authority's financial situation daily in real time and reduced considerable amount of manual work resulting in huge savings and efficient operations.
• Create Complex T-SQL Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Create summary T-SQL reports using pivot or crosstabs summary data.
• Developed SQL and Oracle stored procedures and Packages and Scripts for reconciliation purposes for various divisions in MDX and developed Toad and SSRS Reports (approx. 240) and deployed to the server.
• Run the reports themselves which helped minimize or eliminate unnecessary delays.
• Designed and Developed SSRS Reports and Toad reports and Stored Procedures and Packages and Scripts using Oracle and SQL for Audit and Finance departments to suit their needs.
• Helped the department to view the entire Surpass and Authority account's call centers call volumes daily automatically and reduced considerable amount of manual work to Call Center Managers and Customers (Turnpike Authority).
• Designed Collections workflow and developed stored procedures and reports using Oracle and SQL.
• Performed detailed Data Analysis using DI tools to establish trends in current data for traffic and revenue to predict future forecast up to 12 months that helped effective budgeting and efficient resource allocation.

Application: SQL Server T-SQL, IBM DB2, Sybase, PLSQL, BI SSIS/SSRS/SSAS ETL Development.