TECHNICAL SKILLS:

• MS SQL Server Database Administrator/Developer, BI, ETL, Healthcare and Business settings, SQL Server Configuration, Replication, Virtualization.
• Visual Studio, C#, .Net, C++,VB, SDLC, SharePoint, PowerShell scripts, REST API, Open Data Protocol MS EXCEL, Access, Visio, Oracle, Java, Cogito, Star, Radar, Workbench, REST API, Open Data Protocol, Javascript
• SSMS, SSRS, SSAS, SAAS, SSIS, SSRS, ETL, Crystal Reports,
• A Microsoft Certified Professional with around 16+ years of total IT/Engineer experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2, 2012, 2014, and 2016.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C# in script component of SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005 - 2016 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS.
• Microsoft Certified Technology Specialist -Microsoft SQL Server 2008 Business Intelligence (SSIS, SSRS, SSAS) Development and Maintenance.
• NoSQL, PLSQL, MySQL, T-SQL, SQL queries, Transact-SQL, SQL Server architecture,
• Data Science, Data Analysis, data mining, Data Warehouse, Business Intelligence, Statistical analysis, concatenations, pivot tables, Table partitioning and archiving, Data cubes, Data marts,Big Data,JSON and XML data interchange
• Optimize Stored Procedures, Indexing, Consistency Checks, performance tuning; SQL Server log shipping, SQL replication, scripting, Fine tune database, Function and trigger design and coding, Index implementation and maintenance, Clustering, Indexing,
• Random Forest, Machine Learning, Pentaho, Python, PowerPivot, PowerView Matlab/R, Ruby, Ruby on Rails, Agile, Waterfall, E-Commerce, Hadoop, SSAS OLAP cubes, Pentaho, Hadoop, PIG, Hive, Spark, Oracle, Hibernate, MyBatis, Spring Data
• Tableau Architect, PHP, SQL Server Integration and Analytics Services, Data cubes, Data Science, Data Analysis, Data Warehouse Architect, mapping
• E-Commerce, Hadoop, Big Data, MapReduce, Allscripts, R, HBase, Data modeling, HR Analytics, Data Integration architecture
• OLTP, OLAP, database design, performance tuning and security model implementations
• BI and analytic tools, Business Objects, QlikView, Tableau, COGNOS, GuideWire DB
• Agile, Waterfall, Scrum development methodology, Web Services, Hyperion, OBIEE, Informatica,
• Healthcare, Tapestry, FACETS, Epic Clarity, HIM, Meditech, TriZetto Reporting, Eclipsys, Allscripts, Cerner, Siemens and McKesson EMR, Epic systems, HIPPA, EDI, Revenue Cycle, HEDIS, Healthcare, SOX, E H R

PROFESSIONAL EXPERIENCE:

Confidential

SQL SSAS/ETLSSIS SSRS REPORTS DEVELOPER

Responsibilities:

• Worked as a data architecture, data modelling in relational and dimensional, data architecture and metadata management
• Used data modeling tools Embarcadero/Erwin/ER Studio and other toolsets.
• Build SSIS processes and SSAS cubes
• Developed a fully functional prototype application using JavaScript (jQuery and Backbone.js) and Bootstrap, connecting to a REST-ful server on a different domain.
• Designed, developed, and implemented internal and external application with standards-compliant code emphasis on browser compatibility, accessibility, efficient and optimized ASP, ASP.NET, PHP, Perl, CSS, VBScript, JavaScript, AJAX, jQuery, and HTML code, including data and system security, design and deployment of MS SQL and MySQL databases, graphical user interfaces, testing and documentation.
• Integrate data from SSIS processes and cubes into Excel report products
• Wrote SQL on Guidewire Database to find item, issues, claims, and reports.
• Worked with relational databases DB2, Oracle, SQL, Cassandra, MongoDB and columnar database Vertica
• Used SQL skills, querying large, complex data sets and performance analysis.
• Expert in ETL platforms, SQL, NoSQL and Hadoop Hive/Scala/Spark.
• Worked in modelling, managing, scaling and performance tuning of high volume OLTP, OLAP and data warehouse environments.
• Built Logical and Physical data models
• Worked on Performance tuning and optimization
• Worked on multiple database concepts RDBMS, OODB, ODS, Warehouse
• Worked in building and migrating data to datamarts

ETL SSIS SSRS SSAS CUBEDEVELOPER/DWBI DEVELOPER

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS for Retail, Financial, and Healthcare environments.
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Designed, developed, and implemented internal and external application with standards-compliant code emphasis on browser compatibility, accessibility, efficient and optimized ASP, ASP.NET, PHP, Perl, CSS, VBScript, JavaScript, AJAX, jQuery, and HTML code, including data and system security, design and deployment of MS SQL and MySQL databases, graphical user interfaces, testing and documentation.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Developed a fully functional prototype application using JavaScript (jQuery and Backbone.js) and Bootstrap, connecting to a REST-ful server on a different domain.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Environment: Windows, SQL Server 2005-2016, SQL Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2005-2016, OLE DB
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQL Server, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQL Server, Ms Access, Office, Windows Server.

MS SQL SERVER SSAS DEVELOPER/ETL SSIS SSRS /PENTAHO DEVELOPER

Responsibilities:

