SUMMARY:

• Overall 10+ years of Business Intelligence professional experience with 8+ years in SQL Server 2008R2/2012R 2/2014/2016/2017/2019 databases development, utilizing SSIS for ETL, SSRS for reporting and SSAS for data mining and PowerBI, Tabluea for data visualization
• Data Modeling with development of conceptual, logical, and physical data models for databases and data warehouses, and ensure high data quality, and less redundancy in relational databases
• Extensive Experience in Design, development and deployment of Power BI Dashboards and Reports using Power BI Service, Power BI Premium Capacity Management and Usage Analytics
• 4+ years of experience in developing Power BI/Tableau reports and dashboards to collaborate, publish and share visual reports with both internal and external stakeholders and clients
• Experience with installation of Windows Server 2008R2, 2012R2, 2014, installation of SQL Server 2008/2012/2014/2016/2017/2019, installation of MSBI tools (SSIS, SSRS and SSAS)
• Development of complexSQL, T - SQL, Stored Procedures, Functions, Views, Triggers, Indexes and Performance Tuning in MSSQLServer environment
• MS BI Stack (SSIS, SSRS, SSAS) with Visual Studio 2008, 2012, 2014, 2015, 2017and 2019
• ETL/ELT Developer utilizing SSIS, T-SQL (Bulk Insert), bulkcopyprogram utility (bcp), SSMS Import/Export Wizard
• Incremental loads utilizing complex SQL, T-SQL with XML and hash bytes, and/or in SSIS ETL development through Control Table or CDC, Incremental Loads
• Development of both Tabular and OLAP cubes in SSAS supporting KPI and multidimensional data mining
• MS SQL Server 2008R2, 2012, 2014, 2016, 2017 Database Administration skills including installation, auditing, database design, creation, normalization, partitioning and optimization, backup, restore, replication, scheduling and clustering
• Experience with MDM (Master Data Management) and have Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Information gathering, analyzing the information gathered, documenting the functional or business requirements
• Data Conversion, Data Migration and Data Validation from earlier versions to currentSQL server using SSIS ETL process and DTS services across different databases like Oracle, IBM DB2, MS Access and flat file
• Technical support and customer service utilizing all kinds of IT ticketing systems for IT asset, knowledge base, service level agreement, ticket management, including SolarWinds, ServiceNow and internally developed and customized service platforms
• MSSQL Data Analyst, Database Developer and database administrator
• 4+ years of experience in Oracle 11g and 12c, MySQL, IBM DB2 and other RDBMS
• Crystal Reports 2011, Access/Excel VBA, Macro, Pivot Sr.
• Software and mobile apps localization/QA

TECHNICAL SKILLS:

• Confluence
• TFS
• Jira
• Visual SourceSafe (VSS)
• SharePoint
• Agile Methodology
• C#
• VB
• .Net
• HTML
• PHP
• Perl
• Fortran
• JSON jQuery
• PowerShell
• Rest API
• R
• Python
• Machine Learning
• S-PLUS
• SAS
• SPSS
• SSIS, SSRS, SSAS
• MDX, DAX
• SQL
• MySQL
• IBM DB2
• Oracle
• XML
• HTML5 Web Database
• Power BI
• Tableau
• Azure/AWS
• Advanced Excel
• SAP Crystal Report

PROFESSIONAL EXPERIENCE:

Confidential, Roswell, GA

Data Analyst/Sr. SQL Server Database Developer

Responsibilities:

