* ***** ** ********** ** software industry with workday Integration Consultant and HCM, data/business analyst and BI developer
Over 4+ years of experience in workday Consultant.
Expert as a Workday HCM Techno Functional Consultant/Analyst.
Experience with Workday Report Writer - Custom Reporting (Calculated Fields, Advanced, Standard Reports)
Experience in Implementation of Workday HCM implementation including Compensation Management.
Maintenance and creation of Workday Supervisory Organizations, Locations, Positions, Cost centers, and Cost Center hierarchies
Good knowledge in Workday Functional HCM with responsibilities Supervisory organizations, Staffing Models, Job and Positions, Defining Business Process and security Groups, Customized Report Generation.
Hands on Workday HCM systems integration implementation experience and working knowledge on Workday Inbound/Outbound Integrations, Data Migrations and Reporting.
Good knowledge of EIB Inbound/Outbound integrations, Workday Studio, Report Writer and Calculated Fields.
Good Knowledge on Business process.
Consistent performer with excellent communication and professional skills and experienced in understanding requirements which involved preparation of functional and non-functional specification documents.
Experience in creating Job Profiles, Job Families and Job Family Groups, also worked with the creation and maintenance of position and job staffing models and Headcount Groups.
Maintenance and creation of Workday Supervisory Organizations, Locations, Positions, Cost centers, and Cost Center hierarchies.
Excellent object management skills in Workday like configuring Supervisory/Matrix Organizations (Divide organizations, Inactivate Organizations, create subordinates).
Experience in configuring and maintaining various Compensation Packages with multi Allowances, benefits and bonus packages, and in setting up compensation segment security features.
Supported the implementation of new client on the workday platform by defining, documenting and testing functional business process HCM including core HR and Periodic Compensation.
Day to day support of Workday HCM, Security, Compensation, and Reporting issues.
Experience in Workday HCM Integrations like EIB, Cloud Connect, Core Connecter, Workday Studio, Core HRMS, Payroll (PICOF/PECI) with understanding in the Business Process Flows, Case Tools, Business Analysis, and transforming them into Workday designs.
Experience in Deploying he integrations from Workday Studio to Workday applications.
Using EIB configuration, transform the format of a Workday report into required file format using XSLT or build in transformation. (CSV, EXCEL)
Maintaining the Web services code and integrations by using XML Editor and XSLT Editor.
Knowledge on SOAP and REST webservices.
Experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC)
Expertise in Microsoft Suite of products (SSIS, SSRS, SSAS, SSMS) in Development, Test, Production Environments Even managed large databases
Extensively involved in Agile methodology, developing and implementing end-to-end BI solutions
Involved in designing ETL data flows, deploying SSIS packages, creating mappings/workflows to extract data from SQL Server and worked extensively on various data sources (Excel, XML, Flat file etc.), Synchronous and Asynchronous transformations using SSIS
Interacted with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
Expertise in generating standard and ad hoc reporting capabilities from new and existing data sources.
Experience in writing the business rules using Corticon rule engine.
Experience in working with state project Medicaid ACA (Affordable Care Act).
Created a centralized area for Ad-Hoc reporting for risk, sales and Product development.
Extensive knowledge about the anti-money laundering laws (AML), procedures and practices.
Experience with AML and BSA due diligence applications.
Knowledge on Benefits and HR applications.
Experience in screening of real time transactions, customer accounts against OFAC regulated watch lists, PEP databases and negative news databases.
Adding, modifying, deleting and verifying GMSS USWOLF.
Familiar with AML/BSA/KYC laws and regulations.
Good knowledge on HIPAA standards.
Tableau Desktop 7.x, 8.x, 9.x, 10.x, Tableau Server and MSBI (SSIS, SSRS, and SSAS) 2005-14.
SQL Server 2005-14, Access Database.
SQL Server Integration Services (SSIS).
Business Process Configurations, Report Writer, Calculated Felds, EIB, Connectors Studio, HCM.
T-SQL, Python, C AND C++.
HTML, Java Script, VB Script, C#.
Windows XP, 2003, 2007 and 2010
MS SQL Profiler, SQL Query Analyzer, MS Visio, SQL Server Agent, Control-M
Bachelor of Technology in Information Technology.
Lowe’s – Charlotte, NC JULY 2017 – Present
Responsible for gathering and documenting customer requirements, designing, tracking, reporting and analyzing key organizational and operational reports.
Worked on EIB inbound and outbound Integrations for third party Vendors
Created staffing models, positions and Job management.
Implementation of supervisory organizations.
Maintained major group structures such as job codes, supervisory organizations, security roles.
Worked on different data sources in order to match requirements in Workday Reporting.
Worked on creating different staffing models.
Worked on testing the Business process.
Worked on Transfer and change job Tasks.
Created/modify organizations, Locations, Cost center, company, Region Hierarchies and assignments.
Working with different staffing models, defining hiring restrictions to positions, Job management.
Created compensation rules, grades, plans and packages.
Built industry standard reports like Matrix Reports, Calculated Fields, Conditions and Eligibility Rules that apply to the parameters of the report.
Experience in using the ETV/ XTT functions in a Custom XSLT file to transform the content into a CSV file format with validations
Worked on EIB Inbound and outbound integrations.
Built integrations using Workday Studio.
Developed Studio integrations (Outbound & Inbound) to integrate with third party systems.
Designing and development of simple, advanced and matrix reports.
Hire into Position Management, Create Compensation for new hire employees
Created custom reports and calculated Fields to fetch the required data from the tenant.
Created EIB outbound integrations and written XSLT code to send data from workday to downstream systems.
Interacted with Business analysts and end users to clarify requirements and use cases
Created test data and executed test cased for system testing.
Involved in testing and ongoing support of business reports.
Valance healthcare – Chicago, IL April 2015 – JULY 2017
Created Supervisory Organizations, Cost Centers, Cost Center Hierarchies, and location hierarchies' maintenance, and modification of Workday Business Processes and definitions
Created compensation eligibility rules based on management levels, job profile, and job family
Involved in Data Conversion, Workday Business Process Configuration.
Worked on creating custom reports for Simple, Advanced reports, Matrix Reports, Composite reports.
Used sequence generators to run reports on Monthly basis.
Integrations workday with SFTP.
Experience configuring and implementing Workday HCM system.
Created new integration to pull the new hires information using Core Connector Worker and Document Transformation which uses connector integrations XML Output as its data source input.
create calculated fields for Custom Reports to ensure required report delivery
Worked on Document transformations and applied XSLT Transformations.
Configuring EIB (Inbound & Outbound), Core Connector, CCB using Tenant and also developing Studio integrations (Outbound & Inbound) to integrate with third party systems.
Created new Studio integration to load the new hires of contingent workers.
Creating the integration Business Process, Create EIB's, Generate Spreadsheet Template, Launching/ scheduling the integration Templates.
Hire into Position Management, Create Compensation for new hire employees, Review employee hire
Involved in integration migration between tenants using object transporter.
Involved in creating and executing test plans for SIT and UAT.
Worked on supporting tickets and fixing issues based on the business requirements.
HSBC - New castle, DE Aug 2013 – Mar 2015
AML Risk /Data Analyst
The main goal was to provide weekly, monthly, and quarterly reports and analyze the obtained data to come up with better and more suitable solutions to improve our services. Another main job is to create SSIS packages, build and maintain company related databases and models
Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
According to the business requirements, Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
Worked extensively on bad data using configuring the error output, Conditional split, derived column, fuzzy lookup transformation
Created configuration files in order to deploy packages in different environments
Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables/parameters to store the data into SQL-Warehouse
Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS
Involved in creation and processing of SSAS Cubes
Identified and modified the KPI’s, measures in co-ordinance with the requirement and created calculate members in cube using MDX queries in Business Intelligence Studio using SSAS
Worked with RDBMS objects such as tables, views, indexes, stored procedures, functions, and triggers in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective
Created views to facilitate easy and user interface implementation and triggers on them to facilitate consistent data entry into the database
Created SQL queries to validate Data transformation and ETL Loading.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Used Tableau to create key dashboards to help translate raw data into visualizations for stakeholders and clients.
Created Tableau dashboards using stacked bars, bar graphs, scatter plots, geographical maps, Gantt charts, Heat maps using show me functionality.
Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
Linking SQL SERVER database to Tableau server.
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
Debugged SSIS Packages using Data Viewers, Breakpoints. Used various transformations like Derived column, Pivot, Un-pivot, copy column, merge join, union all, Lookup, audit, aggregate etc.
Created SSIS Packages using Execute SQL Task, File System Task, Execute Package Task, Send Mail Task, Execute Process Task, Sequence container and for each loop container
Generated reports like Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS)
Involved in unit testing of the SSIS packages, reports and cube re-conciliation
Created actions, filters, parameters and calculations for preparing dashboards and worksheets in Tableau.
Experience in creating the reports basing on the requirements using SSRS.
Develop and maintain the python scripts for Reconciliation process.
Created file process module using python series, data frames and data bases interactions.
Data extraction and data updates using python scripts.
Created datasets using stored procedures and reports using multi value parameters
Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
Created datasets using stored procedures and reports using multi value parameters
Created sub reports, bar charts and matrix reports
Ensuring that all the OFAC sanctioned entries are in the database with appropriate information.
Escalating the issues to appropriate teams on timely manner to mitigate risk.
Developed various gap analysis reports.
Managed the US SIGM QA team to ensure the standards of quality are being met including comprehensiveness and correctness of the list entities.
Be an integral part of the Global WOLF QA processes by following the procedures and worked with management to ensure the global QA processes include key controls that follow global policy standards, mitigate risk and include regulatory and internal audit requirements.
Creating Good Guys and testing of Good Guys in FFF classic.
Adding, modifying, deleting and verifying data in GMSS USWOLF database.
Worked on various reconciliation and certification projects.
SQL Server 2012, Excel, Access, MS SQL Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Reporting Services (SSRS), Visual Studio 2010, Erwin, ER studio
Deloitte – Camp hill, PA NoV 2012 – AUG 2013
Gathered end user requirements and developed applications and different audit functionalities depending on the requirements acting both as a system analyst and an application developer
Wrote user requirement documents and developed functions, indexes, stored procedures, views and triggers for automation. Converted fast views in to EUP views and validated data
Used Team Foundation Server (TFS) as a tool for repository of codes and version control, also maintains test scripts and documentation following the standards
Worked on UI Data pop and Meta-data for populating data in EXCEL 2013 using SQL macros
Create a Package to update the data warehouse database using SSIS
Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions
Worked with heterogeneous sources such as flat files and relational sources
Worked with various sources in the data flow tasks and used various transformations. Some of the transformation are Row count, merge, merge join, union, Look up transformation, audit, aggregate
Worked extensively on bad data with configuring the error output, Conditional split, derived column, fuzzy lookup transformation
Deployed the packages in catalog method and worked on job scheduling and send mail task
Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS
Created report in BIDS and deployed & executed in Report Manager
Took complete ownership of DB on data comparison, troubleshooting and performance
Interacted with the Business Admin and gather the requirements and analyzed them
Worked closely with clients as part of a development team to evaluate requirements and developed BI / DW solutions
Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
Involved in understanding the business requirements & existing data model
Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients
Responsible for scheduling the subscription reports with the subscription report wizard
Deployed the generated reports directly on the client’s workstation
Created Books and views using ProClarity
Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose
Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS)
Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes
Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading
Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords
Managed the migration of SQL Server 2008R2 databases to SQL Server 2012
Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations
Experience in Installing and Configuring SQL Server Active/Active and Active/Passive clusters, monitored Scheduled jobs and alerts
Implemented and successfully tested Log shipping in SQL Server 2012 and SQL Server 2014
MS SQL Server 2014/2012/2008, T-SQL, DTS, SSAS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server Query Analyzer, MDX, SQL Server BIDS, MS- Visual Studio 2012