• Implemented business requirements, environment dependencies and integration points
• Wrote SQL on Guidewire Database to find item, issues, claims, and reports.
• Build SSIS processes and SSAS cubes
• Created Data Model or the Marketing Information System Team using Erwin.
• Created SSIS package for loading the data coming from various interfaces such as OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS).
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created Database Objects - Tables, Indexes, Views,Stored Procedures and User defined functions according to the requirements of the project.
• Using reporting services (SSRS) generated various reports.
• Developed a fully functional prototype application using JavaScript (jQuery and Backbone.js) and Bootstrap, connecting to a REST-ful server on a different domain.
• Integrate data from SSIS processes and cubes into Excel report products
• Developed end to end architecture designs on big data solution based on variety of business use cases
• Presented design architectures to the various stakeholders, customers, servers, Network, Security and other teams.
• Provided technical leadership and governance of the big data team and the implementation of solution architecture
• Managed the architecture design changes due to business requirements and other interface integration changes
• Provided an overall architect responsibilities including roadmaps, leadership, planning, technical innovation, security, IT governance,
• Designed, Layout, and Deployed Hadoop clusters in the cloud using Hadoop ecosystem & open Source platforms
• Configured and tuned production and development Hadoop environments with the various intermixing Hadoop components
• Provided End-to-end systems implementation such as data security and privacy concerns
• Designed and implemented geospatial big data ingestion, processing and delivery
• Provided cloud-computing infrastructure solutions on Amazon Web Services AWS - EC2, VPCs, S3, IAM
• Worked with Enterprise and Big Data Architecture, implemented, setup and worked with Hadoop
• Worked with Active Directory, LDAP, and Identity Management Integration
• Hands on experience implementation big data solutions on Geospatial data
• Expert on architecting end-to-end big data solution based on variety of business use cases
• Lead the implementation and operationalization of enterprise wide big data solution in a cross functional and cross technology/domain environment
• Expert on administration, configuration management, monitoring, debugging, performance tuning, technical resolution on Hadoop applications suit, Hadoop platform, MapReduce, Hive, HBase, Spark, Flume, Oozie, Tez, Ambari, Kafka, Pig, Storm, Falcon, Atlas, Scoop, NFS, WebFDS, Hue, Knox, Ranger, Impala, and ZooKeeper
• Worked with Oracle, SQL Server, MySQL Databases, Programming language used Java, Linux, PHP, Ruby, Phyton, R, Informatica, Tableau
• Data Modeling working with Oracle PL/SQL, data modeling and data warehousing
• Worked with star, snowflake schemas, indexing, aggregate tables, dimension tables, constraints, keys, and fact tables
• Technical expertise in data models, database design development, data mining and segmentation techniques
• Strong knowledge and experience working with ETL frameworks, reporting packages, databases, and PL/SQL programming.
• Implemented data requirements for project and solution based client needs on how the data will be used in upstream/downstream applications and accordingly guide the team on logical physical models
• Strong analytical skills and the ability to collect, organize, analyze, and disseminate significant large amounts of information with detail, accuracy, queries, identifying errors in data and presented findings
• Data warehousing tools used Data Marts, Materialized Views, Star Schema, Erwin, Oracle.
• Worked Hadoop Cloudera/HortonWorks/MapR and ecosystem components, NoSQL databases like HBase, Mongo, Cassandra
• Worked on data gathering, designing and developing scalable big data solutions with Hadoop

ETL SSIS SSRS DEVELOPER/ DATA WAREHOUSE ARCHITECT

Responsibilities:

• Created Data Model or the Marketing Information System Team using Erwin.
• Created SSIS package for loading the data coming from various interfaces such as OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS).
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created Database Objects - Tables, Indexes, Views,Stored Procedures and User defined functions according to the requirements of the project.
• Using reporting services (SSRS) generated various reports.
• Worked in statistical modeling and the end-to-end life cycle of Data Analysis
• Integrated data from Hadoop data storage, Big Data / Hadoop, using metrics from the large datasets
• Transformed data into Data Visualizations for reporting
• Developed, refined and scaled data management and analytics procedures, systems, workflows.
• Worked in the design and development of solutions for large volumes of data
• Used statistical programming languages, 'R' and Python
• Responsible for creating and maintaining Customer Intelligence Analytics Data Warehouse and Data Modeling.
• Created Source to Target Mappings and Facilitated Data Warehouse Model Reviews.
• Responsible for Customer Data Integration (CDI) participating in Data Modeling, JADs, Data Mapping and review sessions, source to target mappings, creating Business Conceptual Models, Logical Data Models and Physical Models.
• Facilitated Model Review and Mapping Sessions
• Worked with various client centers and teams to identify sources of data and the associated integration requirements.
• Developed and proposed an overall enterprise architecture to support client objectives.
• Developed prototypes and helped system development team implement the selected technologies.
• Helped identify and resolve technical challenges throughout the deployment process
• Collaborated with team, leadership, and compliance personnel to understand problems, identify solutions, and demonstrate software solutions.
• Designed and implemented state-of-the-art analytic techniques and help design our core analytics platform.
• Provided creative and technical skills, guide a team in developing cutting edge machine learning algorithms using Java.
• Developed highly-distributed algorithms in Big Data using Hadoop, Spark, MongoDB and graph databases.
• Worked in the design, development, implementation, test, documentation, and support by using standard established software engineering principles