• Create various Customized and interactive Reports and Dashboards in Power BI utilizing Data Analysis Expressions (DAX) functions and operators to build formulas and expressions.
• Publishing reports toPowerBIService and providing the access to required users.
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions
• Review, evaluate, design, implement and maintain Dev/Production database.
• Write codes for database access, modifications, and constructions including stored procedures.
• Identify data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Migration of existing Procurement applications to a new environment, building, testing and maintaining MS SQL Server databases ( ).
• Utilizing complex SQL, T-SQL and Functions, Dynamic SQL and complex Stored Procedures to create SSIS packages to extract, transform and load data from Oracle, mainframe and other sources.
• Created database with specified file groups, schemas with access control for data security.
• Conducted database migration, backup, restore and recovery, performance tuning, move non-clustered indexes to other filegroups using a stored procedure, user authentication, Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Created SSIS ETL packages to migrate legacy data from Oracle database and/or other sources to new production database. Create SSIS packages to ETL data from tabular format files like CSV, Excel, Access, HTML, flat files, ordered and unordered serial files (COBOL sequential files), direct access files, computer-generated files.
• Used FOR XML AUTO and FORXMLPATH to convert data from SQL tables into XML formats.
• Bulk import JSON files with Openrowset function in SQL tables, parse the string by using OPENJSON to get access to nested data and specify explicit schema using WITH clause.
• Build, rebuild, deployment of SSIS ETL packages to dev/production enviroments in SSISDB Catalog and schedule jobs in SQL Server Agent on hourly, daily, weekly, monthly basis, troubleshooting job failures and error messages.
• Present and publish PivotTable and PivoteChart reports in Excel by making connections to SQL Server to import data in Power Query using native database query.
• Completed cources of Azure Data Migration Services, preparation and planning to migrate SQL Server databases (on premise) to Azure SQL Database (cloud).
• Utilized Azure Data Factory to move data from on prem servers to cloud, copy multiple tables in bulk, map data flows, transform data at scale, process slow changing dimensions, parameterization and email notification.
• Created reports based on samples from Access utilizing Agile development life cycle by stages and interacting with users over and over again until total satisfaction.
• Prepared scripts to partition data asper date requirements.
• Recreated indexes and transfer to new databases.
• Involved in projects to create new database from legacy sources, creating stored procedures for reporting.
• Download source data from FTP/SFTP sites, adjusting ASCII/Binary, utilizing bat files to unzip/zip, rename, move data to destinations, using PowerShell scripts to re-connect break lines in source files.
• Created database tables following COBAL File Definitions, create Stored Procedures cleansing and transforming data to specification, create SSIS ETL packages with master to run specific packages in sequence, create SQL queries translating from legacy Accessed queries for new reports and reconcile data with Access data reports, create report stored procedures and push reports to a web-based reporting tool.
• SSIS ETL Packages to help data audit and validation.
• Brainstormed detailed business and system requirements with stakeholders and report users to gather information and core components required in the reports.
• Created Ac-hoc reports using complex SQL queries, stored procedures and SSRS asper detailed business requirements.
• SSRS report migration to a web-based reporting tool, consolidation of multiple reports utilizing complex SQL, stored procedures, adding more search filters to make reports more dynamic.
• SQL performance (queries, T-SQLs and stored procs) tuning utilizing SQL Server Profiler, Query Plan to capture a history of queries, plans, and runtime statistics.
• Report development using SAP Crystal Report 2016.
• Developed SSAS multi-dimentional models with MDX and tabular models with DAX to support PowerBI dashboards and other reporting activities.
• Tech Lead coordinating between internal teams and overseas service providers for project goals and schedules.
• Provided lower level developers and new team members with basic and supervise on-boarding activities.
• Customer Service and technical support via BIA Solution Center ticketing system.
• Worked with Data Scientist in Python programming language to do further data analysis, data wrangling and data mining.
• Utilized SharePoint and TFS to get tasks, assignments, issue tracking and version control and application lifecycle information.
• Data modeling to define and analyze data requirements to support business processes through conceptual, logical and physical stages, creating ER Diagram containing major entities within system scope and inter-relationships among entities (1 to 1, 1 to many, many to many) to understand application workflow, working on queries and table design with right data types, primary and foreign keys.
• Data warehousing design to understand and analyze business needs and construct business analysis framework, creating Star, Snowflake and Fact Constellation (Galaxy) schema, normalization and denormalization to reduce redundancy and for better performance, partitioning fat tables for PowerBI.

Confidential, Atlanta, GA

Data Analyst/BI Develope r

Responsibilities:

• Created Dashboards utilizing Power BI Desktop and Tableau Desktop to visualize and analyze data, and help creating stories.
• Supported SQL Server 2008R2 - 2016 servers and operations.
• Developed and created SSIS ETL packages to extract, transform data from legacy IBM DB2 database and load data into current SQL Server Staging and ODS tables, scripting queries to select source data, removing/trimming empty spaces, transforming data types, matching columns and creating stored procedures to update data tables. Upgraded packages from .
• Worked with internal/external stakeholders and report developers to create dim and fact tables in Datawarehouse to support SSRS report developments.
• Scripts and queries performance tuning utilizing SQL Dynamic Management Views (DMVs), SQL Server Profiler and SQL Execution Plan. Researched data discrepancies between data warehouse and existing reports/data.
• Performed tuning for SSRS report dataset scripts to find out why it ran slow, creating indexes to fasten data retrieving, optimizing parameters and stored procedures.
• SSIS ETL/SSRS Package/Solution management via Source Control tools like MS Visual SourceSafe and recently in transition to Amazon Web Services (AWS) - Cloud Computing Services.
• Performance tuning, optimization, troubleshooting/debugging on queries and stored procedures in ETL/SSIS/SSRS developments.
• Deployed SSIS ETL Projects and/or Packages in Solution Explorer and scheduled SQL Agent jobs on hourly, daily, nightly, weekly, monthly basis.
• Developed all kinds of SSRS reports: ad hoc, tabular, matrix, parameterized, cascading, sub reports, drill-through/drill-down reports, stored procedure reports
• Member of SSAS development team and responsible for denormalization of data warehouse tables for preparation of SSAS cube and data mining development.
• Utilized HTML5 in support of Web SQL database development to introduce API to manipulate client-side databses using SQL.
• Developed PoweBI KPI dashboards and other reports.

Sr. Data Systems Developer

Confidential, Conyers, GA

Responsibilities:

• Data automation in a Call Center environment (SQL Server 2017 + Visual Studio Community 2017) utilizing complex SQL, Stored procedures, T-SQL and SSIS Packages.
• Created tables with column names, data types and data lengths in accordance with definations provided by insurance carriers and HIPAA instructions.
• Created reports using SSRS, Excel, develop SSIS ETL Packages to encrypt and decrypt files to and from customers/clients. Produced reports using Excel VLOOKUP function to link data to multiple worksheets and Excel Charts with vertical bands.
• Utilized Power BI Desktop to create dashboards from multiple data sources and to make ad hoc reports.
• Written complex scripts, stored procedures and developed SSIS Foreach Loop Packages to automate loading .csv files and scanned survey data into SQL Servers, cleanse and normalize data as needed.
• Export reports as per customers’ requirements by joining and pivoting tables.
• Effectively implemented Data Extraction and Loading from OLTP (call center software) onto staging, ODS tables with SSIS ETL Packages.
• Created SSIS ETL packages PIVOT Transformation with multiple measures and multiple row fields using GUI Editor.
• SSAS development using DAX for tabular models.
• Installed and configured SQL Server Cluster Nodes with network name and IP address provided by Network Admin to ensure high availability and scalability.
• Worked with DBA to install SQL Server 2018 instance to PCs and setup and install SSDT in Visual Studio.

ETL Developer /Consultant

Confidential, Woodstock, GA

Responsibilities:

• Contracted as consultant/advisor for Project Management of SQL server development, responsible for planning, preparation and setting up SQL Server 2008/2012/2014 installation of Server Core on Windows Server 2012 R2 and 2014 R2, working on data migration, including server or storage equipment replacements, maintenance or upgrades, application migration, website consolidation and data center relocation, utilizing a design (Complex SQL, T-SQL, SSIS ETL) for data extraction, cleansing and data loading, from multiple and complex data sources and formats through ETL tools, attaching, restoring/replicating, import wizard, bulk insert and/or bcp utility.
• Utilized SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes, Stored Procedures, relational database models, data dictionaries, and data integrity.
• Had a major role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing,, production support and Project review with client. Performed administrative tasks (DBA) such as database files management, security management, data integration and synchronization.
• Worked on SSIS ETL packages to transfer data from heterogeneous databases & different files format (Text File, Spread Sheet, XML and Oracle data) to MS SQL Server. Prepare and wrote documentation detailing design, coding, scripting, development, testing, deployment and maintenance. Highly motivated on programming trouble shooting and new projects.
• Acted as Database Admin to back up the data to disks, set up roles, users, monitor database activities, create triggers to audit data tables inserts, updates and deletes.
• Created reports using SSRS and Power BI Dashboards for interactive visualization.
• Utilized HTML5 in support of Web SQL database development to introduce API to manipulate client-side databses using SQL.
• Lead consultant and general contractor and I hired other contractors to do sub-systems setting up hardware, networking and server installation.
• I was responsible for the turn-key solutions from initial planning, budget proposal, implementation, migration of legacy data stored in an old or obsolete format/computer system to SQL Server 2014, through all stages of test runs until completion of full system setup and customer acceptance in satisfaction.

Localization/Data Analyst

Confidential, Atlanta, GA

Responsibilities:

• Team Lead of localization and globalization of Mobile Apps, Enterprise Mobility Management (EMM) Solutions, Management Console, Product Guides, On-Board Materials, Release Documents, Websites, Software Localization QA/Testing process for Context, Hardcoded, Layout, Time & Date Formatting Issues, bug reporting and fixing process utilizing SharePoint, JIRA, Kanban, TFS & Visual Studio.
• Utilized SQL Server and Microsoft BI Stack, ETL skills and best practice, adding derived column, sorting of data, merging of data, knowledge in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support, Data modeling, Dimensional Modeling, enhancements and maintenance.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS. SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Utilized Python scripts/programming for Web development projects and machine learning and data visualization.
• Utilized C# and/or VB in SSIS/ETL Script Task for Message Box creation, work with Variables for error handling, using Variables and Loops to create copies, loading multiple text/csv files.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Worked on SSIS to create packages to transfer data from heterogeneous databases & different files format (Text File, Spread Sheet, and XML) to SQL Server 2008/2012/2014.
• Utilized linear regression function in RStudio to forecast and predict marketing trend and tendency. Worked with data scientist/architect to make graphical analysis to support marketing team.
• Assisted database administration jobs under supervision of DBA to backup, restore and migrate data for reporting view and cube development.
• Developed a Tabular, ad-hoc Reports using SSRS, created various Stored Procedures to validate the data from source and update the records and insert them into a newly created table. Created the Indexed Views for better performance. Performed various levels of testing (Unit, Functional and Integration), with Data Profilers. Built cubes with SSAS and written MDX scripts for generating reports on top of cubes. Effective ability to work independently and as a team member on group projects.
• Set up and installed Windows Server 2012 R2 operating system on VMware Virtual Machines, configured Windows OS for installations and updates of SQL Servers 2008R2 and 2012.

Oracle Database Analyst/Operation Manager

Confidential, Cliffside Park, NJ

Responsibilities:

• Identified tuning opportunities; implement improvements and advice developers on SQL tuning options
• Interacted with application developers and management as well as database and database tool vendors
• Provided expert level support and recommendations to the Development team for Oracle DB use
• Performed program design, coding and Development
• Proven track record in data modelling, delivering Oracle based solutions - SQL queries, PL/SQL code
• Documenting database design using visualization tools
• Promote a culture of high standard data processing and surveillance modules
• Understand Control Room’s IT platforms, how they are wired together, how they interact and how would change be orchestrated in these platforms to support regulatory agendas and programs
• Developed reports utilizing SAP Crystal Reports
• Project Manager coordinating with a group of investment bankers, accounting firms, law offices to prepare feasibility studies and financial reports utilizing data from Oracle database for multi-million-dollar hydro-electric power plant projects in China.
• Worked as Operation Manager for a NY-JFK based NVOCC/freight forwarders involving both ocean and air cargo import/export shipments.
• Supported NJ/NY NVOCC/Freight Forwarders for ocean & air import & export operations. Successfully handled 2k+ ETUs and LCL compo shipments annually.
• Work as Shipping/Inventory Control Coordinator. Establish, maintain professional relationship with Chinese and other Asian manufacturers, RFQ, compare and bid on prices, track production schedules with factories to prevent or avoid possible postponement and/or delays in deliveries like financial/working capital/fund interruptions, power shortages, environmental controls, worked with freight forwarders for Allwater, MLB, LCL shipment booking, ETD/ETA and local delivery.